Hello, I want to create a formula so that whe...

(Tiago Maciel) #1

Hello, I want to create a formula so that when filling out a form, one of the lines of this form is filled automatically, that is, that the value of the join of two lines, is searched in another table and when find shows the value of another cell of that same line.

Can someone help me?

thank you

(Aleksi Alkio) #2

You are looking LOOKUP expression. The format would be LOOKUP([_THISROW].[Name], Customers, Name, Phone). You can read more about it from this article…

help.appsheet.com - List Expressions and Aggregates List Expressions and Aggregates help.appsheet.com

(Tiago Maciel) #3

@Aleksi_Alkio thanks, its return a value of the table, but is not the value of the “Phone” in the same line of “Name”.

(Aleksi Alkio) #4

If you got wrong value, it means you have more records than one with the same “Name” and the formula found the first one.

(Tiago Maciel) #5

@Aleksi_Alkio thanks, it solve.

(Aleksi Alkio) #6

You’re welcome