I’m trying to update a multiple select field based on info from an api. There’s 30 some values that will either be Yes or blank. If it’s yes, its works fine and puts the correct value, but gives an error if it tries to add nothing to the multi select...
How could I use a script that does this to update two fields in my table?
IF(FIND(",",{Name}),TRIM(MID({Name},SEARCH(",",{Name})+1,500)))
I know it works fine as a formula but I don’t want a formula field since I want to link the email to another tab...
How would I calculate days in foster care from the intake date to today but have it stop counting once the animal’s status is adopted? Ive got the intake date and adopted date but wasnt sure how the formula should be worded.
an example of the info
I figured out a round about way. Zapier to google sheets to an airtable automation. It’s not pretty, kind of slow and I’m getting two records for every new email for some reason but I’ll figure it out later. Thanks for checking. I don’t think linking...
Correct. All i’m pulling is the name, email, and name of the file attached. I’m part of an animal rescue and need an easier way to check for new adoption contracts than digging through hundreds of emails when what i’m looking for may already be marke...
