Inline Form Data not showing

AppSheet AppSheet Q&A
1

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

2X_c_c9fd7e5983de33be5b6fff59c06029bba75f33c3.png
2X_c_c9fd7e5983de33be5b6fff59c06029bba75f33c3.png1133×738 83 KB

2

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

3

2X_2_292eb9cd07e3b87401ff4edc4f7bfe9343875b45.png
2X_2_292eb9cd07e3b87401ff4edc4f7bfe9343875b45.png1896×199 240 KB

As attached, Thanks

4

2X_b_b5f39508638c26dbd846e7530e0b92a0b975cba4.jpeg
2X_b_b5f39508638c26dbd846e7530e0b92a0b975cba4.jpeg1349×651 65.3 KB

2X_a_ab78ca45f027db17b6b16d6de056e18345ca0481.jpeg
2X_a_ab78ca45f027db17b6b16d6de056e18345ca0481.jpeg1344×644 64.9 KB

5

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.

6

That didn’t work unfortunately. Regards

7

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

8

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.

9

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

10

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:

11

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

2 Likes