Listing Required fields not completed
I am in need of some brain power to figure out how to go about listing all required fields not completed. For a Work Order to be deemed "Active", several different fields must be completed. These f...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYes, that is a great technique. A sure way to get hated around the company water cooler is to make users fill out 100 fields before they can save. It's very unfair to the user experience. So as you suggest, a better way is to put a field at the top of the form for warnings or exceptions - whatever you call it and then using a form rule do not allow them to Submit (ie flag the record is being ready for the next step) until they clear the warnings. You can use form rules to hide the warning field if its blank to close up the space.
Here is an example of such a warning. this would be a formula Rich Text field.
var text Exceptions =
List("<br>",
If(Trim([Project Name])="","Missing Project Name"),
If(Trim([Channel])="","Missing Channel"),
If(Trim([Company])="","Enter your Company"),
If(Trim([Branch])="", "Missing Branch"),
If(Trim([Account#])="", "Missing Account#"),
If(Trim([Territory Sales Rep Code])="", "Missing Sales Rep"),
If(Trim([Project City, Prov])="", "Missing Project City, Prov"),
If(Trim([Cost Centre])="", "Missing Cost Centre"),
If(Trim([Attention:])="", "Missing Dealer Attention Name"),
If(Trim([Attn. Email:])="", "Dealer Attention Email"),
If(ToText([Suggested Resale to Dealer ($)])="0", "Missing Suggsted Resale to Dealer"),
If(Trim([Volume Opportunity])="", "Missing Volume Opportunity Detail"),
If(ToText([Competitor Price ($)])="0", "Missing Competitor Price"),
If(ToText([Expected Ship Date])="", "Missing Expected Ship Date"),
If(Trim([Delivery Terms])="", "Missing Delivery Terms"),
If([# of Missing CSP Product Descriptions] > 0, "Some Attributes are Missing Descriptions"),
If([Pictures or Samples?]="", "Please specify if sending Samples or Pictures in Attributes Section"),
If( (Contains([Pictures or Samples?], "Both") or Contains([Pictures or Samples?], "Pictures")) and [# of Pictures Attached]=0, "Please attach Missing Pictures under Project Notes / Docs / Pictures Tab"),
If([Sort of Status Choice]=7 and Nz([Price for Customer Acknowledgement Form])=0, "Price for Customer Acknowledgement is Missing"),
If([Sort of Status Choice]=11 and ([Item # Setup by MFA])="", "Missing Product Code")
)
;
If(Trim($Exceptions) <>""
"<font color=Blue><b>The submit button will appear in View mode when the Warnings are cleared</b><font color=Red><br>" & $Exceptions )
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Here is an example of such a warning. this would be a formula Rich Text field.
var text Exceptions =
List("<br>",
If(Trim([Project Name])="","Missing Project Name"),
If(Trim([Channel])="","Missing Channel"),
If(Trim([Company])="","Enter your Company"),
If(Trim([Branch])="", "Missing Branch"),
If(Trim([Account#])="", "Missing Account#"),
If(Trim([Territory Sales Rep Code])="", "Missing Sales Rep"),
If(Trim([Project City, Prov])="", "Missing Project City, Prov"),
If(Trim([Cost Centre])="", "Missing Cost Centre"),
If(Trim([Attention:])="", "Missing Dealer Attention Name"),
If(Trim([Attn. Email:])="", "Dealer Attention Email"),
If(ToText([Suggested Resale to Dealer ($)])="0", "Missing Suggsted Resale to Dealer"),
If(Trim([Volume Opportunity])="", "Missing Volume Opportunity Detail"),
If(ToText([Competitor Price ($)])="0", "Missing Competitor Price"),
If(ToText([Expected Ship Date])="", "Missing Expected Ship Date"),
If(Trim([Delivery Terms])="", "Missing Delivery Terms"),
If([# of Missing CSP Product Descriptions] > 0, "Some Attributes are Missing Descriptions"),
If([Pictures or Samples?]="", "Please specify if sending Samples or Pictures in Attributes Section"),
If( (Contains([Pictures or Samples?], "Both") or Contains([Pictures or Samples?], "Pictures")) and [# of Pictures Attached]=0, "Please attach Missing Pictures under Project Notes / Docs / Pictures Tab"),
If([Sort of Status Choice]=7 and Nz([Price for Customer Acknowledgement Form])=0, "Price for Customer Acknowledgement is Missing"),
If([Sort of Status Choice]=11 and ([Item # Setup by MFA])="", "Missing Product Code")
)
;
If(Trim($Exceptions) <>""
"<font color=Blue><b>The submit button will appear in View mode when the Warnings are cleared</b><font color=Red><br>" & $Exceptions )
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
- Mark,
Exactly!!! Trust me, I don't want to be the topic of gossip around the water cooler!! There is enough of that already!! LOL
Rather than requiring 100 fields be completed prior to being allowed to submit the record, I would rather require say 4 fields so that the record can at least be generated with a bare minimum of information and thus get in to the system. It would be considered "Pending" at that point because it doesn't have all of the required information to be "Active".
Then I would want a report to list all work orders which are in a Non-Active (i.e. Pending) status and which have missing information.
I can already generate a report listing all Pending Work Orders, and all other needed information. The issue I am having is how do I compile a list of all missing fields for each individual work order and present that in the report? Ideally I would want it to be a single column that lists each missing field all together in a single cell in the report for each work order. As each field is populated, the list shrinks for that particular work order.
I like the idea of having a warning at the top of the form, but the user wouldn't see it unless they had that form open. So having both a report on the dashboard and the warning in the form I think would be the ideal way to go. What do you think?
So for the warning field, based upon the fact that you provided some excellent code as an example (thanks for doing that!!!), I am assuming that the Warning field would need to be a Text Formula Field. Am I correct in that assumption?
Thanks for the in depth response Mark and, again, for the snippet of code as an example.
Also, which range is that behind you in your profile pic?
------------------------------
Andrew Fry
------------------------------- MarkShnier__YouThe mountain range is in Switzerland (probably St. Moritz) and the Intuit jacket is back from the days when the Company had larger budgets for giving Christmas presents to Quick Base Solution providers. :)
As for a report, just put that warning field on a report and filter the report where the warning field is not blank. Yes, this is a formula Rich Text field if you want it to be in red, or if you just want plain text and not fancy, then make it a formula text field and change the separator on the list function from
"<br>" (that means in html to break to a new line)
and change that to
"\n" (which is the non HTML marker to break to a new line)
The new line will make the individual missing fields list vertically.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- Fantastic!! Thanks for the info.
------------------------------
Andrew Fry
------------------------------
