Forum Discussion
Laura_Thacker
6 years agoQrew Commander
I would build a single-formula-text field that lists the items which are missing (based on your Date fields) - I would not convert your date fields to checkboxes for this type of purpose. You can make this a formula-rich-text field and use colorization to make it stand out; but as you are new to Quick Base, the format below is something you can build-from.
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------
//First we define the output text if an item is missing var text application=If(IsNull([Application]),"Application",""); var text signedPD=If(IsNull([Signed PD]),"Signed PD",""); var text cbcForm=If(IsNull([CBC Form]),"CBC Form",""); var text dualEmployment=If(IsNull([Dual Employment]),"Dual Employment",""); var text trainingCert=If(IsNull(),"Training Cert",""); //Next we define if there are missing items var bool missingItems=$application <>"" or $signedPD <>"" or $cbcForm <>"" or $dualEmployment <>"" or $trainingCert <>""; //Next we define an optional text value to describe what the items are that will list var text prefix=If($missingItems=true,"Missing Items: ",""); //Now we list all the "missing" items in a simple-list formula List("\n", $missing, $application, $signedPD, $cbcForm, $dualEmployment, $trainingCert )
Then add this formula-text field to your report with the Hiring Manager as a separate column against your list of employees.
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------
- AndreaJohannes6 years agoQrew TraineeThank you! I will try this - it probably would be easier for my users to see a list in one column per employee than the way I had it in excel.
------------------------------
Andrea Johannes
------------------------------- Laura_Thacker6 years agoQrew CommanderAndrea,
In my opinion it is easier for users to read 1-column of data than to scan their eyes across multiple columns to get the same information. If you do, however, prefer the checkbox-system; then @Babi Panjikar's solution is equally valid. I always try to display more in less columns so that users are not forced to scroll excessively. You should be able to copy and paste that formula and then just correct the field names.
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------