Qrew LegendYes, you can certainly have URL formula buttons to view or edit on a particular form, but I really recommended against this practice. The problem will be endless user frustration with the from opening up for view or edit on the "wrong" form, causing them to need to push a button on the form to switch to the correct form and in fact two buttons needed for every form as the user may want to View or Edit. Then after Edit, the form is likely to save and redisplay to the user on the "wrong" form.
So my suggestion is to make one form with form rules to show / hide ideally whole sections or whole Tabs and then place the common data entry field sin a section at the top of the form.
So I hesitate answering your direct question as it's going down a path which will lead to user frustration. But if you really want to know, you can post back and I will reluctantly answer. :)
Hi Mark,
The button is only clicked for data entry, creating a child record. If the button has the case in it, why would it lead to the wrong form?
I tried using Sections, which I think would work if I could make the field show up twice on the form such that it only appears once because sections are hidden based on a form rule. But although you can add some fields twice to the form, you can't add all types of fields multiple times to the form. Even then, I still might run out of form rules.
There are 19 types of Juice and about 50 fields for data entry. There are just too many combinations with just enough overlap in fields to make it super complicated.
I really wish I could just add some more form rules.
Qrew LegendThere is no practical limit to the number of form rules as long as they are based on scalar (data entry) fields for the rule. But you will need 50 rules, once for each field.
So, if you do want to go with multiple forms and you have a use case where you are creating child records, then yes, you can make an Add Child button on the Parent record which will use the correct form to Add.
I suggest that you use make a formula text field on the Parent called
[Child Form Number]
Case([Juice Type],
"Type 1", "11", // these are the form ID's on the forms list.
"Type 2", "12",
"Type 3", "13",
etc
"Type 20", "31")
The Add Child button can look like this
URLRoot() & "db/" & [_DBID of the child table]
& "?act=GenAddRecordForm"
& "&_fid_xx=" & [Record ID#] // populate Related Parent
& "&dfid=" & [Child Form Number] // set the correct form
Then similarly, you would lookup the [Child Form Number] down to the child record. Then make two fields on the Child form for View ad edit.
[View]
URLRoot() & "db/" & dbid() & "?a=dr&rid=" & [Record ID#]
& "&dfid=" & [Child Form Number]
[Edit]
URLRoot() & "db/" & dbid() & "?a=er&rid=" & [Record ID#]
& "&dfid=" & [Child Form Number]
Then for the embedded child table on the parent form, configure it to have those two fields as the first two columns of the report and edit the report so as to deselect Allow View and Allow Edit. That will suppress the native eyeball and edit pencil icons on that embedded report, forcing the user to use your buttons which will select the correct form.
