Hairtable - profile

Hairtable · Jul 20, 2024

My Rollup field has (correctly) returned this array to me ARRAYJOIN(values) by looking at linked records (4 People) and their dietary requirements (dietary preferences are determined by a multiple select field):None,Allergy to Nuts (other than Peanut...

Hairtable · Apr 09, 2023

I've just worked on my first script for Airtable and got it how I want it for now, before taking it any further.This script runs on a Table named "Travel" and takes two UK postcodes, in fields labelled P1 and P2, passes them to the Bing Maps API, and...

Hairtable · Apr 05, 2023

Is it possible to use an Automation and a looping function to create the scenario in the subject line?I have a form to create a new record in table A, one of the fields is a manually selected number (X) from 1-20 (single select). Can an Automation ge...

Hairtable · Feb 14, 2023

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

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 · Jul 23, 2024

Try using Fillout Forms to create linked records for youhttps://www.fillout.com/help/create-new-linked-records#

Hairtable · Jul 22, 2024

Thanks @Sistema_Aotearo That function will return the 3 unique values, but it will not show me the quantity of each of those values.

Hairtable · Apr 06, 2023

Thanks for your help Adam, I'll get to work on following your solution

Hairtable · Feb 14, 2023

That’s really helpful. Huge thanks @augmented I have reformatted the dates as you suggest, and the error is gone 

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?

User Statistics

User Activity

Displaying counts of multiple and duplicate items after a Rollup field using ARRAYJOIN(values)

Script to calculate mileage between two UK postcodes

Create multiple linked records based on a number (single select) submitted in a form

Error using WORKDAY in formula with holiday dates to exclude

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

Re: Fillout + Airtable + Softr Setup for Client Portal Automation

Re: Displaying counts of multiple and duplicate items after a Rollup field using ARRAYJOIN(values)

Re: Create multiple linked records based on a number (single select) submitted in a form

Re: Error using WORKDAY in formula with holiday dates to exclude

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