I'm puzzled by an error I am coming up against ... We pay our service providers' invoices (received by Monday) ten working days later (so, typically two weeks later). Using this formula, I get the result I want for a date of Monday 20/2/2023 being Mo...
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 ...
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...
