REF same Table

[bolognesiedalla]

I often find myself in front of customers who have more than one VAT number and company name. After entering each of his companies as a row of the CUSTOMER table, I have to keep track of their “union”, especially in the future to obtain aggregate reports and data.
So I was thinking of creating a column of type enumlist [linked_customer], that ref the same CUSTOMER table.

But the dropdown list in CUSTOMERS form view is blank.

Does it happen because it refers to the same table? Is there an alternative way to deal with this situation?

(i’ve tried also to remove the valid_if condition, but nothing changed)

[Suvrutt_Gurjar]

Instead of reference etc. , are you not able to group by customer name, something like below?

Sample Customer table:

[bolognesiedalla]

Yes it may be an idea to insert a grouping column. Thank you!!

[Steve]

@bolognesiedalla

Does it happen because it refers to the same table? Is there an alternative way to deal with this situation?

When you configure a column of type Enum or EnumList with a base type of Ref, AppSheet does not automatically generate the list of existing references. This behavior is different from that of a column of type Ref.

To get a list of existing references when using Enum or EnumList, use Valid If.

Drop-down from Valid_If - AppSheet Help

[bolognesiedalla]

Thanks Steve. in fact I changed the formula to:

SELECT(AZIENDE[IDAZIENDA],[IDAZIENDA]<>[_THISROW].[IDAZIENDA])