I am using a modified version of the currency conversion script kindly provided in this thread https://community.airtable.com/t5/development-apis/custom-currency-calculations-using-scripting-panel/td-p/136067 by @Vivid-Squid but I don't want to have ...
Hi all, thought I’d let everyone know about a new WordPress plugin I’ve just published to improve my content workflow process which is built around Airtable.
Useful for bloggers, content publishers, etc. who publish on WordPress and use Airtable to m...
I have 4 columns in my table, each containing numbers.
In the Formula column called ‘Above Threshold’ I’m trying to create a formula that says if any of the values across the 4 columns is >100 output ‘Above’ and if <=100 output ‘Below’.
So something...
Hi all - I’m trying to run an automation using a 3rd party Webhook. When a new Post is sent live, or updated, in my WordPress site I want to send various bits of info about that Post to AirTable.
Everything works fine when I use ‘Create Record’ (so I...
I have 3 columns in my table that contain an amount range e.g. 3500;4800
What I want to do is split that string out into Budget From & Budget To fields, like this:
I’ve managed to do the actual splitting how I want using this formula for the Budget...
Thanks for response. Do you mean this one https://airtable.com/developers/scripting/examples/currencyconverter ? If so, I tried that first and couldn't get it to do what I want. How would I modify either script to give me the results I'm after?
Pretty sure I’ve worked it out by using ‘Max’.
IF(MAX({Users (last 30d)},{Users (last 30d-60d)},{Users (last 60d-90d)},{Users (last 90d-120d)})>=100, "Above Threshold", "Below Threshold")```
@Kamille_Parks - Sorry, I think I’ve kinda worked out what you mean now (now I’ve spotted the conditional actions section in the UI). This is where I’ve got to. The last step, update record, is still causing me issues though.
Hi Kamille - Thanks for the response but you have lost me there a bit, so hoping you can clarify.
I have a single webhook that is called on both post creation or post update. In my AT table I have both Post ID & Post GUID, I want to use Post GUID as ...
