Hello guys!
I am developing an application in AppSheet to manage expense requests in my organization. In the request registration form, I have a field to select the “ACTIVITY or MACRO ACTIVITY” to which the request is linked, and another field to select the specific “EVENT” for which the resources are required.
The selection field for “EVENT” references a table called “SOL_EVENTOS” that contains all the events previously registered for each activity or macro activity. The application works correctly when I select an existing event from the drop-down list.
However, when I want to add a new event that has not been registered yet, I click on the “NEW” option in the drop-down list, which opens the form to register a new event. The problem is that in this form, the “ACTIVITY or MACRO ACTIVITY” field is not automatically populated, but it asks me to select it again from an extensive list.
My goal is that when I click “NEW” to add an event, the “ACTIVITY or MACRO ACTIVITY” field is automatically, (but it is not working as you can see bellow) populated with the value that I have already selected in the expense request form.
I appreciate any guidance or suggestion to solve this issue and make the “ACTIVITY or MACRO ACTIVITY” field auto-populate when adding a new event from the expense request.
Thank you very much for your help.
