Fields
Manny,
Question about field types, how do we set up field types to ensure that the data is unique and in a specific format?
For example, the social security number should be in the following form...
Forum Discussion
Aparna,
Great questions!
To your first question, we cannot force a specific format in the data (like the SS# for example) but we can add in help text for people to (hopefully) follow
"Must be Unique" is the filed property that lets us tell Quickbase that we cannot repeat that data - this is what we would select for any information that cannot have duplicates
Formula fields can be used to calculate values - including age based on DOB. These arent covered in the fundamentals curriculum but will be mentioned and showcased (along with resources) during Week 7 & 8
To create the gender question scenario we would leverage "Form Rules" that would look at what selections are made within the form and then either show or hide fields based on wether additional information is needed
To make fields required, we would leverage the "Must Be Filled In" checkbox in field properties
Best!
------------------------------
Manny De La Cruz
CS Team Lead
Quickbase
------------------------------