Update a record for a FAQ with the email
# 🤝help
m
Hello everyone! I would like to create a workflow for my bot when he don't have the answer for a question, the question is added to a table and get the email associated to answer manually. Here the actual workflow with number corresponding to the attachment: 1. When the bot do not have the answer 2. Insert a record on the table with the question asked 3. Ask the email to the visitor and capture it in the variable 'workflow.userEmail' 4. Update the row with the visitor's email on his question (that my initial idea, but not working) I would like to have the question even if the visitor do not let his email. I thought about updating the record, but I don't know how to get the record ID from the 2. step. Any idea anyone? @bumpy-butcher-41910? https://cdn.discordapp.com/attachments/1247638595234300085/1247638595511255050/image.png?ex=6660c17d&is=665f6ffd&hm=103018754b70d92d38a90f75e8b039b5d20c35fa4d62f25bd91170e8f39569f2&
w
Hey ! you can store the question in a variable, than if the bot doesn't have the answer, ask for the user email, and insert a record with both information , I think it's the best way to achieve what you want to do
but maybe someone will have an other idea !
m
Hye, thanks for your answer but this exactly what's I've done ahah The problem is that I want to get the question even if the visitor do not give his email. Because by inserting the record with both data (question + email), it will be triggered only if both are available
w
that's not what you described, which is why I suggested it ^^
yes but you can insert a record even if your variableworkflow.email is empty
but in your table you will have the question, and then a blank for the email
in the first case i left an email, not in the second case, but i have the same node to insert a record
or i don't understand well your request and Robert will maybe have an answer !
Because currently what you are doing is to ask for the user's email address after inserting the question in the table, in which case it's difficult to find the right id.
b
yeah this^ hits the nail on the head
you could always ask for the email and allow them to decline - to do this, you would just allow the variable to fail on capture
m
Ahhh ok I get it! Thanks @wooden-beard-40210 & @bumpy-butcher-41910 🙏
b
\o/