Formula URL syntax for form direction
I'm working on the second of 6 'products' that we're building, and we require a button that determines which form should be used based on the [PRODUCT] field. If the product is X, then use this form ...
Forum Discussion
Use one of two forms on the same table?
Here's how the url breaks down including form id [fid]
https://[domain].quickbase.com/db/[dbid]?a=dr&rid=[rid]&dfid=[fid]
[dbid] is your database (app) id
&a=dr is view record; a=er would be edit record
&rid=[rid] is the record id of the record you're working on
&dfid=[fid] chooses which form to use.
So create a rich text formula field that will display as a button and use the if statement to pass the [fid] parameter based on your condition.
Here's a thread with a little more discussion about doing pretty much exactly that:
https://community.quickbase.com/quickbase/topics/link-button-to-open-specific-form
For an alternative, if the forms are pretty similar you could use dynamic form rules to show/hide/whatever you need the forms to do differently. Form rules are a little more intuitively conditional than formula buttons.
Here's how the url breaks down including form id [fid]
https://[domain].quickbase.com/db/[dbid]?a=dr&rid=[rid]&dfid=[fid]
[dbid] is your database (app) id
&a=dr is view record; a=er would be edit record
&rid=[rid] is the record id of the record you're working on
&dfid=[fid] chooses which form to use.
So create a rich text formula field that will display as a button and use the if statement to pass the [fid] parameter based on your condition.
Here's a thread with a little more discussion about doing pretty much exactly that:
https://community.quickbase.com/quickbase/topics/link-button-to-open-specific-form
For an alternative, if the forms are pretty similar you could use dynamic form rules to show/hide/whatever you need the forms to do differently. Form rules are a little more intuitively conditional than formula buttons.
- Followup comment, Kyle, if what you're having trouble with is the IF statement itself or more broadly the formula in your formula field, post the formula(s) as you have it, and the errors it's throwing, and somebody will usually be along to help you debug it.