Hairtable - profile

Hairtable · Nov 04, 2022

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)?

Hairtable · Feb 16, 2022

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...

Hairtable · Oct 04, 2019

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...

Hairtable · Mar 18, 2019

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 ...

Hairtable · Feb 07, 2019

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...

Hairtable · Nov 21, 2022

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?

Hairtable · Feb 16, 2022

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

Hairtable · Nov 06, 2020

Is now working well. Your answer and time taken is much appreciated.

Hairtable · Oct 30, 2020

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...

Hairtable · Mar 21, 2019

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.

User Statistics

User Activity

Use a conditional formula to create text string containing a field name

Create a profile image (as seen in MS Teams) using initials from {firstname} {lastname}

Creating a count of same items from single select field

Airtable-Zapier-Google Doc (mail merge)

Multiple IF statements using '&', how to re-write?

Re: How to SEND AN EMAIL based on NEW RECORDS based on a condtion trigger

Re: Create a profile image (as seen in MS Teams) using initials from {firstname} {lastname}

Re: Question about Sync

Re: Question about Sync

Re: Airtable-Zapier-Google Doc (mail merge)