Hi beloved Airtable Community!
I’ve got an issue with a VALUE formula.
I have a Rollup field that does a ARRAYUNIQUE job from a Lookup Field which is formatted as a % (i.e. 36%).
The output I get from the Rollup field is a string (i.e. 0.357142852346...
Hi all,
I’ve been spending around 2 hours trying to understand what I was missing in a simple “if X superior to Y, then show X, otherwise show Y”…
Here’s a screencast of what’s happening, can’t believe my eyes :Screencastify
I have Y = 11.8
If I chan...
Hi there,
I’m read lots of topics here on updating single select fields in Airtable, but none through Airtable Automations.
My input is a formula that generates a status (UPCOMING, IN PROGRESS, SENT) and the desired output is to copy this value in a...
Hi kuovonne,
Many thanks for your help, MAX function worked it out!
No idea why that worked - and not VALUE - but I’ll remember the trick :winking_face:
Have a nice day!
Hi all, thanks a lot for your answers!
Did manage to transform the lookup value by adding a &’’ at the end of the string, don’t know what it really changed but it works now - didn’t work when I was just using the value formula.
VALUE({NumberIWant}&’...
Hi @Kamille_Parks, thanks for your very clear & creative answer!
I do understand now better how automations work :winking_face:
Thanks again and have a nice day!
Somehow I managed to make the automation work with a “when a record is updated” trigger but the problem is that it won’t update the stock record unless those records are actually modified…
