formula URL to replicate the QB cancel button
We have a form that has a button that links the user to an external page out of QuickBase. If the user decides to click that button then we want the form to be cancelled and a new record not created....
Forum Discussion
Hi Jeff,
If you are running into the experience that when clicking a button that links away the record is being saved one thing to check is the advanced settings for the table. One of the options covers the save behavior "Save parent record automatically when a child record is created", sometimes with a linkaway if that option is checked Quick Base can autosave the record instead of cancelling out. If you try turning off that checkbox you might get the behavior you are looking for without needing a different formula function.
If you are running into the experience that when clicking a button that links away the record is being saved one thing to check is the advanced settings for the table. One of the options covers the save behavior "Save parent record automatically when a child record is created", sometimes with a linkaway if that option is checked Quick Base can autosave the record instead of cancelling out. If you try turning off that checkbox you might get the behavior you are looking for without needing a different formula function.
- Thanks for the quick response. Unfortunately, that option is not checked for this table and would not resolve the problem.
The form has a button and if clicked the record should be cancelled (not saved), the QB window should redirect to the table's homepage and another tab opened with the window the link pointed them to. It sounds like something a formula-URL could handle. I just didn't see anyway of mimicking the cancel button with a formula, or javascript.
