Lookup with initial value

AppSheet AppSheet Q&A
, , , ,
1

Hi there, I hope all is good

I have two tables

1- Orders

2- Details

(Both have a common column value which is the “order ID”)

In orders table I have a column called (Condition)

In details table I have a column called (Return)

Can I make an initial value or whatever possible solution so that if …

If (return value) = return

THEN

(condition value) = return as well.

is there any tweak for that plz

Thanks

2

Is it a one-to-one relationship? As in only a single detail record for each order record?

3

@Marc_Dillon

Hi, I did not actually get your point correctly. I think yes it is point to point

4

You could put this in a Virtual Column on orders table:

ANY( [Related Details][Return] )

https://help.appsheet.com/en/articles/4575708-list-dereference

1 Like
5

@Marc_Dillon

Thank you very much indeed. Helpful