Enumlist from a ref column

AppSheet AppSheet Q&A
1

I would like to be able to choose more than one option from a dropdown list of options. That would be an enumlist.

But the list is a column in a table, and i cant figure out how to reference that column and still be able to add new unique values to the column (as though it were a referenced column. i tried a Valid_if statement, and i can add a new entry, but it doesnt update the original column because its not actually referenced.

Basically, i would like to have a dropdown ref column with the ability to pick more than one value. Can that happen?

2 Likes
2

I did try using an ENUMLIST and setting the base type to REF, but then there’s nowhere I can find to set the REF value to point it to my list of values, and I get the following notification:

Column Name ‘Base_For_FACTORY REP’ in Schema ‘Test1_Schema’ does not specify a referenced table. Picking a default.

3

Hi, I just tried this in my app and it seems to work. Specify the table to look for ref values in the Valid_if setting of your ENUMLIST.

5 Likes
4

Hello @Belinda,

You are talking about one to many references.
I have asked about this recently as well.
Unfortunately the only way to achieve what you want is to use an interim table that has a reference to the table in which you are trying to make the one to many reference and a reference to the table in which you hold the list column that you wish to reference.

To make things more clear let’s say we have only three tables.

Table A - this is the table in which you’d like to reference several items from a list in another table.

Table B - this is an interim table which has a reference to table A (make sure to mark this reference as Ispartof to make it a child table of table A) and also has a reference to table C.

Table C - this is a table which holds a list column which you will reference in table B.

Because you marked the reference from table B to table A as Ispartof, it will now appear as a child table within table A in which you can make as much references to table C as you’d like.

I would advise you to make a slice table of table A to have control over the way your columns are presented in the form view.

1 Like
5

Guillemo,
Using your example I created 3 tables. Collection Events ©, Disposal Events (A) and Interim Table (B) I wanted to have collection events associated with a service location and then associate many collection events with a single disposal event. I created a collection event from a location and all is good. When I create a disposal event, the collection event record is removed. Is this the expected result that you got as well?

6

@Riki_Armstrong It works perfectly.
I was getting crazy to find the solution, this is the best and the more simple!
Thank you very much

3 Likes
7

Hi, what formula did you enter?

8

@Riki_Armstrong, can you help with how you were able to do this? I’m struggling to get this right. Thanks.

1 Like
9

That all sounds good, but I have no idea what to do Any help would be appreciated.

10

Enumlist from a ref column should work if the type is set to “Enumlist” and the base type to “Ref”.

When the base type is selected as “Ref”, the option to choose the referenced table doesn’t show up immediately and requires a “Save” first. Then the option to choose the “Referenced Table” shows up perfectly. This might be a bug, an issue, but I have been making it work that way and it has worked for me so that’s not too big of a problem for me.

Pulling values using Valid_if works perfectly, but with one little problem, it doesn’t give a “New” option that can add an entry to the referenced table.

6 Likes
11

What do I type in the “valid if” statement in the enum column?

I have another table called “ADM-GsuiteUsers” and the ref column in this table is called “Navn”

Sorry, pretty noob here.

12

Filter(“ADM-GsuiteUsers”, Condition)

Make sure the Navn column is the label column

13

I just confirmed that the above is true. You can set the ‘base type’ under the EnumList column to “Ref” but you cannot specify the table until you SAVE the app and then go back into the EnumList column.

14

I requested before, but not much support gaining on this .

[Enum / Enumlist - base type - Ref to immidiately show the reference table without sync](https://community.appsheet.com/t/enum-enumlist-base-type-ref-to-immidiately-show-the-reference-table-without-sync/30220) Questions

This could be more bug fix request rather than feature request. When we select enum or enumlist, then we have option to set the base type ref and then esablish the relationship with other table, by picking up the reference table. The dropdown list for selecting the target tables is only becoming available once we save the editor. Wish to change it to make the list available WITHOUT sync.

1 Like
15

고맙습니다.
고민하고 있던 부분이 해결되었습니다.

저의 문제와 해결법
문제 :
다른 테이블을 같이 참조하는 두개의 컬럼이 있음
각 컬럼에서 하나는 하나의 값만을 선택하고
두번째 컬럼은 여러개의 값을 선택합니다.
그래서 첫번째 컬럼은 Type을 Ref로 설정하고 Source table을 원하는 테이블로 설정하여 해결했습니다.
일반적이 방법이죠
두번째가 문제였습니다.
Ref로는 여러개를 설정할수 없었습니다.
그래서
Type : Enumlist
Base type : Ref
Referenced table name : 참조할 테이블
로 설정하니 값이 보지 않았습니다.
그래서 자료를 찾아보니 위와 같은 방법은 다른방법이라고 하네요.

그리서 위 글에서 설명하는것과 같이 Valid if를 이용하기로 했습니다.
Type : Enumlist
Base type : Address
Valid if : Table_name[Colume_name]
으로 설정하니 여러개를 선택하고 값도 볼 수 있게 되었습니다.

감사합니다.
Thank you…

3 Likes
16

Finally someone provided an actual example of what to type in the valid field. This worked for me:

  • Set “type” to EnumList .
  • Click on the pencil next to the column name and then set “Type Details” → “Base Type” = Ref and “Base type details” → “Referenced table name” = the reference table name.
  • Then under “Auto Compute” → “Suggested Values”, enter the above formula
    • Filter(“Table Name”, Condition). If you want to get everything, just set Condition to ‘true’.
2 Likes