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

AppSheet AppSheet Q&A
1

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
www.appsheet.com_9.png463×613 17.9 KB

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.png
www.appsheet.com_10.png975×697 39.1 KB

www.appsheet.com_11.png
www.appsheet.com_11.png972×700 28.2 KB

www.appsheet.com_12.png
www.appsheet.com_12.png981×697 42.7 KB

www.appsheet.com_13.png
www.appsheet.com_13.png977×705 37.3 KB

Thanks!

2

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
Aurelien_0-1750222633567.png762×274 21 KB

3 Likes
3

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 :blush:

1 Like
4

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 :blush: