Parse Error within filter tool when trying to create an app
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
I am currently trying to create an app that will filter a certain column in my data according the names the user selects. The interface of the app shows all names under the column I am trying to filter for and the user can select or deselect the name. When I run the app I get the following error message below:
Filter (2): Parse Error at char(29): Parse Error
I am not sure as to why I keep getting this error as I have used the method that I am currently using to filter the data before. I am first using a list box tool to display all the names under the column then I use an action tool to update the value within the filter and thirdly, I am connecting to the filter tool and using the following formula [Major Catergory] = "Testing". ("Testing" is the intended string that is supposed to be replaced in the action tool ).
Any help on this would be amazing!!!
Below is a screenshot of of the workflow and the configuration screen of each tool. I also attached the app below.
Thank you!!
Solved! Go to Solution.
- Labels:
- Apps
- Chained App
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
At the moment you are passing in (when the user selects more than one thing)...
[FieldName] = 'Bob','Dave'
Which is not valid syntax. An IN statement allows you o check against multiple criteria so you should look to use...
[Fieldname] IN ('TESTING1','TESTING2')
Then in your action use...
'TESTING1','TESTING2'