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 · Nov 26, 2024

Not sure I’m understanding fully, but this might help… I demoed how to create an html table of linked records on BuiltOnAir a few years ago. I use this technique all the time and it works very well! Check out the demo here: https://youtu.be/H-WOu1_mX...

AlliAlosa · Oct 22, 2024

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

AlliAlosa · Jun 01, 2024

Hi there! Try the SUBSTITUTE() function.SUBSTITUTE(SUBSTITUTE({Field Name}, ">", ">"), "<", "<")

AlliAlosa · May 22, 2024

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

AlliAlosa · May 22, 2024

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!

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: Formula field capabilities to create html containing variables from table fields with line items

Re: How to Create a Button That Opens a Specific Record’s Side Panel in an Interface?

Re: Help with formula

Re: AGEING DOGS USING THEIR DATE OF BIRTH

Re: I would like to find the cumulative balance by referring to the previous record value.