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
MarkShnier__You
Qrew Legend
Qrew LegendIs it possible to change the Reimbursable field to a yes/no multiple choice required field displayed as a radio button?
That way you can have a simple form rule which says when [Has Company Credit Card (lookup)] is unchecked
and [Reimbursable] is blank,
ACTION
Change Reimbursable to no.
You could also have an opposite rule
[Has Company Credit Card (lookup)] is unchecked
and [Reimbursable] is blank,
ACTION
Change Reimbursable to yes.
In both cases set the rule to fire all the time (deselect that trick checkbox at the bottom of he form rule configuration.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
That way you can have a simple form rule which says when [Has Company Credit Card (lookup)] is unchecked
and [Reimbursable] is blank,
ACTION
Change Reimbursable to no.
You could also have an opposite rule
[Has Company Credit Card (lookup)] is unchecked
and [Reimbursable] is blank,
ACTION
Change Reimbursable to yes.
In both cases set the rule to fire all the time (deselect that trick checkbox at the bottom of he form rule configuration.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
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__YouHence 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
------------------------------- 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
------------------------------