I have been staring at this too long and thinking myself into circles, need some fresh eyes! I have a base set up with 4 linked tables: schools, which are then linked to 3 program tables for SFS registrations, YF events, and Grants (2 sub-programs, A...
I'm experiencing something weird - I have a formula field ("Cheque 2 amount") set up to subtract different currency fields. All fields, including Cheque 2 amount are set to currency format with 2 decimal places. Everything looks normal in Airtable:H...
I have a "Send an email" automation set up with the trigger "when {{Date field}} is one week from now."It's working great, except the emails are going out just after midnight. I'd prefer them to go around 9am. I have added a time to my date field, bu...
I have set up an automation:Trigger> Google sheets: when a row is createdAction 1> find records where REF is [value from google sheet column with REF #s, which should match airtable REF values]Action 2> update recordAction 2 is giving me trouble. I h...
Thanks! I actually ended up putting the ROUND formula within the Cheque 2 amount field and that seems to work! IF( {Over/Under} > 0, ROUND(SUM({Approved budget} - {Cheque 1 Amount} - {Over/Under}), 2), ROUND(SUM({Approved budget} - {Cheque...
Thanks Dan! I thought something like this would work, was just hoping there was a native option using the time within the date field. But this workaround will do!
I have a long text field that is getting urls as the input, they are not automatically hyperlinking. rich text formatting is enabled. anything i can do?
Thanks ScottWorld! I only need to update one record at a time - when a new row is created in my google sheet, only one record needs to be updated based on that trigger. So am I ok?
