Default checkbox when loading a form
Hi everyone, I have an expense app for employees to enter expenses and get reimbursement. It references another table with a field on it for "Has Company Credit Card". If that box is unchecked wh...
Forum Discussion
The problem with the form rule is that it is always going to set the checkbox based on what is on the team report.
So let's say, for example, an employee like me has a personal credit card and a corporate card. I use my personal card for 90% of the items and want the reimbursable checkbox to be checked by default. But I need the ability to override it and uncheck it.
If I uncheck it wont it reset to be checked again every time the form loads?
------------------------------
Ivan Weiss
------------------------------
So let's say, for example, an employee like me has a personal credit card and a corporate card. I use my personal card for 90% of the items and want the reimbursable checkbox to be checked by default. But I need the ability to override it and uncheck it.
If I uncheck it wont it reset to be checked again every time the form loads?
------------------------------
Ivan Weiss
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendHence my suggestion not to use a checkbox. I suggested making it to be a text multiple choice field so that it it was blank, you would be able to default it., but the user could override to "yes' or "no".
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- ah I missed that....
Okay so what I did is the second option. If the has company card is unchecked AND reimbursable is blank I fire a change on the reimbursable line to make it reimbursable.
That works great for anyone without a card.
However, if you do have a card it does not default to No (non-reimbursable) and I cannot create another form rule to "change" the same value on a form. So how do I get the second condition to work right?
------------------------------
Ivan Weiss
------------------------------- MarkShnier__YouIn fact you can have two rules acting to change the same field on the form, as long as you know that they will not conflict ie they wont both try to fire.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- ah for some reason I thought you could not. So we are all set, that is working! Thanks Mark!
------------------------------
Ivan Weiss
------------------------------