Is it possible, for a number of checkbox fields, to write a formula that will concatenation all of the field names for those fields that are checked (Airtable automatically adding those field names to the string, not using SWITCH or other operators)?
I’m trying to work this one out but I don’t have sufficient coding experience to really crack it.
I’m looking to generate an image into a dedicated field, based on a record’s {firstname} {lastname} fields.
Examples of code to do this are here: javasc...
I have two tables:
‘events’
‘people’ (including single select field for ‘dietary requirements’)
I can assign multiple people to each event. I then use a rollup field in ‘events’ linking to ‘people’ and the ‘dietary requirements’ field with this simpl...
There’s an option to create a Zap from a New Record in View Trigger to Create a (Google) Document from a Template.
As Zapier says: “Creates a new doc based on an existing one and can replace any placeholder variables found in your template doc, like ...
I have this formula, and it works (!) for two checkbox fields; it deals with and/or combinations of ticked/unticked states.
IF({First field}=1, IF({Second field}=1, “Do this and that”, BLANK()))
&IF({First field}=0, IF({Second field}=1, “Do this”, BL...
Could you have a view filtered on « if field (in new record) contains “word” »
Then an automation triggered by “when record enters view” (above view name).
Would this combination work for you?
This is a massive help. I’ve used Airtable-Zapier-Bannerbear to progress this since your reply. It’s looking good :slightly_smiling_face: Much thanks. @ScottWorld
Hi,
I have setup a button (from a URL field) in my global template to open a form to submit update requests (with prefills), just as you helpfully describe …
In the synced table, I can pull in the URL to display fine, but the button field does not di...
Not sure how to get that working. I’ve tried but …
If you go have time to detail a walk-through in Zapier, it would be great to learn how to implement this.