Skip to main content
Question

Saving a record to be completed later with Required fields

  • May 23, 2022
  • 0 replies
  • 93 views
My client is looking for a user to be able to start a New Space Request and at any point be able to save where they are to be able to come back later to finish it and submit it. However, they also want several fields to be required in order to ultimately submit the request. Of course having all those fields required won't let the user save in the middle to come back later. Any suggestions on how to make this scenario work?

------------------------------
Chris Swirtz
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
You will need to make a formula field to list the missing fields and show that as a warning at the top of the form.
var text warnings =
List("<br>",
if(trim([field 1])="", "Missing field 1"), // example of a text field
if(isnull([field 2]), "Missing field 2"), // example of a numeric field where blank not treated as null
etc.... )

IF($Warnings<>"","<font color=red>" & $Warings)

Then let them chnage a status to "Submitted" only when the warnings are cleared.


------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement