Delay in accessing a new row in a related table

1

Hi,

I have a form that enters patients into a table. That form allows the user to put in the patient’s MRN (medical record number) into a field, and uses filter functions to show the patient’s basic demographics (rather than entering them manually).

The formula for the filter functions look like this:
Patients.Filter(MRN= thisRow.[MRN/Patient Acct No] ).[Last Name].First()

That all works great. My issue comes when the patient doesn’t already exist in the Patients table. What I want to do is to have the user fill out a quick form to add the patient to the Patients table. The problem is that when they do this, the filter functions don’t work for more than 1 minute after adding the new row. I’ve confirmed they’re immediately showing up in the Patients table, but the filter functions just can’t pull them in for more than a minute. Refreshing the form does not affect anything.

Is there some way around this?

2

If you embed a form on a coda page (in your main doc) and use this page for new data entries, you don’t have this problem. When using a form by itself in a browser window, the form is accessed through a (Coda) server, and then new form entries take a little to be processed.

An alternative method is to use a button to open a modal to create a new record:

activate(AddRow([YourTable]))

and then hit ‘back’ (top left in your modal) when done.

1 Like