Action field value separator already in values

JohanLind1979 — Thu, 15 Jun 2023 18:33:40 GMT

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?

Re: Action field value separator already in values

JohanLind1979 — Thu, 15 Jun 2023 19:41:17 GMT

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.

topic Re: Action field value separator already in values in App Development

Action field value separator already in values

Re: Action field value separator already in values