Fill data in Forms

Fill data in Textbox by relationship between tables for example
SELECT DISTINCT tax AS value, tax AS label FROM products WHERE id =: lookup_product_id ORDER BY id
In this way, when placing the product code, the data is obtained automatically by means of javascript in the subforms as I show below:

1 Like

How do I put the master / detail like that? Could you explain me please?
Thank you!

Do you speak english or spanish?
There is a tutorial in English, but I will soon do some tutorials in Spanish. That’s why I’m looking for everything to be complete

And I think I was not clear with my post
What I need is to see if someone has already done this and can help me understand if in the same RadSystems Studio editor you can set the values in the text boxes, that is, I enter the product code, I need the price data and tax are obtained automatically. I’ve done it before in Laravel and Pure Javascript projects. But it would be great if the RAD could do it within the editor. This will help me make the video tutorials for the community in Spanish

I am from Argentina, but I wrote in English because otherwise many would not understand … do you have a youtube channel or guthub repo?
If I understood correctly, what you need is to bring the product and make an autofill of the price of the product and only enter the quantity and that it is self-added?

At the moment I do not use the YouTube channel for tutorials because of the time. Because in addition to other tools there are already a number of tutorials, in this case that RadSystem does not have content yet, because I want to do a few.
Possibly this week I will be doing them

And regarding what I want to do, perhaps one of the developers or moderators of RAdSystem understands me, I will share screenshots of what I want to do:
First Search the Product by Code and Load the data automatically the data in the detail table.

Data loaded automatically

That is what I ask you, what you need is when selecting the product make an autofill of the price. What is generating?

I just tried and apparently it is a problem of version 3.9 when doing the lookup does not work.
I have it in my invoice as filled to the price field and it brings it to the value when I make the select to the products table, but now it does not work, I suppose it is a bug of version 3.9 because in 3.8 it worked fine …

Actually it does, but it only works if you use Select as an object and not Textbox. And the idea is that it works in the Textbox, in the same way what I am thinking is to update the data in the AfterAdd event
It seems that we will have to make these modifications to pure code. Unless the RadSystems developers can achieve it, which I think they could, since they do the same function only as for the Select object

@Melek i made a video about this on my channel to autopopulate!


@Wahome-mutahi100 hat we require is autofill of fields that already exist in a table. The video exemplifies another function… which is fine but is something else…

Example: I have the table products: idprod, name, price, stock
On the other hand, I have the Sales table: idventa, date, idcliente (this table will be the header)
and finally I have the SalesDetail table: idventadet, idprod, price, stock, quantity, total
In this last table is where the autofill is required, in the price and stock field that belong to products, the user when selecting the product, within detailed sales, should autofill the price and stock field that contains products.
I hope I was more clear…

Any rad tool has this option, phpmaker, phprunner, genexus, etc.
Another thing is that they should add more than 1 parent select

P/D 2: I put another tool as an example so you can see how the function works. No offense intended or anything.
Radsystem seems great to me, only that they should correct the bugs that have been around for a long time and are not corrected, as well as listen a little more to the advice of their community and give them the components and functions that they ask for, and stop trying to get more generators, they should stay with 2 or 3 generators and focus on them working optimally, such as laravel, nodejs and python.

Okay,will send a video. Which version of rad are you using??

1 Like

i can not see an update path to v 8.x , is it a beta testers internal group or something?
i have 7.1.2

I tried to edit and delete the previous message…
7.1.2 node + quasar or laravel + quasar