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.
LinkedIn
Twitter
