Solved: References, dependencies, and duplicates issue. - Page 2

BaselMakhoul · 03-03-2025 03:25 AM

Hello everyone,

I have an AppSheet DB for RFQs and Offers Comparison.

DB has 5 tables, with many dependencies (Ref Type column).

The common problems I am countering are:

I want the RFQ_No column in RFQ_Items table to not show doplications from RFQ_No column in RFQ_Details tables as the 1st is a reference to the second.
I want the RFQ_Rev_No column in RFQ_Items table to only show numbers related to the previously chosen RFQ_No Column in RFQ_Items. RFQ_Rev_No is also a Ref type to the same column name in RFQ_Details table.

Solutions I tried:

Virtual Column: but it is not editable as it gets its value from a formula
Slices: my AppSheet does not show this option and I still does not know why.
Formulas like (Unique, Filter, Display Name) but does not work.

Please help with this issue

Gustavo_Eduardo

Imagine that in your app you are looking for records from a table.

If the reference is to a table 1 but the formula returns a column that is not the id of that table then the warning triangle appears.

For example, look at the following table:

If in the formula you call a field of the table with SELECT() but it is not an id of the table, (for example in this case let's suppose that you call the label) with SELECT( Table[label], true, true) then a yellow triangle will appear because although it finds records, no label matches the row id. To solve the problem, SELECT( Table[id], true)

Now, if you want to restrict the selection to unique records, you'd better create a slice that brings the unique records. How do you do that?

Well, you create a slice by tapping the + button next to the table in the editor. As the slice formula you write the following:

[id] = MINROW("Table","_RowNumber", condition)

Then in the valid if you could point, instead of the table, to the slice and this will bring the filtered records to be selected.

View solution in original post