Why in the Forms view, when I customize columns the associated details disappear from the bottom of the form?

[FTong]

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.

[SkrOYC]

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

[FTong]

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?

[SkrOYC]

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!

help.appsheet.com

AppSheet Help Center

[SkrOYC]

Felix.P_Tong:

How do I control what columns from the [Related SOMENTHING} show up on the litthe table at the bottom of the form?

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:

1. Inline views are 90% of the time created automatically.

2. Make sure you have activated an option called “Show system views” that’s inside UX

3. Search for “Inline” and you will see a view that are named this way: TABLENAME_Inline

4. 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.
   

   

5. 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