This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Return the ID of the just created row inside a Bot

Posted on 11-16-2022 02:20 AM
DroidTeo
Silver 1
Silver 1
Reply posted on --/--/---- --:-- AM

Hello all!
I have a bot, that works on Table1, inside the process used by the bot, I create a new line inside Table2. 

I would like (need) to recover inside this boot the ID of the just added line (inside the Table2) and then, add this ID inside a line of Table1. (note this line is the final step of my bot).
I want to all this, without using a Ref column.. It is not really necessary in this specific case. 

To be more clear, Table2 is the the table generated from Google Calendar and so, I don't want/need to have a foreing key between the GCalendar table and Table1.

Do you think that it is possible? 
If yes, can you please help me? 

0 2 161
Topic Labels
0 Likes
2 REPLIES 2

Posted on --/--/---- --:-- AM
Marc_Dillon
Platinum 1
Platinum 1
Reply posted on --/--/---- --:-- AM

Just use MAXROW() ?

Posted on --/--/---- --:-- AM
DroidTeo
Silver 1
Silver 1
In response to Marc_Dillon
Reply posted on --/--/---- --:-- AM

Mmm.. 
I'm wondering in case of concurrent trigger of the bot.. what can be the result? 

I the bot is trigger at the same moment 2 times.. the MAXROW() could return the wrong line.. 2 user logged in at the same moment, that trigger the bot at the same moment etc.. 

 

Ok, a lot of IFS, but.. we never know! ๐Ÿ™‚