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.
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:
Thanks!
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:
User | Count |
---|---|
17 | |
11 | |
7 | |
3 | |
2 |