Hello Friends,
I have a user form with 9 fields. One of those fields is a drop-down with two values - Open, Closed. When the user opens the form, I want to drop-down value to default to Open. Then the user can fill out the remaining fields and submit the form.
In screenshot # 1, I made changes to the expression to default to Open as required. But when the user submits the form, the value is not being saved to the record list (Screenshot #2). It's just a blank field in the record list.
Been banging my head on the keyboard and can't figure out this issue. Any help would be greatly appreciated. Thanks!
Discussion posts and replies are publicly visible
There's a few ways to do this, but I always prefer to use local variables to default the value and save into the rule input on submission of the form. You know that they must click the submit button to complete the form, so it's a convenient place to transfer any data from one variable to another. Here's some sample SAIL:
a!localVariables( local!status: "Open", a!formLayout( contents: { a!dropdownField( label: "Status", choiceLabels: {"Open", "Closed"}, choiceValues: {"Open", "Closed"}, value: local!status, saveInto: local!status ) }, buttons: a!buttonLayout( primaryButtons: a!buttonWidget( label: "Submit", style: "PRIMARY", submit: true, value: local!status, saveInto: ri!status ) ) ) )
Peter,
Copied below is the change I made according to your code snippet.
a!localVariables( local!status: "Open", a!dropdownField( label: "Status", choiceLabels: {"Open", "Closed"}, choiceValues: {"Open", "Closed"}, value: local!status, saveInto: local!status One thing I am unsure of is how do I include the saveInto: ri!status portion into the existing code snippet below? buttons: a!buttonLayout( primaryButtons: { if( local!creating, a!buttonWidgetSubmit( label: "Submit Anomaly Record", style: "PRIMARY", saveInto: { a!save(ri!record.createdOn, now()), a!save(ri!record.createdBy, loggedInUser()), a!save(ri!record.updatedOn, now()), a!save(ri!record.updatedBy, loggedInUser()), a!save(ri!documents, reject(fn!isnull, ri!documents))
You can add it in as an a!save() as well. So here would be your new save into:
saveInto: { a!save(ri!record.createdOn, now()), a!save(ri!record.createdBy, loggedInUser()), a!save(ri!record.updatedOn, now()), a!save(ri!record.updatedBy, loggedInUser()), a!save(ri!documents, reject(fn!isnull, ri!documents)), /*New save for status */ a!save(ri!record.status, local!status) }
I made the code changes you recommended but the status still isn't being saved to the record list. The drop-down field loads "Open" as the default value as intended and the form submit with no expression errors. But when checking the record list, the status value is blank as seen in my screenshot above.
Some background info....the application I'm working on was created using the Quick Apps Designer. So [by system default] there are two separate files that controls this form - a file which contains the form details and another file which contains the primary button submit expression. I have attached two text files containing the SAIL expression for each file.
Can you please look them over and see if you can figure out why the status isn't being saved to the record list?
I have spent the last 5 hours trying to figure this out and I'm just spinning my wheels. I would greatly appreciate any help. Thank you!
SAIL code for the form field details:
a!localVariables( /* The local variables store the options for the Pick Single / Multiple from List fields * * We only show the active options, plus any inactive options already stored on this record */ local!statusOptions: a!refreshVariable( value: if(ri!record.status.active,rule!LQGAL_RemoveInactiveValues(rule!LQGAL_GetAllStatus(), null),rule!LQGAL_RemoveInactiveValues(rule!LQGAL_GetAllStatus(), ri!record.status.id)), /* Ensures this is only calculated on initial load and not each time you update ri!record */ refreshOnReferencedVarChange: false ), { a!sectionLayout( label: ri!label, contents: a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( label: "Barcode", labelPosition: if(ri!readOnly, "ADJACENT", "ABOVE"), instructions: if(ri!readOnly, "", ""), helpTooltip: if(ri!readOnly, "", ""), placeholder: if(ri!readOnly, "", ""), value: ri!record.barcode, saveInto: {ri!record.barcode, if( isnull(ri!record.barcode), {}, a!save( ri!record, rule!V16_Transform(rule!V16_EX_GetTireRecord(ri!record.barcode)) ) ) }, refreshAfter: "KEYPRESS", required: not(ri!readOnly), readOnly: ri!readOnly, validations: if( len(ri!record.barcode) <= 200, "", "Value may not be longer than 200 characters. You have entered " & len(ri!record.barcode) & " characters." ) ), a!textField( label: "Article Number", labelPosition: if(ri!readOnly, "ADJACENT", "ABOVE"), instructions: if(ri!readOnly, "", ""), helpTooltip: if(ri!readOnly, "", ""), placeholder: if(ri!readOnly, "", ""), value: ri!record.articleNumber, saveInto: ri!record.articleNumber, required: false, readOnly: or( ri!readOnly, ri!automatic ), validations: if( len(ri!record.articleNumber) <= 200, "", "Value may not be longer than 200 characters. You have entered " & len(ri!record.articleNumber) & " characters." ) ), a!textField( label: "Tire Size", labelPosition: if(ri!readOnly, "ADJACENT", "ABOVE"), instructions: if(ri!readOnly, "", ""), helpTooltip: if(ri!readOnly, "", ""), placeholder: if(ri!readOnly, "", ""), value: ri!record.tireSize, saveInto: ri!record.tireSize, required: false, readOnly: or( ri!readOnly, ri!automatic ), validations: if( len(ri!record.tireSize) <= 200, "", "Value may not be longer than 200 characters. You have entered " & len(ri!record.tireSize) & " characters." ) ), a!textField( label: "Curing Press", labelPosition: if(ri!readOnly, "ADJACENT", "ABOVE"), instructions: if(ri!readOnly, "", ""), helpTooltip: if(ri!readOnly, "", ""), placeholder: if(ri!readOnly, "", ""), value: ri!record.curingPress, saveInto: ri!record.curingPress, required: false, readOnly: or( ri!readOnly, ri!automatic ), validations: if( len(ri!record.curingPress) <= 200, "", "Value may not be longer than 200 characters. You have entered " & len(ri!record.curingPress) & " characters." ) ), a!paragraphField( label: "Grader Notes", labelPosition: if(ri!readOnly, "ADJACENT", "ABOVE"), instructions: if(ri!readOnly, "", ""), helpTooltip: if(ri!readOnly, "", ""), placeholder: if(ri!readOnly, "", ""), value: ri!record.graderNotes.value, saveInto: ri!record.graderNotes.value, required: false, readOnly: ri!readOnly, height: "SHORT", validations: if( len(ri!record.graderNotes.value) <= 4000, "", "Value may not be longer than 4000 characters. You have entered " & len(ri!record.graderNotes.value) & " characters." ) ), if( ri!creating, {}, { a!linkField( label: "Created By", labelPosition: if(ri!readOnly, "ADJACENT", "ABOVE"), links: a!userRecordLink( label: rule!LQGAL_FormatName(ri!record.createdBy), user: ri!record.createdBy ) ), a!textField( label: "Created On", labelPosition: if(ri!readOnly, "ADJACENT", "ABOVE"), value: rule!LQGAL_FriendlyFormatDate(ri!record.createdOn), readOnly: true ) } ) } ), a!columnLayout( contents: { a!textField( label: "Mold Number", labelPosition: if(ri!readOnly, "ADJACENT", "ABOVE"), instructions: if(ri!readOnly, "", ""), helpTooltip: if(ri!readOnly, "", ""), placeholder: if(ri!readOnly, "", ""), value: ri!record.moldNumber, saveInto: ri!record.moldNumber, required: false, readOnly: or( ri!readOnly, ri!automatic ), validations: if( len(ri!record.moldNumber) <= 200, "", "Value may not be longer than 200 characters. You have entered " & len(ri!record.moldNumber) & " characters." ) ), a!textField( label: "Anomaly Code", labelPosition: if(ri!readOnly, "ADJACENT", "ABOVE"), instructions: if(ri!readOnly, "", ""), helpTooltip: if(ri!readOnly, "", ""), placeholder: if(ri!readOnly, "", ""), value: ri!record.anomalyCode, saveInto: ri!record.anomalyCode, required: false, readOnly: or( ri!readOnly, ri!automatic ), validations: if( len(ri!record.anomalyCode) <= 200, "", "Value may not be longer than 200 characters. You have entered " & len(ri!record.anomalyCode) & " characters." ) ), a!textField( label: "Green Tire", labelPosition: if(ri!readOnly, "ADJACENT", "ABOVE"), instructions: if(ri!readOnly, "", ""), helpTooltip: if(ri!readOnly, "", ""), placeholder: if(ri!readOnly, "", ""), value: ri!record.greenTire, saveInto: ri!record.greenTire, required: false, readOnly:or( ri!readOnly, ri!automatic ), validations: if( len(ri!record.greenTire) <= 200, "", "Value may not be longer than 200 characters. You have entered " & len(ri!record.greenTire) & " characters." ) ), if( ri!readOnly, a!textField( label: "Status", labelPosition: "ADJACENT", value: ri!record.status.value, readOnly: true ), a!localVariables( local!status: "Open", a!dropdownField( label: "Status", choiceLabels: {"Open", "Closed"}, choiceValues: {"Open", "Closed"}, value: local!status, saveInto: local!status ) ) ), if( ri!creating, {}, { a!linkField( label: "Updated By", labelPosition: if(ri!readOnly, "ADJACENT", "ABOVE"), links: a!userRecordLink( label: rule!LQGAL_FormatName(ri!record.updatedBy), user: ri!record.updatedBy ) ), a!textField( label: "Updated On", labelPosition: if(ri!readOnly, "ADJACENT", "ABOVE"), value: rule!LQGAL_FriendlyFormatDate(ri!record.updatedOn), readOnly: true ) } ) } ) } ) ), a!fileUploadField( label: "Anomaly Image", maxSelections: 1, target: cons!LQGAL_TEMPORARY_DOCUMENTS_FOLDER, value: ri!documents, saveInto: ri!documents ) } )
SAIL code for the form submit button:
a!localVariables( local!creating: a!refreshVariable( value: isnull(ri!record), refreshOnReferencedVarChange: false ), local!oldRecord: a!refreshVariable( value: ri!record, refreshOnReferencedVarChange: false ), local!status: a!refreshVariable( value: ri!record.status, refreshOnReferencedVarChange: true ), local!oldDocuments: a!refreshVariable( value: if( isnull(ri!documents), {}, ri!documents ), refreshOnReferencedVarChange: false ), a!formLayout( label: if( local!creating, "Add New Anomaly Record", "Update Anomaly Record" ), contents: { rule!LQGAL_AnomalyRecordDetails( record: ri!record, documents: ri!documents, deletedDocuments: ri!deletedDocs, creating: local!creating, readOnly: false ) }, buttons: a!buttonLayout( primaryButtons: { if( local!creating, a!buttonWidgetSubmit( label: "Submit Anomaly Record", style: "PRIMARY", saveInto: { a!save(ri!record.createdOn, now()), a!save(ri!record.createdBy, loggedInUser()), a!save(ri!record.updatedOn, now()), a!save(ri!record.updatedBy, loggedInUser()), a!save(ri!documents, reject(fn!isnull, ri!documents)), /*New save for status */ a!save(ri!record.status, local!status) } ), a!buttonWidgetSubmit( label: "Update Anomaly Record", style: "PRIMARY", saveInto: { a!save(ri!record.updatedOn, now()), a!save(ri!record.updatedBy, loggedInUser()), a!save(ri!oldRecord, local!oldRecord), a!save(ri!documents, reject(fn!isnull, ri!documents)), a!save(ri!addedDocs, reject(fn!isnull, difference(ri!documents, local!oldDocuments))), a!save(ri!oldDocs, local!oldDocuments) } ) ) }, secondaryButtons: { if( local!creating, {}, a!buttonWidgetSubmit( label: "Cancel", style: "NORMAL", value: true, saveInto: { ri!cancel, a!save(ri!addedDocs, reject(fn!isnull, difference(ri!documents, local!oldDocuments))), a!save(ri!deletedDocs, append(difference(ri!deletedDocs, local!oldDocuments), ri!addedDocs)) }, skipValidation: true ) ) } ) ) )
I made the changes you suggested. The drop-down field defaults to the "Open" status value as intended and the form submits with no errors. But the status still isn't being saved to the record list. Can you please looks over the SAIL code and see if you can see what I may be overlooking? Thanks.