Return the ID of the just created row inside a Bot

DroidTeo · 11-16-2022 02:20 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?

Marc_Dillon

Just use MAXROW() ?

DroidTeo

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! 🙂