I have a form that has approval steps and I am trying to populate a table from a view/stored procedure based on a value of a field that is populated after the initial user-submission.
When a user submits this form, the first step is a workflow that generates an ID for that form and populates a field on the form. The next step is to review and approve the submission. After this stage, a workflow updates a SQL table with the approval step, the username, date/time, and some other information. The table included in the form will then be populated by that SQL record.
There are other approval steps that follow the same logic. My issue is that the client has requested the approval stage to have an overflow look rather than the original forms tabular view. The overflow is only available when checking the "Make form read-only for users the task is assigned to" box. I am fairly certain this read-only attribute is stopping the form from being able to run the stored procedure. I have tested populating a table from the same view/sp in a test form without the read-only attribute and it works fine.
Is there a way to do this? Can I set read-only on the ENTIRE form, like the check-box is doing, in JS so that the form can run the lookup?