Requiring Field through Formula - URL button
Hey QB Community, I'm looking for some help...I'm using a formula url button to allow users to submit a record while in View mode. When clicked, the formula checks a Submitted checkbox as true. I'm ...
Forum Discussion
Hello Heather,
Can you provide us with the code you have in the button? From what I can tell with the information provided is that you do not have a redirect in your button, so it performs the action and the rule is working, but since there is not a redirect, it just shows the XML response for the request. If you do have a redirect, then there may be more to it. One other potential option is to just edit the button itself. If the required field is blank, then do not display the button, but display some text that that specific field is required. For example, if(isNull([Number]), "Number is Required", Button Formula). Then if the number is null, there is not a button to press. But if the number is present, then the button will appear and should work as expected. Another option is to have two functions for the button, if the number is null, take the user to another small form that asks them to enter the required value, if the number is not null, then check the submitted box and move on. These are just some ideas without seeing the whole process or the current button formula.
Error codes can be found on the Quick Base API Guide page 357. https://help.quickbase.com/api-guide/quickbase_api_guide.pdf. However, it does not have code 88, but I would assume it is an error based on the fact that a form rule prevented the API from completing its task.
------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------
Can you provide us with the code you have in the button? From what I can tell with the information provided is that you do not have a redirect in your button, so it performs the action and the rule is working, but since there is not a redirect, it just shows the XML response for the request. If you do have a redirect, then there may be more to it. One other potential option is to just edit the button itself. If the required field is blank, then do not display the button, but display some text that that specific field is required. For example, if(isNull([Number]), "Number is Required", Button Formula). Then if the number is null, there is not a button to press. But if the number is present, then the button will appear and should work as expected. Another option is to have two functions for the button, if the number is null, take the user to another small form that asks them to enter the required value, if the number is not null, then check the submitted box and move on. These are just some ideas without seeing the whole process or the current button formula.
Error codes can be found on the Quick Base API Guide page 357. https://help.quickbase.com/api-guide/quickbase_api_guide.pdf. However, it does not have code 88, but I would assume it is an error based on the fact that a form rule prevented the API from completing its task.
------------------------------
Brandon Drake
JHI Group
Monroeville OH
------------------------------