Hi - If i have company > projects > invoices realtionship in my table and an automation triggers on a company update, what is the best way to find the invoices for that company?
I am trying to avoid lookups + helper columns and use scripting instead,...
Hi,
I am reading a date from a field and want to include it in an email (as part of an automation).
How do I go about converting the date that looks like this “2021-02-10t11:30:00.000z” into something like this - 10/02/2021 11:30am (or similar)?
Than...
Hi, I have a few tables and i want to trigger an automation when a record is added in table 4 but go up the tables to get a value from table 1.
Houses > Rooms > Items > Reciepts (best example I can think of!)
When a new reciept is added I want to sen...
Hi - I have a table set up like this:
Contractors (details of people)
Jobs (individual jobs)
Each contractor will have new jobs assigned to them. I would like to know if a job has been assigned more than 5 days ago. What is the best way to do that?
T...
This was helpful thanks! I didnt realise that those options were not available to me because I was trying to use them on a string :slightly_smiling_face:
Thanks!
That works, thank you! Do you know if its possible to style the result colum (the fomula) so it looks like a single select / lets me group like a single select? I could just use automations here i suppose?
