Link/button to open specific form
I have a report that lists customers. When I choose a customer it brings up a form that has a ton of useful summary info about the customer brought in from many parts of the application (this i...
Forum Discussion
no problem
here is the formula
urlroot() & "db/" & [_DBID_CUSTOMERS] & "?a=dr&dfid=XX&rid=" & [related customer]
You get the [DBID_CUSTOMERS] which is the name of your Customers table from the Advanced Settings for the table.
The dfid ("da form ID") is from the URL you see when you preview the form.
Then you need to either feed it the record id ("&rid=" & [the field containing the record id of the customer]) or else you can also feed it a key field instead ("&key=" & [my key field])
here is the formula
urlroot() & "db/" & [_DBID_CUSTOMERS] & "?a=dr&dfid=XX&rid=" & [related customer]
You get the [DBID_CUSTOMERS] which is the name of your Customers table from the Advanced Settings for the table.
The dfid ("da form ID") is from the URL you see when you preview the form.
Then you need to either feed it the record id ("&rid=" & [the field containing the record id of the customer]) or else you can also feed it a key field instead ("&key=" & [my key field])
- This works great, but to take it one step further, would there be a way to automatically call up the print function so that I could print using the specific form rather than just displaying the record using the specific form? I have a form that includes a ton of information, but only certain information is needed when the record is printed. I've created the form to use for printing and created the formula URL button using your suggestion below, but rather than just directing my user to a different form and then them having to choose "More" and "Print", it would flow a lot better if the formula URL button just pulled up the print function using the specific form for printing.
- Try this as a UIRL formula field
URLRoot() & "db/" & Dbid() & "?a=printr&dfid=14&rid=" & ToText([Record ID#])
This will print using form ID 14. - Works great! Thanks Mark! And thanks for the quick reply!
