Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear community, I´ve got a field where the values contain ';'. I need an action to select two values in that field based on texts in variables when the user enters the sheet. The problem is that ';' is the separator for values in the sheet actions. My field values look like this:
'MTP 2020; 2021-2023'
'MTP 2021; 2022-2024'
'MTP 2022; 2023-2025'
(Which means Mid Term Plan, approval year 2022, containing plan values for the years 2023-2025)
I use two variables that could contain values like 'MTP 2020; 2021-2023' and 'MTP 2021; 2022-2024'. The sheet action should make the selection in the field based on what´s in the variables.
How can I get the variable texts selected in the sheet action?
Solved the issue using a bookmark instead, and added an action to apply the bookmark.
Solution: Typed this into search for field=Field
Field={"=Field=vVariable1"}&Field={"=Field=vVariable2"}
Still, if you have a solution using action to select values in field or select search value, please add to this post.