Make 'add' button on inline related records once again point to its correct, system-generated form

Hello,

I have a parent table Jobs, and a table of related child records ServiceDetail.  In the system-generated Jobs_Detail view, you can see the related ServiceDetail records displayed in its inline view within the yellow square pictured below.

www.appsheet.com_9.png

When I click the 'Add' link circled in red, instead of being taken to the system-generated ServiceDetail_Form showing all fields that should be available for input, I'm taken to a form I created for a completely different purpose - ServiceDetailAccounting_Form, which displays a small fraction of the fields that used to and should be available for input. 

How do I point the 'Add' link circled in red to the correct, system-generated ServcieDetail_Form as used to be the case?

Here are screenshots of the Related ServiceDetails VC definition:

www.appsheet.com_10.pngwww.appsheet.com_11.pngwww.appsheet.com_12.pngwww.appsheet.com_13.pngThanks!

Solved Solved
0 3 92
  • UX
1 ACCEPTED SOLUTION

Aurelien
Google Developer Expert
Google Developer Expert

Hi @Cubinche 

Custom-made view takes over system-generated views.

If you have multiple custom views, there is no way for AppSheet to know which one to open.

For different purposes, I would recommend:

- creating slices, for example ServiceDetail_purpose1, ServiceDetail_purpose2.

- creating table views based on these slices, with the same names ServiceDetail_purpose1 and ServiceDetail_purpose2, and set their position to First

- cilck on Save (==> it will create system-generated views for these slices)

- set their position now to Ref, and click Save again

- in the table Jobs, create twin-like virtual column referencing to these slices, for example:

virtual column [Related ServiceDetail_purpose1]:

REF_ROWS("ServiceDetail_purpose1", "JobID")

 and

virtual column [Related ServiceDetail_purpose2]:

REF_ROWS("ServiceDetail_purpose2", "JobID")

Then, you have to create a condition to display the one you need to display.

You can do so there:

Aurelien_0-1750222633567.png

 

View solution in original post

3 REPLIES 3

Aurelien
Google Developer Expert
Google Developer Expert

Hi @Cubinche 

Custom-made view takes over system-generated views.

If you have multiple custom views, there is no way for AppSheet to know which one to open.

For different purposes, I would recommend:

- creating slices, for example ServiceDetail_purpose1, ServiceDetail_purpose2.

- creating table views based on these slices, with the same names ServiceDetail_purpose1 and ServiceDetail_purpose2, and set their position to First

- cilck on Save (==> it will create system-generated views for these slices)

- set their position now to Ref, and click Save again

- in the table Jobs, create twin-like virtual column referencing to these slices, for example:

virtual column [Related ServiceDetail_purpose1]:

REF_ROWS("ServiceDetail_purpose1", "JobID")

 and

virtual column [Related ServiceDetail_purpose2]:

REF_ROWS("ServiceDetail_purpose2", "JobID")

Then, you have to create a condition to display the one you need to display.

You can do so there:

Aurelien_0-1750222633567.png

 

Thank you very much, @Aurelien - not only for the solution I'm about to begin working on, but for the important insight that custom-made views take over system-generated views. I hope to come back tomorrow after working on the problem to mark your generous contribution as my accepted solution 😊

Bingo! It works like a charm, @Aurelien. I also learned a whole lot from your few short words yet exceptional insight and communication skills. Thank you so very much 😊

Top Labels in this Space