Enum with Ref type

AppSheet AppSheet Q&A
1

Hey Guys,

i need your help to solve this issue.

I used this formula SELECT(department[process], [Functional Group]=[_THISROW].[functional_group])in Suggested values.

data is displayed as a whole, does not display specific data related to [functional_group] and there’s an exclamation mark.

alhazen_3-1656408969242.png
alhazen_3-1656408969242.png1366×768 96.1 KB

Thank you very much for your help

this is the data source:

alhazen_2-1656408759208.png
alhazen_2-1656408759208.png1366×768 88.2 KB

2

Hi @alhazen

EDIT

For instance, Enum with Base Ref is equivalent to Ref.

  • If you wish to select the Departments, you may using the type Ref, set the Source Table with Department.

  • If you are just interested with the Process list that exists in the table Department, then you will need to set the type with Enum and base type Text.

For reference:

FILTER() - AppSheet Help

SELECT() - AppSheet Help

1 Like
3

Hey @Aurelien Thank you for your response.

I have created enum with base text type for [sub_process] column. But I can’t add another sub process directly this way unless create it with type ref.

What do you think?

4

I’m afraid what you are willing to do is unclear to me.

The way I see your table, you want to select ONE sub-process.

If you wish more, then you may prefer to set its type with EnumList then.

1 Like
5

I mean if the user needs to add a new sub process related to a [functional group], but it is not listed in the “department” table, then the user can simply press the “new” button with the pencil icon. Look at first picture i attached.

6

I got that. What I mean, is that I don’t get what is your final goal.

If I understand properly, you have:

  • Department table, with columns: Department (I assume this is the naming column), functional group, process

  • Assessment table, with columns (at least): walk_type, functional_group, sub_process.

And you expect that when creating a new assessment:

  1. the user selects a functional group,

  2. then the user selects a sub process

I assume the purpose is, in the end, to make a funnel for choosing the adequate department.

Is that correct ?

If so:

  • set the suggested_value for functional_group (type Enum, base Text, option “allow other values”):
department[Functional Group]
  • set the suggested_value for sub_process (type Enum, base Text, option “allow other values”):
SELECT(department[Process], [Functional Group]=[_THISROW].[functional_group])

If not, that makes me think:

  1. if you want to add a new sub_process (process, or sub_process ?) but you don’t have it in your department list initially:

==> you need to create a new department record with that sub_process. This way, it will be displayed.

  1. you wish to have a list of all process/sub_process available anywhere:

==> you need to create a new table “process” with the whole list.

==> all tables that have a column refering to this should be of type Ref, source table “Process”.

Note:

generally, all columns that are of type Ref should preferably have the exact name of the table they refer to. It helps for identification.

Hope that helps !

1 Like