Why in the Forms view, when I customize columns the associated details disappear from the bottom of the form?
I have two tables:
Table#1: Clients (Ref: ID_Client# = Unique())
Table#2: Jobs (Ref: ID_Job = Unique())
When I create a โClientsโ table view:
1- All the columns are listed in the view.
2- All the jobs related to this client are listed below
So far, so good !!!.
When I specify the Columns Order to limit the information shown in the table form,
the associated job list below disappears !!..
Questions:
1-How do I get the associated Jobs list back in at the end of the table view?
2-How can I customize the Jobs list to show the columns I am interested in?
PS: I am an old dinosaur engineer that is two weeks into AppSheets.
Iโm not sure if I got you right but you might be talking about the Inline view (Which is the table view you see of all the rows from another table that are pointing to the row of the current detail view. At least by default)
This view is made thanks to a Virtual Column of basetype List that has key values from another table.
Itโs called โ[Related SOMETHING]
โ and you need to add it on your Column Order under the Detail View config.
If Iโm wrong about it, you can post some screenshots
SKr,
You are rightโฆ .The last column in the is the {Related SOMETHING} I added that column and the references showed up right away.
Now, a follow-up question. How do I control what columns from the [Related SOMENTHING} show up on the litthe table at the bottom of the form?
Inline views are not meant to be inside a form, just a Detail View.
But there are some things you can do to show an inline view inside a form. To that point I think you should have a better understanding of some of the core features of AppSheet as well as the column types and functions.
You are gonna make it, take your time!
If you werenโt talking about the Form View and your questions is just about โhow to change the inline viewโ, you can follow this:
Inline views are 90% of the time created automatically.
Make sure you have activated an option called โShow system viewsโ thatโs inside UX
Search for โInlineโ and you will see a view that are named this way: TABLENAME_Inline
Look for the one that has the info you want to change itโs column order and edit that. You will see that there are some options unavailable like changing the name of the view. But the rest of it is like any other view.
By default itโs a Table View type. You can change the column order as you have learned above to hide/show just the columns you want
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |