Table A has many columns. 2 particular columns are โBrandโ and โProduct nameโ. When an user adds data to table A, the user needs to select a brand (dropdown list) in column โBrandโ and select a product name (dropdown list) in column โProduct Nameโ. If product name is not found in column โProduct Nameโ, the user can click โNewโ to add. Thus, another form (Table B) pops out. Table B has 2 columns (โBrandโ and โProduct nameโ). I want the value of โBrandโ in Table A (the value selected by the user) to be the initial value of โBrandโ in Table B when Table B pops out. How to write the expression? Thank you very much.
You may wish to post more details of your configuration of those two tables with respect to how those are connected etc. so teh community could offer a more definitive approach.
Till such time, have you considered using LINKTOFORM() function?
Hello @AppSheet_Lectra, i had the same question not so long ago, and i havenโt been able to dereference values from a form into another, as far as i know this is not possible at the moment.
So i did what @Suvrutt_Gurjar suggested:
Instead of letting the user add a new product from inside the form, i added an action button that lets them get straight to the new product form with some of the fields already locked in.
Currently, I changed the type of โProduct Nameโ in Table A to โRefโ so that user can select product name from a dropdown list. If product name is not found, user can click โNewโ to add new product name.
I will take a look how to use LINKTOFORM. Thank you.
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |