How do I get a record from a table and extract ele...
# 🤝helpg
gorgeous-zebra-55198
03/07/2024, 10:53 AMI'm making a restaurant ordering bot. I have an inventory table with items and their prices. The bot shows pictures of items with their prices. When a user inputs the name of an item, the bot triggers an intent for that particular item, which then goes into a "Find Record" step.
It filters by the name that the user provided, finds a match, and stores all the related columns (price, name, etc) in an array variable. I then use the Execute step to extract one or two elements to use later in the confirmation process.
This worked exactly ONE time. Until I tried to extract elements from it.
Now nothing is recorded into the array variable, even though there are no errors in the log. I have chopped everything up to pinpoint the issue but can't seem to find anything wrong.
g
glamorous-guitar-39983
03/07/2024, 4:10 PMCan we see some pictures of your set up (mostly find record card I'd say)
h
hundreds-battery-97158
03/07/2024, 4:54 PMSo now you can't extract the array anymore?
hundreds-battery-97158
03/07/2024, 4:55 PMIf you have access to the array then you can extract the elements you want in workflow variables and then use the variables in the file and text
g
glamorous-guitar-39983
03/07/2024, 4:56 PMTo start with, do you get anything inside your array variable?
g
gorgeous-zebra-55198
03/08/2024, 4:29 AMgorgeous-zebra-55198
03/08/2024, 4:30 AMNope. The variable should be getting four variables (2x times, product and price). It did the first couple of times. Now its dead.
gorgeous-zebra-55198
03/08/2024, 4:31 AMFour elements*
gorgeous-zebra-55198
03/08/2024, 4:31 AMPosted
gorgeous-zebra-55198
03/08/2024, 4:31 AMThat was my plan. The array itself stays empty now.
g
glamorous-guitar-39983
03/08/2024, 2:24 PMWhat is your execute code card @gorgeous-zebra-55198 ?
glamorous-guitar-39983
03/08/2024, 2:27 PMWhat is workflow.selectedItem ?
Because if it is crab, I think that your find record card filter should be more like :
Product is @workflow.selectedItems
glamorous-guitar-39983
03/08/2024, 2:28 PMBut I havent used that much find record cards so I'm not the best at finding problem with it
g
gorgeous-zebra-55198
03/08/2024, 2:31 PMI'm out. Will post as soon as I get home.
gorgeous-zebra-55198
03/08/2024, 2:31 PMBut really the problem is with find records
gorgeous-zebra-55198
03/08/2024, 2:32 PMI have tried different variants of product is @workflow.selectedItem. the result is the same.
gorgeous-zebra-55198
03/08/2024, 2:32 PMThe one you quoted was the first one I used.
gorgeous-zebra-55198
03/08/2024, 2:33 PMI'm inclined to think that this is a bug at this point. Because I got as far as extracting two elements from the table using the execute code block.