I have a table containing a PostCode column, and Address columns 1 to 6, all of type “single line text”. I wish to know which of the columns contains the PostCode and will use SWITCH(PostCode,Address1,1,Address2,2 …). However even when I can see whic...
Hi, I have followed How to create email digests with automations – Airtable Support
and all works fine except, how do I prevent the email going when no records are found i.e. the email should only go when the action in step 2 (Find records) has found...
I have a table of Items and a table called Used, that has just a date time field and a link to Items.
In a grid view of Items, when I click a checkbox it should create a Used record for that Item, with date set to now.
I also need a way of clearing t...
Exported in preparation for a re-import and found the same issue in Excel. So used a Hex editor and sure enough there was a hidden character. So problem solved and not an Airtable issue. Thanks for responses.
RJ @ Airtable gave me this, which works fine for me.
“there is a workaround in which you can insert a script action after the Find records step to achieve this – check out the video here to guide you through how to do it!”
