Inline Form Data not showing

[Dave_Willett]

Hi. I have several records against 1 JobID and REF_ROWS setup correctly, however no records show in the inline form? Can anyone help?

[FREDY_ORTEGON]

Can I see the structure of the “appQuotes.csv” table?

[Dave_Willett]

As attached, Thanks

[FREDY_ORTEGON]

Try placing the “jobid” field as a reff type and pointing to the primary table.

The virtual column with the referenced fields must be created automatically.

[Dave_Willett]

That didn’t work unfortunately. Regards

[FREDY_ORTEGON]

What other table has apart from “appQuote.csv”?

[Dave_Willett]

I think I have it. QryTransport.csv has a numeric ‘key’ column, AppQuotes.csv has a text ‘key’ column.
How do I fix this guys?

Cheers

[FREDY_ORTEGON]

you have to relate those two tables.
by means of a reff column

In the “AppQuotes.csv” table, place a new column called “IdQt”(NO virtual) of type reff and in the Source table configuration select the “QryTransport.csv” table. in the excel sheet “AppQuotes.csv” in the “IdQt” column you will place the ID codes of the “QryTransport.csv” sheet that relate to “AppQuotes.csv”. This article can serve you:

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so that your data makes sense.

[Dave_Willett]

Hi Fredy, all sorted now thank you, I added a different column and synced the two together, all is well in the app world.
Kind Regards

[Dave_Willett]

[Dave_Willett]

QryTransport.csv holds the REF_ROWS(“AppQuotes.csv”,“JobID”)

From the view ‘TransportToday_Detail’ there is an action, which goes to another view within this app: LINKTOFORM("AppQuotes.csv_Form”, “Ref”, [JobID],“JobID”,[JobID])

The JobID is carried over to the AppQuotes.csv_Form, the rest of the data is enterred and saved.