Use data from one Form to build another form?

  • Profile Image
    Asked on October 22, 2020 at 02:06 PM

    Hi all - what is the best suggestion for using data from one form to build the foundation of another form? Specifically (because I know that is relatively generalized and confusing), I have a form that collects available times for consultants (NE's or Nurse Educators) located here: and it collects available times via a Multiselect Grid widget. What I need is for that information to then populate to a grid that lists the name of the Nurse Educator in each time slot that they have identified that they are available.

    So, if NE1 identified that he/she is available Mondays from 6:00-7:00PM on the aforementioned form, I need another form to grab that data and list "NE1" in the Monday 6PM and Monday 630PM time slots, which is then able to be grabbed by another staff member to "book" that person. Thus, if NE1 is booked for Monday at 6, it is identified on the new form, and can be cleared out on that same form.

    Lawd- I hope that makes sense. Generally, this would mean communicating with a spreadsheet with data from Form 1 and having that data build Form 2 - but, I'm sure the tech is here to do that without the intermediary. Please help!

  • Profile Image
    Answered on October 22, 2020 at 07:10 PM

    Thank you for providing us with clear details of the requirements. I have been checking on this, but unfortunately it is not possible to use the MultiSelect Grid widget conditions/calculations and passing the data using the widget to another form. The workaround I found that can work is using the basic Input Table Field instead.

    1603407779_5f920fa3353ed_zzz 2020-10-23

    The Input Table field can be used in Conditions/Calculations and use the data to pass on to another form.

    User guide : How to Automatically Pass Form Data to Another Form

    The downside to using the Input Table field on this method is that the selected available times will not show the auto disabled indicator similar to how it does in MultiSelect Grid widget.

    I hope this help. Please let us know if you need further assistance.