I have a question about a REF error (Triangul...

(Greg Huston) #1

I have a question about a REF error (Triangular Yellow icon with exclamation). I have a couple data sources.

  1. RFQ Table 3. Company Table 2. Purchasers Table

There are 2 companies in the company table. When you create a purchaser (purchaser table), they have a Purchaser_ID (Unique_ID) and you assign them to the company, by selecting the company from a dropdown REF. This works great.

The problem I’m running into is this. In the RFQ table, you need to assign a company and a purchaser to each RFQ. Under RFQ’s, I’ve got a column Company_ID as a REF to the company table. This works great - it pulls my labels and puts them into the dropdown, and saves the Company_ID into this column. However, when I go to choose the purchaser, I have the following code…

=SELECT(Company_Purchasers[Purchaser_Email], [Company_ID] = [_THISROW].[Company_Name])

This lets you select a purchasers email, from a list where the Company ID of those purchasers matches the company ID already selected. This behaviour is EXACTLY what I want. It works great. However, when I click save, I get the orange exclamation mark beside the saved data. Viewing the underlying table, it seems perfectly clear.

It’s saving the purchasers EMAIL to that column, which is labeled a REF. It’s expecting it to be unique ID’s but instead its getting an email.

How do I get this to work? The behaviour is exactly what I want, but I believe saving the email to that REF column rather than the Purchaser ID is what is causing appsheet to freak out. I’ve reviewed the dependant dropdowns docs, but this doesn’t seem to apply, as I’m pulling the second part of the dropdown from a different table, not just another column from the same table.

(Aleksi Alkio) #2

You probably

need to read the Purchaser ID, not the Email because it’s not the key column. =SELECT(Company_Purchasers[Purchaser ID], [Company_ID] = [_THISROW].[Company_Name])

(Greg Huston) #3

Hi,

The only problem with that, is now the dropdown menu shows the Purchaser ID - which is generated by UNIQUEID() - as the selection option. That’s great if you memorize each Purchaser_ID - but I want them to be able to choose from something understandable as well!

I want the dropdown to show the labels, and the saved data to be the ID. Is this possible?

(Aleksi Alkio) #4

Yes it’s possible if you set the correct column as a label.