How do I search for information within a table field by typing the code (ID) in input_1 and this search information appears in input_2.
The steps they took me were:
1 - Create an aggregate on demand with a variable code as a filter in the code field of that aggregate.
2 - In the onchange of input_1, update its value in this code variable and refresh this aggregate.
3 - Create a variable and assign it to input_2 and in the aggregate's on after fetch update this variable with the name of that item.
I'm starting out and I don't know how to do this, can anyone help me?
Hi Reinaldo,
The steps you mentioned are correct so what else you need help for? Can you please elaborate.
Thanks.
thank you for your attention.. but I can't elaborate, can you make an example for me to download please? I'm still in this part that I've been learning for days without being able to solve this logic.
Hi @Reinaldo Dosan ,
Please find the attached Demo file.
Demo Link
Let me know if you need any help further.
Hope this will help you.
Thanks,
Amit
After several efforts to assimilate the tips given, unfortunately I have not, consequently, attached this what was done. There is a table with records such as code and name attributes. In the main shout we have a form with code and name as input. When entering entry code 22a in the entry, the name should automatically fill in the name referring to code 22a, which is Roberto, which is found in the data registration base.
Firstly, You can directly assign the attribute from the aggregate to the input_2 widget that you want to get the information for and the filter that you had used can only be applied when all the characters that you had entered in the input_1 widget matches with your record in the aggregate, So you can change the filter in the aggregate by using the like operator.
I had attached the sample file for the reference, Hope this will help you.
Supriya
button logic for searcj in database