Hey..!
I’m working on request submissions and approvals process app.
I have two tabs “Master” and “Approvals Status Log”. I have used ‘ref’ data type to link these two tabs in the back end. Request # is the key for the “Master” tab in which the initial request submission data is saved. Once the request passes through one round of approvals, the decisions made will be copied into the Approvals Status Log. I have used a bot to copy these values from “Master” tab to “Approvals Status Log” tab in Google Sheets.
I have used “CONCATENATE([_RowNumber], “-”, UNIQUEID())” expression in initial value to generate the unique id as the request number & key (I’m using Request# as the key for this sheet). I want to include the row number into the unique id so that it is easy for me to find the row and request when I’m handing the data in the back end. This expression works perfectly fine for generating the unique id for records in the “Master” tab.
However, the result is not similar when I used the same expression for “Approvals Status Log”. Approvals Status Log has “Status Log ID”, “Request #”, “Approval”, “Timestamp”, “Comment” columns in which “Status Log ID” is the key.
When I used “CONCATENATE([_RowNumber], “-”, UNIQUEID())” in the initial value for “Status Log ID”, I don’t see the expected result. Instead I see this:
The row number is missing in the result. So, I thought of a work around. I removed the initial value expression for “Status Log ID” and assigned the following expression to generate unique ID in the bot along with the other values that are being copied.
And this is the result I got for this expression:
I have also tried using “[_Rownumber] & “-” & UNIQUEID()” for initial value and “Approvals Status Log[_Rownumber] & “-” & UNIQUEID()”. But I’m still getting the same result.
I want to include the row number of respective table into the Status Log ID (In this case, key for Approvals Status Log tab) when I’m adding a new record to the table.
Any kind of work around or input is gladly appreciated.
Thank you.