Hi there,We have acquired another company that also uses Airtable. Both we and the new company have our own client lists in Airtable and we would like to combine these, as we have some shared clients already, without (at this stage) merging the Airta...
Hi guys,Simple question really:If I change the name of a field that has been referenced by a script in an automation, will the script break or will it update automatically?I daren't test it and unfortunately I don't know how to script to create a tes...
Morning! I'm having trouble getting Airtable to recognise the output of this formula as a date. It is basically saying "if it's in this city/country, you need to begin the project x,y or z number of months before the required by date". The last "othe...
Hi there,Hoping someone can help with something I hope can be automated. I have multiple fields with numbers in, let's say:Field 1A: 100Field 1B: Field 2A: 250Field 2B:Field 3A: 500Field 3B:I then have a % field, based on which I would like an automa...
Hi All,Hope someone can help!In our base we have multiple Proposals (in one table) linked to each single Sales Opportunity (in another table).I would like the proposal's naming convention to be "{Sales Opportunity} - Proposal 1", with any further Pro...
Hi Hannah,Not the answer to your specific question, but can you instead create a Country table where you track countries and their respective regions? You can then specify the country as a linked record and add the region as a lookup. This will displ...
Hi Melinda,You may just need formula field using a concatenate formula, which would be something like:concatenate({Speaker 1 - Name},", ",{Speaker 2 - Name},", ",{Speaker 3 - Name})The field names are in curly brackets {} and then I've added ", " to ...
Thanks Kuovonne.I hope to pick up some JS knowledge over time which will of course result in lots of testing and I'm sure you'll see more of me posting questions as I do.Thanks for your help!
You're just missing a bracket around the first Frequency field:IF({Frequency} = "Yearly",DATEADD({Latest charge}, 1, 'years'),IF({frequency} = "Monthly",DATEADD({Latest charge}, 1, 'months'),"")) And actually I think I made a mistake, in that you don...
