Reference id

[YanChang (Ян Чайковский)]

Why doesn’t it work like that?

---

1. [Clients id] -> REF_ROWS(“Measurements”, “Client id”) - Measurements id
2. [Clients id] -> REF_ROWS(“Client diet”, “Client id”) - Client diet id -> REF_ROWS(“Monday diet”, “Client id”) - [Mondey diet id]

---

The first option works, the second doesn’t!
Where REF_ROWS(“Monday diet”, “Client id”) - [Mondey diet id]
works like -> REF_ROWS(“Monday diet”, “Client Surname”)

Why is that?)

[Steve (Steve Coile)]

You post makes no sense to me.

[LeventK (Levent Kulacoglu)]

@YanChang
May I suggest reading this post?

Guide on How To Create a Community Post

Dear valuable members and users, For a long time I’m seeing a lot of multiple and concurrent posts, posts like novels seeming to aim the Pulitzer Price, exactly the same questions by the same user but paraphrased/re-phrased etc. Being a dedicated community member and an AppSheet developer who is reading around 2.5K posts per day, I urged myself to tip on some good advice and best practice BEFORE posting something in the community: #1 - APPSHEET DOCUMENTATION AppSheet has a very good help do…

[LeventK (Levent Kulacoglu)]

@YanChang
It seems that you’re trying to establish a List Subtraction. Provided that’s the case, you are on the wrong path. Please take a look at these docs:

List Expressions

List Subtraction

List Functions

List from Expressions