Hello,
I have a form table. A lookup is performed and populates student information. If the NA Correct field is checked, I would like the NY fields to populate. How would I go about doing this? Thanks!
I think the best option would be to hide the NY fields and show them once the checkbox is checked. You would always preform the lookup however the data is only saved and shown when the checkbox is checked. You would do this using a Field Rule
Hi Tiffany
Unfortunately you cannot use an event such as a checkbox to trigger a lookup event in forms unless the value of the Checkbox Selection is a value that would be included in the Lookup Query. Even at that, it takes a couple extra fields and calculations to extract the value of the selection to use in the lookup
I tried changing the field to a Y/N text field, but it still does not do the lookup. It seems like the lookup only runs when the therapist and assistant are selected, but does not run when data is changed within a row on the table.
I also tried hiding the fields. The field rule works when the criteria is met, but not the lookup.
Got it to work with the Y/N text field. I needed to add in the student identifier. Thank you!!