Page flow with block visibility

I’ve been trying to use custom code to show or hide a block depending on an field located on the user record in Airtable. The idea is to present blocks to user sequentially. Using custom code, I’m able to do this fine, except for the fact that things are delayed. Here’s an example of how it should work :

  • User click a button (say a one click update button)
  • This updates some status field in Airtable
  • An airtable formula field has changed in the user record
  • A block visibility depends on the result of said formula field.

As stated, I can do that either with User groups, or using custom code, but in both cases it takes minutes to update. What would be the best strategy to tackle that problem and trigger an instant refresh ?