sam-lsf-lst - profile

sam-lsf-lst · Aug 20, 2024

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...

sam-lsf-lst · Jun 12, 2024

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...

sam-lsf-lst · May 17, 2024

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...

sam-lsf-lst · Feb 27, 2024

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...

sam-lsf-lst · Jun 12, 2024

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...

sam-lsf-lst · Jun 07, 2024

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!

sam-lsf-lst · May 31, 2024

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?

sam-lsf-lst · Feb 28, 2024

Thank you TimeSavingsCo! I had some duplicates hiding in the background that I wasn't aware of. That seems to have fixed the issue! Much appreciated

sam-lsf-lst · Feb 28, 2024

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?

User Statistics

User Activity

Base design: same programs, different years - junction table needed?

Formula field set to currency with 2 decimal places but getting up to 14 in token

Automation when DATE is Today - Change Time

Automations: Update record when google sheets row is created based on REF

Re: Formula field set to currency with 2 decimal places but getting up to 14 in token

Re: Automation when DATE is Today - Change Time

Re: Hyperlinks

Re: Automations: Update record when google sheets row is created based on REF

Re: Automations: Update record when google sheets row is created based on REF