Time and Date for If a Field was Changed?
Hi Folks, I'm not sure this is the best way to put this together, but here is my scenario. I have 1 table (Intersections) that includes fields for "Name" (Text), 5 different "Route" Checkboxes, 5 different "Route Sequence" (Numbered 1 - 50ish), "Status" (Dropdown choice). Caveats: Each Intersection "Name" can have multiple "Route" Checkboxes checked. My Questions are: I would like to capture a Date Time, if the "Status" Dropdown was changed. AND Create a report based on the last Status time. (If Row Item status was changed within the last Day, add to report). Is there any way to do that? Thank you for any assistance. Will ------------------------------ William Wallace ------------------------------
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 when a user starts a new expense I want the field "Reimbursable" to default to checked. However, I do want the user to be able to override it and uncheck it in case they should not reimburse. So how can I conditionally set the "starting point" for a checkbox but allow the user to override it? ------------------------------ Ivan Weiss ------------------------------
Multiple-condition form rules not working (what am I doing wrong?)
Hello all, Have a multiple condition form rule set up to change a certain field and make it read-only when certain options are selected from a drop-down menu further up the form. No form rule warning here, so not sure why the multiple condition rule is not triggering on the specified field. When "RV Site", or "Tent Camping" is selected from the uppermost drop-down menu, the "location field" is meant to change to "spring creek park" (as per the rules shown in the first image), and become read-only. Beating my head against the wall trying to figure out why this isn't working. Thank you. ------------------------------ Coleman DuCharme ------------------------------
User input formula field
Is there a way to create a field/column that is a required field, user input and formula field at the same time (without using automations or pipelines)? The scenario is I have 2 columns: Column 1 is a required & user input field. Column 2 is a formula field. If column 2 has value then column 1 can be left empty OR If column 2 has value, copy value to column 1 only if it is empty (since it is a required field) Or do I not have choice but to manually input a value in Column 1?
Question on Address type fields?
Hi, I have a table with 2 fields of type Address, let's call them: LocationA and LocationB. Depending on some business logic (basically if LocationB is not set) I'd like to set: LocationB = LocationA. Unfortunately, I noticed that we do not have in Quickbase field type: Formula - Address. I know I can do this via a Pipeline. But I'd like to know if there is a way this can be done via formulas somehow. Any help on this question will be appreciated. Thank you. ------------------------------ Jorge P ------------------------------Clearing data from multiple fields based on a selection in a drop-down field
In the app I am currently working on there are several sections where a user may select yes or no from a drop-down and if yes is selected, another section appears with data entry fields to be filled out. My client would like it so that if a user were to go back and change a yes to a no, that it would not only hide that section again but also clear any data entered in those fields. I am fairly certain I can do this with form rules, however, I wondered this could also be achieved via Pipelines? Which do you think would be cleaner? ------------------------------ Chris Swirtz ------------------------------How to get values from a fields on the form and display them?
I'll have a form with Main Contact(text), Invoicing Contact(text), Second Contact (text) and etc. Need to find a way to store all this information in one field and display it on a form. ------------------------------ Olena Bilinska ------------------------------
