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 ...
For some reason, the side panel URL uses a base64 encoded string, making it very difficult to formulaically recreate the URL.If you decode the string, it looks something like this: {"pageId":"{{pageID}}","rowId":"{{recordID}}","showComments":false,"q...
You just need to switch the order of the parameters in the months part of the formula.I would also change NOW() to TODAY() - NOW() is known to have a large impact on performance and slow down your base.Finally, I would wrap the whole thing in an IF()...
Just checked and the link I posted yesterday does still work! You can see the demo at around 51 minutes in (but the whole episode is worth watching) hope it’s helpful!
As @BrandyN11 mentioned, the concept of a "previous" record does not exist in a database.You can accomplish this with linked records by linking each transaction to all the transactions that came before it (based on a date/time or in your case, a sequ...
