AlliAlosa - profile

AlliAlosa · May 20, 2022

Hi all! I wrote this script a couple of weeks ago and it’s been extremely useful for me, so I thought I’d share it here :smiling_face_with_halo: The script will find any “broken” fields - the ones that have the little red triangle next to the name ...

AlliAlosa · Oct 29, 2021

Hi all! So, here’s the use case that spurred some thinking… I have a HUGE, monster of a base that is a bit out of control. It contains many intricate rollups that drive some housekeeping/reporting processes. Now that Airtable Sync is available, I’m w...

AlliAlosa · Jun 11, 2020

Hi all! I’m looking for an app that will allow, either via direct integration or Zapier, for the dynamic creation of a pre-filled document for e-signature. There are tons of options (too many) out there, but I’ve yet to find something which meets all...

AlliAlosa · Mar 10, 2020

Hi all! Starting to dig in to the scripting block a bit more… is there a way to force the script to run automatically? Wrote a script to watch a table and make sure everything is linked to the same record on a junction table… but this is rendered use...

AlliAlosa · Feb 26, 2020

Hi everyone! I’m surprising myself by not being able to figure this out. I swear at one point or another I had been able to pre-fill an airtable form with a field that includes an emoji. For example, I want to pre-fill a single-select {Status} field ...

AlliAlosa · Sep 26, 2022

All looks good from your screenshots… but could the output of your formatter step possibly have a leading or trailing space? Sometimes it’s as simple as that :smiling_face_with_halo: If so, you could add another formatter step to trim the output fr...

AlliAlosa · Aug 22, 2022

Great question :slightly_smiling_face: I always advise wrapping calculations dealing with dates with an IF() statement to avoid errors/a result of NaN. In the case of DATETIME_DIFF(), you’ll want to use AND(), as well. Try this: IF(AND({Completion}...

AlliAlosa · Aug 19, 2022

Hi Claudio! Thanks so much for the kind words and I’m so glad you’ve found it helpful! I actually offer hourly consulting sessions, if you’re interested you can certainly sign up for a time with me here :slightly_smiling_face: Otherwise if you want...

AlliAlosa · Jun 24, 2022

Hi there! Here’s how to get the date of a sponsor’s most recent sponsorship: Add a rollup field to your [Sponsors] tablePoint it at the [Sponsorships] table, then pick the field containing the date of the sponsorshipUse the aggregate function: MAX(va...

AlliAlosa · Jun 02, 2022

Ah! Super helpful video - thank you! This is quite interesting. I believe the issue is that the contributor you’re trying to update doesn’t yet have anything in the field, {Liked}. I just did a little test on my end and confirmed that if the first li...

User Statistics

User Activity

Script to Find and Display all Broken Fields in a Base

Specifics on Synced Tables and Syncing Intervals

Dynamic Document Creation with E-Signature Capability?

Run Scripts Automatically?

Prefilling a Form with Emoji

Re: Zapier Find Record In AirTable - search Value format?

Re: Removing NaN from DATETIME-DIFF

Re: Template Suggestion - For Employees

Re: Sorting by the linked record with the most recent date

Re: [AUTOMATION] Link to records from two steps in one field