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