The tutorial by Jonathan Bowen has been incredibly helpful.
So far my script calculates the sum of the “Amount” in the “Monzo Transactions” table.
My next step is to figure out what to add to the script so that the next part of the process will upda...
Hi people!
I’m building a “Birthdays” table in my “Calendar” base and I’m looking for a formula that says:
if “Birthday” is within the next 2 months then display “soon”
What would this formula look like?
How would I go about exporting multiple page designer layouts as images into an attachment field?
-Could I use or create a script to do it?
-Is there any free Airtable apps that allow this?
I provide more visual context in the link below:
...
Hi folks,
I’m trying to find a numerical value from the “Title” field and have it appear in the “amount” (e.g. 27.21)
I’ve used this formula from looking at a few post’s but it only copies the values before the decimal:
MID(
{Title},
FIND(
“For”,
{T...
Firstly I wanted to acknowledge how helpful you have been by sharing your knowledge and videos.
Thanks for the reminder of the docs, it certainly helps to understand a bit further and to clarify what I am trying to do.
In this example, all transactio...
It works! but I have to filter out next years birthdays or it goes a bit haywire and can’t be filtered using the “Soon” field once the formula is used.
Thanks Jonathan!
I’m still having a problem here. No errors from the formula but the formula labels ALL of the records as “Soon” in the formula field regardless of date.
This formula only copies the current date/time field, but I want to remove the date part:
DATETIME_PARSE(Start, ‘HH:mm’)
getting close but not quite there.
