I have my user table in Airtable and I am finding that when I add a record directly in Airtable, the syncing takes FOREVER sometimes. Other times it is fine.
Anything going on right now that seems to be causing this? I use an automation to add directly into the user table on Airtable using Zapier. Softr just doesn’t seem to sync this fast enough.
Any ideas to fix this?
I FIGURED OUT A SOLUTION!!!
Inside my Contacts (USERS) table in Airtable i have a formula field called “INCOMPLETE PROFILE CALC” with the formula:
IF(
AND(
{ZIP Code},
States,
City,
Birthday,
Pronouns,
Gender,
Ethnicity,
{Languages Spoken}
),
BLANK(),"YES"
)
Inside my Education Programs table in Airtable (AND ALL TABLES) i have a simple formula field called “YES” with the formula:
"YES"
Inside my Education Programs Details page on Softr I have this block with the Device Visibility to she when the Profile is INCOMPLETE:
HIDE BLOCK IF:
YES from Education Programs table Record
IS NOT
INCOMPLETE PROFILE CALC Contacts table Record
& the reverse block:
Inside my Education Programs Details page on Softr I have this block with the Device Visibility to she when the Profile is COMPLETE and they can sign up for the Education Program:
HIDE BLOCK IF:
YES from Education Programs table Record
NOT
INCOMPLETE PROFILE CALC Contacts table Record
I just tell them to refresh the page, and it is almost instant with the User Caching turned off, or fairly fast with it turned on, just tell them to wait 5 minutes and then refresh the page if User Cache is turned on!
SCREENSHOT BELOW:
INCOMPLETE PROFILE EXAMPLE:
COMPLETE PROFILE EXAMPLE:
Well done and thank you for sharing the solution with us all!
I have like 10 more that I am still trying to figure out the best way to share, I am a sponsored developer for Airtable & design custom SDK scripting solutions and just moved over to SOFTR and figured out a workaround to just about every problem I had a year ago, so would love some help with that!
That’s awesome! We’d love to hear all of the others as well when you have time =) thanks!
