Jon_Wright - profile

Jon_Wright · Dec 09, 2022

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

Jon_Wright · Oct 24, 2022

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

Jon_Wright · Oct 20, 2022

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

Jon_Wright · Oct 07, 2022

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

Jon_Wright · Sep 22, 2022

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

Jon_Wright · Dec 09, 2022

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?

Jon_Wright · Oct 20, 2022

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")```

Jon_Wright · Oct 07, 2022

Thanks for all your help Kamille, I think I’ve (you’ve) cracked it.

Jon_Wright · Oct 07, 2022

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

Jon_Wright · Oct 07, 2022

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

User Statistics

User Activity

Currency Conversion Script - Run on Input?

Free WordPress Plugin to Send Post & Page Data to Airtable (or any other webhook capable system)

IF formula based on range/array of numbers across columns

Automation - Update Record - Invalid Input Error

Add currency symbol to formula

Re: Currency Conversion Script - Run on Input?

Re: IF formula based on range/array of numbers across columns

Re: Automation - Update Record - Invalid Input Error

Re: Automation - Update Record - Invalid Input Error

Re: Automation - Update Record - Invalid Input Error