Enum collect data

[alhazen]

Hello guys, 

i need your help

I'm trying to collect data for a list of specific value in the [sub activity] column with value in the [activity] column. i use this formula select(reference[sub activity],([activity]=[activity],true)) in suggested values, but it doesn't to work. Thank you very much for your help

all data will record on this table

[TeeSee1 · Accepted solution]

select(
 reference[sub activity],
 [activity]= [_THISROW].[activity]
)

[TeeSee1 · Accepted solution]

select(
 reference[sub activity],
 [activity]= [_THISROW].[activity]
)

[alhazen]

I didn't realize it to just need a little adjustment. Thank you TeeSee1-san

[alhazen]

is it possible for the user to enter only once for each column based on the query number? I mean no duplicate data. I will add the query number column later

[TeeSee1]

https://www.googlecloudcommunity.com/gc/Tips-Tricks/How-to-Prevent-Duplicate-Records/m-p/322114#M203...

[MultiTech]

Instead of using Select() to brute force your list of [related sub activities]

I'd check out references. 😉

[alhazen · Accepted solution]

Hey @TeeSee1 and @MultiTech i think i solved my problem with this formula SELECT(reference[activity], NOT(IN([activity], SELECT(activity[activity],[request_number]=[_THISROW].[request_number], TRUE))))

I group activities by request number, so i added new column [request_number] in activity table.

every activity that I have entered with the same request number will no longer be shown in the list.

[MultiTech]

Nested selects like that or no no

Best
Matt