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,...
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)?
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?
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?