Hi
I am wondering if it is possible to use the readexcelsheet() function on a rule input file (ri!Submission.submissionfile) which is uploaded in the same interface.
a!textField( label: "Rules", labelPosition: "ABOVE", value: readExcelSheet( excelDocument: ri!Submission.submissionfile, sheetNumber: 1, startRow: 9, numberOfColumns: 4 ).result.values[1,4], saveInto: ri!rules, refreshAfter: "UNFOCUS", readOnly: true, validations: {} )
Should this be possible or does the function only work within a process model?
In the interface I am getting the following error: 'Interface Definition: Expression evaluation error at function 'readExcelSheet'' while in the process model it works (with process variables)
Thanks in advance!
Chris
Discussion posts and replies are publicly visible
Hi Chris,
The document that you want to uses needs to exist in Appian DMS and actually saved in a folder for you to use that function. That only happens when you submit a form... In the same interface and without any form submission, you can't do it. You can try to build your Interface to validate if upon submission the flow should go back into the interface itself or continue to other process model nodes.
Thanks a lot, Pedro! How would you suggest the flow going back into the interface? Currently, the interface is my start form and if I am right i cannot direct the flow back into the start node.
If you're using a Process Start Form, you will not be able to do that but nothing prevents you to have a User Input Task after the Process Start Form with Activity Chaining enabled to accomplish that behavior.
You could call the start form interface from a subsequent chained user input task, though I'd recommend instead of doing this you make a copy of the original interface and call that instead (to enable you to make customizations to either without breaking the other).