How to fill value in textbox by selecting value from dropdown

[anonymous]

I have one form in which I have one dropdown and some text fields, I have linked 2 different tables,
Table1
Table2

In form I have 1 Dropdown in which value is coming from Col1 of Table1, Now I want When user select value from dropdown, app should pick value from table2 column and fill in the specific textbox.

The column linked in the dropdown is common in both tables.

[Lynn]

Hi @Jayesh_Dua
You could check these out, they may help.
https://www.appsheet.com/Support?idx=help&p=0&is_v=1&q=dependent%20dropdown

[Sample App: Multiple (and optional) dependent dropdown filters](https://community.appsheet.com/t/sample-app-multiple-and-optional-dependent-dropdown-filters/23653) Tips & Tricks ?

I created a sample app to demonstrate setting up multiple search filters to narrow down the possibilities in a final Ref-type column. “Multi Filter Example” here: https://www.appsheet.com/portfolio/546920 This app does NOT utilize Appsheet’s implicit dependent dropdown feature, as described in the following post. The reason for this is to allow the user the option to filter by any, or all, or none, of the 4 filters, independently. Whereas the implicit dependent dropdown will auto-hide the …

[anonymous]

Hi @Lynn

Thanks for your reference but the article referred by you does not solves my problem because in the article they have displayed the list but in my case I do not want to display the list, I want to autofill the value in my textbox on the basics on selected value in the dropdown from my table.

I hope you will understand my exact problem.

[Marc_Dillon]

I imagine you could use LOOKUP

[anonymous]

I tried Lookup in Appformula and I am confused in Lookup value, What should I write in lookup value field as that value is to be taken by user which is present in the form?

Screenshot is attached for clarity.

Screenshot of Appformula
Screenshot of Form:
Screenshot of GSheet:

My Requirement is:
On selecting Company Name Address should get auto filled.

[Steve]

Try this as the Initial value expression for the column that will get the address:

LOOKUP([_THISROW].[Company_Name], "Company_Master", "Company_Name", "Address")

If the Company_Name column in that form view is a column of type Ref, you might instead be able to use just this as the expression:

[Company_Name].[Address]

See also:

[anonymous]

@Steve : Thanks for the solution. My Issue Solved.