Hello!
In my AppSheet app, I have a table named ‘IND_metasGlobales1’ where I register global indicators’ targets for each category, encompassing both quantitative and qualitative aspects. Additionally, I have a relational table named ‘IND_criteriosEvaluación’ where I record a list of evaluation criteria for each qualitative category.
In the ‘IND_criteriosEvaluación’ table, I’m using the ‘ID Categoría’ field as a link to the ‘IND_metasGlobales1’ table. To achieve this, I’ve set up a ‘is part of’ reference from the ‘ID Categoría’ field in the ‘IND_criteriosEvaluación’ table to the ‘ID_metasGlobales1’ table. This setup allows me to add criteria when a new category is added through the goals and categories registration form in the ‘ID_metasGlobales1’ table.
However, I’m encountering an issue. When I click ‘New Category’ from the reference field in the category registration form, and then the criteria registration form opens in the ‘IND_criteriosEvaluación’ table, the ‘Código indicador’ field doesn’t auto-populate with the value that’s populated in the first table. This field is essential and needs to be filled in both tables. How can I resolve this problem in AppSheet?
I would greatly appreciate any help or suggestions to address this issue. Thank you in advance!
