I have a question about a REF error (Triangular Yellow icon with exclamation). I have a couple data sources.
- 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.