Rows not appearing on view

Lance
New Member

I have a strange issue in which my new rows do not appear in a view.

For example, the user would only see rows one through five. Row six has been added but does not appear in the view. The row is not getting filtered out by any of my formulas.
The rows have twelve fields that are foreign keys.

There are only two ways that I found out how to make it appear:

  1. Press โ€˜Saveโ€™ in Development
  2. Resync after a few minutes

Any help would be appreciated! Thanks

Solved Solved
0 4 415
1 ACCEPTED SOLUTION

I"m betting this is whatโ€™s happening: the inline view is set so it only shows you the first 5 rows (this is the default behavior).
2X_a_ad33780be8ceff1ceeb0035468a0c1f84a6a7bf1.png

It looks like this:
2X_0_02497e733931e02de61901283fc8c85c8e4c6cf5.gif

If you want to show more rows in the inline view, you need to adjust the Max. nested rows for the detail view youโ€™re looking at:
2X_f_f6ab0143fa3345a8cef92bc15a82225f5abed4e3.png

View solution in original post

4 REPLIES 4

Are the rows being created inside an inline view? Could you provide a screenshot of your problem?

I donโ€™t know how to take a screenshot of it since it is a issue with showing a row.
If this helps, the process is as follows:

  1. User is entering information in the form view
  2. There is an inline section in the form view that shows all the rows in another table that have a foreign key to the main row. The user creates the rows through that.
  3. Appsheet syncs immediately after submitting.
  4. While the rows are created, an SQL view fetches the primary key of the main row and all of the other rows created in the inline (11 maximum).
  5. The display view (the one that is not displaying the newly added information) is supposed to reference all of the foreign keys back to their rows.

you might look into cloudapp for screen shots and quick recordings; I find it to be really handy.

I"m betting this is whatโ€™s happening: the inline view is set so it only shows you the first 5 rows (this is the default behavior).
2X_a_ad33780be8ceff1ceeb0035468a0c1f84a6a7bf1.png

It looks like this:
2X_0_02497e733931e02de61901283fc8c85c8e4c6cf5.gif

If you want to show more rows in the inline view, you need to adjust the Max. nested rows for the detail view youโ€™re looking at:
2X_f_f6ab0143fa3345a8cef92bc15a82225f5abed4e3.png

Top Labels in this Space