Samvel_Siradegh - profile

Samvel_Siradegh · Sep 12, 2023

I need a formula to check if there is exact matching for multiple select field when values can have comma. Here is a sample multiple select I can have:abca,bI need to check if users selection is exactly 'c' and 'a,b'. All solutions I found (like usin...

Samvel_Siradegh · Oct 20, 2022

I have a table with Rating field which can have value up to 7. With current API I can get value for each record, but I can’t get metadata for that field, to know possible max value. Is it possible at all?

Samvel_Siradegh · Sep 13, 2023

@Sho you are right, this is not exact matching. Your version was correct, I just had typo on my side. Will do some more tests and will accept as solution.

Samvel_Siradegh · Sep 13, 2023

I removed LEN and looks like it works, will try some corner cases and will update here.Here is formula I am trying IF( AND( REGEX_MATCH("##"&REGEX_REPLACE({select},", ","##")&"##","##c##"), REGEX_MATCH("##"&REGEX_REPLACE({select},", ","##")...

Samvel_Siradegh · Sep 12, 2023

Of course I tried it.Let me explain more visual way.This is my multiple select:You can see there are 4 options.This is selection I want to check:Hope this is more accurate description.

Samvel_Siradegh · Sep 12, 2023

Thanks for response @Sho , but this will not work, as in my case 2 of 4 items can be selected (or 1, or 3, or all 4) and LEN({select})=LEN('"a,b", c')will not be true, as for this sample {select} is 'a,b,c,"a,b"'

Samvel_Siradegh · Oct 20, 2022

Got it, thanks for your time and help.

User Statistics

User Activity

Exact match formula for Multiple select field when value has comma

How to get metadata for field?

Re: Exact match formula for Multiple select field when value has comma

Re: Exact match formula for Multiple select field when value has comma

Re: Exact match formula for Multiple select field when value has comma

Re: Exact match formula for Multiple select field when value has comma

Re: How to get metadata for field?