https://discord.gg/botpress logo
Join Discord
Powered by
Changing Record ID dynamically when using the Reco...
# 🤝help
n
Hello, I am trying to create a flow where my suppliers update the current prices of the products I have previously saved in the data tables in Botpress. I'm trying to test this flow through a prototype. I also tried the Find Record card and execute code card to determine the Record ID dynamically, but since I have no coding background, I couldn't get anywhere with AI. Thank you in advance for your answers on what path should I follow or what should I add to my flow to achieve my desire in this flow? https://cdn.discordapp.com/attachments/1253267334257311785/1253267334538334230/Screenshot_2567-06-20_at_11.27.16.png?ex=66753ba9&is=6673ea29&hm=93e383198575a2ced3fa6f31b8eda2368c1e7352e09767f36726b0cce33637b5& https://cdn.discordapp.com/attachments/1253267334257311785/1253267334873743361/Screenshot_2567-06-20_at_11.27.33.png?ex=66753ba9&is=6673ea29&hm=e73fe31f401b4209c75ac3d4d9dc84ce88000030d94fed9ab2f07c6f119f604a& https://cdn.discordapp.com/attachments/1253267334257311785/1253267335264075817/Screenshot_2567-06-20_at_11.28.05.png?ex=66753ba9&is=6673ea29&hm=fce291a6d5222634192f8d3896cb6e2c7ba61ff274eca1bdc89ff02e4318557e& https://cdn.discordapp.com/attachments/1253267334257311785/1253267335549030441/Screenshot_2567-06-20_at_11.32.02.png?ex=66753ba9&is=6673ea29&hm=fdd1d6aeee83e1b559d5857db42ae28a73784f0f62043d484c57b7a1a355f8db&
w
Hey @numerous-room-43560 , first of all, you can disable the search in KB in your raw input and in your price card (because you don't need a response from your KB I think)
Then, after your raw input card ("result"), add a find record card
and store the result in a variable
Assuming yor supplier will enter the right name, you will get only one result, so you can get the record id with this expression :
you can click on the {x} (in the update record card) and add {{workflow.your_result_variable_from_find_record_card[0].id}}
n
Hey @wooden-beard-40210 First of all, thank you for your time. I applied your steps but I face with this error. also one correction; price card will be what is your new price? https://cdn.discordapp.com/attachments/1253267334257311785/1253393087754014860/Screenshot_2567-06-20_at_19.48.57.png?ex=6675b0c7&is=66745f47&hm=84057336fd967012f0f0b05aac603ab9a6c6f81931abc49438e39c45e644ab9c&
I didn't write something to the filter
w
Write {{workflow.result}}
So the bot will search for the product the user is looking for
And what is the type of your variable findingresult
n
string
when I chose number I can arrangw for the finding card, It dissappear automatically
w
Try to set it up as an object
Even a string should work
I’m not sure to understand
n
When I set the workflow.findingresult variable to number in the variable setting section on the left, the selected variable section in the find record card becomes empty. I cannot use a variable of number type as a variable in the find record card.
I set up as a object again find record Card's result variable is empty
w
Did you set your columns as searchable in your table ?
n
yes
w
Okay , I will try to make you a quick video when I come back to my pc
n
I am really appreciate about your attitude.
w
wow i get a weird error with the find record card
a little bit like the one you get here but not exactly the same
i tried with code and it works fine
sorry my loom doesn't work lol
here is the code
Copy code
const productName = event.preview

// Find records in the productsTable based on the product name
const records = await productsTable.findRecords({
  filter: { name: productName }
})

// Check if any records were found
if (records.length > 0) {
  // Get the first record
  const record = records[0]
  // Log the record details
  console.log('Record found:', record)

  // Update the workflow results with the found record
  workflow.results = record
} else {
  console.log('No record found')
}
event.preview is used to get the last user's message
hope this will help !
and it's weird that the find record card doesn't seem to work
PreviousNext
Powered by