User specific columns and Airtable Sync

Hi

Thanks again for your help with this Jeff - think I got to the bottom of it!

I’ve put below what the Issue seemed to be - and suspect it was bad practice on my part (but you live and learn),

Adding an entry was actually quick - things showed up in Glide instantly (and then sync’d over to Airtable as @Jeff_Hager explained)

But I was grouping on a “Status” field - which was a Linked record field in Airtable (linking to a separate “Status Table” in Airtable).

In Glide, my choice component was set to write to the linked field in Airtable. Doing this meant that there was a lag of a few seconds between updating the Status in the Glide App and it being written to Airtable, then another lag when it was sent back to Glide (I guess?)

The solution for me (and again, I suspect this is written as best practice somewhere!) was to write the status to s simple text field (and have the choice component look up the options from a table in Glide) You can see this quite clearly in the videos on the links below. Works like a charm now!

The only issue I have now, is making a relation somehow in Airtable. I’d like to set up some Airtable automations to send emails when a comment is added to an issue for example - but as there is no linked record / relation set in Airtable - I just can’t see how to do that. (But will keep trying)

Videos are (in case it helps others)
Slow - Transfer - Dropbox
Snappy - Transfer - Dropbox

Regards and thanks,
Andrew

3 Likes