Hi everyone,
i am trying to create an action to automate a verification cycle.
In my head table, i got the information, and the user has to upload a pdf file. The verifier has a Linktoformview button, with what he registers the verification in a child table, checks the atached file information and then changes a is correct Y/N button. I woul like to group this verification action with a action that then goes to the head table, an changes a Y/N button to false, so that the user sees he needs to recheck the data. And if he uploads a new file, changes the button to corrected manually.
If i make the verification and reset button separate, it works, but when i group them it stops working.
Any suggestions?
Thanks in advance
UPDATE: I’ve been looking in the automation section to trigger a datachange task, but ith changes all the rows in my head table where the child tables row value is false. I set my automation up as follows:
Event:
Condition i put in is: [_THISROW].[estadoVerificacion]=FALSE, and BDVerificación is the child table, where i add rows for each verification.
I run an data action set up like tshis:
Referenced Row condition set as: SELECT(BDRegistros[ID],[_THISROW].[Id_tramite]=[Id_tramite]), where BDRegistros is the head table, ID the key column, and ID_tramite is the referenced column in child table.
The referenced action is set up like:
And behavior condition as follows: LOOKUP(MAXROW(“BDVerificacion”,“_RowNumber”,[Id_tramite]=[_THISROW].[ID]),“BDVerificacion”,“Id_Verificacion”,“estadoVerificacion”)=FALSE
I do not see how i could limit the action to only aply to the row where i added a verification.
any suggestions on what i’m doing wrong?
