TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
Delete Multiple Columns
Hi folks, looking for a dig-out here...
I created 120 columns/fields of the wrong type: they were meant to be of "Type: Formula-Number" but created them as "Type: Number" by mistake.
It's very laborious to delete each column at a time. Is there any method to delete lots of columns in one batch??? That would be so handy!
Hope so! Thanks, Luison

Luison Lassala
Date Created
11/19/2021 4:08:04 AM
Date Updated
11/19/2021 3:52:06 PM
basenine 11/19/2021 5:54:17 AM
Hello Luison

Unfortunately there’s no ability to mass delete columns….bummer
Also, if you’re importing a spreadsheet, there’s no option to select a Formula column type when creating a new column…..also bummer
You can “change type” by viewing the column. You’ll see a “change type” button…
Press that rather than delete them all 👍

Luison Lassala 11/19/2021 5:59:33 AM
Thanks Brett, I was afraid of that :-(
Yes, I had imported them from a spreadsheet - then I realised they were of the wrong Type and remembered that Formulas cannot be imported, so I started changing their Column Type rather than deleting them and creating new ones.
But I thought I'd ask the question in case there was a 'magic' process whereby this could be achieved in bulk.
cooper collier  11/19/2021 7:30:44 AM
If the table has none or easily recreated relations.
You can export the table to csv
delete all the columns you do not want

Create another new table with no columns
import the csv

when you check everything is as needed and ok
then remove the old one

Luison Lassala 11/19/2021 7:50:29 AM
@cooper collier - good suggestion, but unfortunately that table has a lot more fields and several relations and a very sophisticated set of Form Behaviours. So creating a new table was not an option.
What I should have done is promote the Development Branch on which I am working BEFORE I created the new columns, and then start a new Dev Branch just for those - but never thought it through properly before I acted.
Anyway, the job is done now: I changed the Column Type for the 115 new columns, and all is good now.
Thanks for your suggestions.
basenine 11/19/2021 3:52:06 PM
The positive in all this is that you’ll know for next time.
We’ve all done it ourselves before…grey hair to prove it!
Back to Search Results