So, I have a system that collects data from the user (name, email) but it different stages of the workflow. I have a table that has the following columns: first name, last name and email. When the bot collects a name, i have a find records that checks if that name is already inserted in the table. If it isn't, it adds a new row with the information and if it is, it just continues normally without adding anything. In other part of the workflow, the bot collects the user's email with the same system: checks if its already there, if it isn't it adds a new row if it is it just continues. The thing is, it adds a completely new row with just the user's email, but I want to update the row email with the input the bot has captured. I know I can do that with the update record card but I really don't know how to update the email record based on the user's name. For example: I want the update record to update the email for the user named Robert and just robert, not for any other row.

Ignore the Execute Card & Delete Record Card. In Execute I only have a console.log to check if I have got the correct record Use the Find Records to Find the particular Record and store that into an array variable and use the update card using the same variable to update the record referencing its id

Thank you @limited-pencil-78283 ! I've seen you in a few posts here and there 🙂 thanks so much for helping out the community!!!!

hey @limited-pencil-78283 @crooked-van-25152

Can you share screenshots?

sure

Please click on the + Add properties to update and add what you would like to get updated to the table. It should work

hasn't worked

can you put an execute card in between find and update and do a console.log(workflow.EmailDeUsuarioEncontrado[0])

I don't see the output for console.log

where should it be?

check your personal messages, shared a link

I've had a similar issue before and they weren't getting defined because I had a syntax error. Could that be it?

It is two simple cards, one finds a record and stores value into an array variable, and then an update card which references the array[0].id and updates the email. There isn't any code written. Tried with both workflow and user variables same result. to verify added an execute card with two console.log statement, one just logs "Email is" and it is logged, the second one array[0] and the output is nothing

Hello @swift-beach-91270 !!!, I am going to review it, however I am seeing that many search by name in the table and it should not be like that, remember that you can have several people in your table who will have the same name, this is a recommendation, use the email to search . I'm going to check your bot and see how I can help you.

hey boris

can you put it back? jaja

sorry but that bot i sent was a mistake

ok

it didn't show the same error

ok i will check

tyyy

I'm on it 😉

here it is in node Standard1 -> Find Records -> change to first name is {{workflow.Nombredeusuario.first}} last name is {{workflow.Nombredeusuario.last}}

man

you are most welcome...

I just have to connect that table to a google sheet with make and that's it

after changing the search, we have to find the record that matches the first and last name and if it found the record, you wanted to update email, so .lenght > 0

yeah that's right

Yes, I am making some improvements and considerations, I will give you the bot in a moment

Hey and does anyone know how to connect the table to google sheets with make??

thanks man, it'll help a lot

Prepare an example where I think your approach should be. First you must do the search by email, then know how to use the arrangement of objects that it provides and that is what @limited-pencil-78283 told you to do. Please try the example and take advantage of it. There are many things we can adjust but I don't know your use case.

Did you get this sorted?