We have an Enterprise level account and are trying to implement a date field which will track the date that a status is changed in another field. This is all good on a move-forward basis, but we would also like to update it historically, which is pro...
I have a multiple select field I am attempting to update within an automation, but I can’t seem to add an option to it without overwriting. Pared down, this is essentially what my code looks like right now:
Val = record.getCellValue("The Cell")
if(co...
I tried to use csv import but apparently it doesn’t support importing to long text fields. I have 1100 records I need to populate a long text field for and I would prefer to not attempt a copy and paste here with such a wide margin for error. Has any...
I have an automation that I need to count all records that meet a certain criteria. The number of records that meet this criteria exceeds 100, so the find records tool isn’t useful. There is a scripting block in the automation and I would like to cou...
I had a formula that was working until this week and has now broken for some reason. I looked into the basics (did the field names for the formula change, synced fields change, anything like that) but literally nothing about the components of the for...
Airtable has a built-in snapshot feature that will provide much more richness than automation in this case! How-to guide here: Taking & Restoring Base Snapshots | Airtable Support(I do want to add that I misspoke when I said revision history would be...
I would recommend using a back-up of your base; it will be a one-time static copy of everything you have, data, automations, and record history, but won't affect the primary base operations are still based out of.
yeah totally @Katie_Haines !I will say that my solution is limited to when the multi-select field has only 1 argument already entered, you'd likely need to use a switch statement or loop to handle multiple, but the field update ended up looking like ...
Oh good idea! Didn’t even think of that. This is the article I used to guide my powershell conversion, I ended up using his exact command to fully convert, rename, and place in the directory I wanted. Then I performed a text to column to break out th...
I actually have been digging, looks like powershell conversion and some pivots were all I needed to get at the data! Thanks all. In this scenario, a csv sheet was perfect as it was only one action type and one column I was looking at.