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.
Solved! Go to Solution.
Thanks.
In la tabla SOL_Eventos, put the Initial value of the column "Código actividad" as:
ANY([Related SOL_gastosMenores][Código actividad])
Put its Initial value as: ANY([Related Solicitudes][códigoActividad])
Could you elaborate more on this please?
Please show the columns of your tables from the editor.
This is table SOL_gastosMenores
This is table SOL_Eventos when I am trying to register a new one from Sol_gastosMenores form view, specifically clicking on "New" option from ID Evento field.
Thanks.
In la tabla SOL_Eventos, put the Initial value of the column "Código actividad" as:
ANY([Related SOL_gastosMenores][Código actividad])
Thanks very much @Joseph_Seddik it is working!
User | Count |
---|---|
36 | |
31 | |
28 | |
23 | |
18 |