ContributionsMost RecentMost LikesSolutionsRe: Is there functionality to require a field only if a specific value is selected from another field?This is perfect, thank you so much!Is there functionality to require a field only if a specific value is selected from another field?Hi, I have a field called "Decision", where the dropdown selections are either Approve or Decline. I am looking for a way to configure the system where if the user selects Decline, the text box field beside it must be populated. If the user selects Approve,__I would l like to have the text box field optional. Currently, I've just left the text box as required and told any user that selects Approve to just write "N/A". Is there any way I can configure it in this manner in QuickBase? Thanks! - SamRe: Is it possible to set up a relationship between two fields that allows you to narrow choices.I haven't had experience with it, but was also looking into this possibility of Conditional Dropdowns this morning actually. It looks like this can be done only through a reference field from a relational table. So if you were to create a separate table for those multiple choice fields and join it to the table you are looking to add this to,then you might be able to get it to work. https://help.quickbase.com/user-assistance/conditional_dropdowns.html This link helps explain it a bit more.Default a blank/null value for a required fieldHi, I have a table-to-table relationship where I have a link in Table1 to create a new record in Table2. When the new record is created in Table2, some of the fields in that form are pulled from fields in Table1. I have a field in Table2 (not associated with any field in Table1) that needs to be required. However, when a user is entering information into this form, I would like for that field to default to a blank/null value. By doing this, it would require the user to actually pay attention to this field and pick the correct value rather than ignoring it and leaving the default value as is. I've tried to do this in QuickBase, where the field in Table2 is a drop down that is required but has no default. However, when I click the link in Table1 to add a new record to Table2, the following error page populates: <qdbapi> <action>API_AddRecord</action> <errcode>50</errcode> <errtext>Missing required value</errtext> <errdetail> Sorry, you did not supply a value for the required field named "Date Decision Approved" with field id 51. Please provide a non-blank value for this field. </errdetail> </qdbapi> Is there any way to get this field to default to a blank/null value but also be required? Or, if you have any ideas of how to circumvent this that would help as well. Thanks! - SamRe: I need to trigger a notification on a date change in a date fieldHi, Through the table Settings --> Notifications, subscriptions, & reminders --> Notifications, you can set up notifications to be sent out if a specific field is modified. Have you tried that yet? Re: Why won't my dropdown order change even though I've switched the sorting back and forth?Okay I see. I played around with some of mine that were pulled form another table a bit but couldn't figure it out either - sorry about that.Re: Why won't my dropdown order change even though I've switched the sorting back and forth?Is this dropdown a Text - Multiple Choice field (where you enter in the different selections for the dropdown) or is this dropdown being pulled from another table?Re: Using the equals(=) operator when referencing a date to a number in an IF statementThanks Chris and Dan, the ToDate() function worked fine in this scenario!Using the equals(=) operator when referencing a date to a number in an IF statementI am looking to create a numeric formula field in a table. I am looking to define a specific number based on the date in a field called "Period Tested". For example: If Period Tested = 01-01-2016, display the number "1" If Period Tested = 02-01-2016, display the number "4" etc. I've written it out as such: If([Period Tested]="01-01-2016",1, [Period Tested]="02-01-2016",4) I am using theFormula - Numbertype for the field. I get the following error when I try to save: The expression [Period Tested] on the left hand side of the operator "=" is of type date while the expression "01-01-2016" on the right hand side is of type text. The operator "=" cannot be used with these types of expressions. I'm not sure how to circumvent that in the system exactly, but I need the final number to show based on the date from the Period Tested field. Any idea how I can work around this? I looked a bit and didn't find any operator that could replace the equals(=) in this scenario. Thanks for your time!Re: How can I add a target goal for each individual column in a chart?Actually a great idea. I'll have to play around a bit to get the number of tests per month+year into a field, but if I can get that done the stacked bar chart will definitely be a good idea. I appreciate your help!