I am seeing some strange behaviour when “Making Changes to a Thing” combined with a “search for” function.
Am I using the search for function incorrectly?
I’ve added an example App to the forum_app2: make_changes_to_thing
Here is my problem:
- I have three* text fields with the following entries:
- text 1= Bubble
- text 2 = BUbble
- text 3 = bubble
I then add them to an empty Keywords table by using the make changes to thing event:
2.1. Search for “Keywords” (table)
2.2. Where Keywords (field) = text1 lowercase
2.3 Create thing if it doesn’t exist
2.4 add Keywords = text1 lowercase
I repeat Step 2 for each text field
If I do this on a Keywords Table that already has at least ONE “bubble” Keyword in it, then the app doesn’t add any new Keywords. - This is good, and what I would expect!
HOWEVER, if I do this on an EMPTY Keywords Table, then the keywords from the text fields are added THREE times.
It is like it is not finding the first entry (created for text 1) while it is running the workflow and then just keeps adding the keywords until it has finished the workflow.
Does anyone have any ideas how I can prevent this from happening?