How to stop booking number from changing once the automation is run

I have a table by the name of Service booking, which has a booking number field with the below formula:

(CONCATENATE("MAC"," - ",LEFT(TEXT([Booking Date]),1),MID(TEXT([Booking Date]),6,4)," - ",UPPER(RIGHT([Booking ID],2))))

I am running an automation on the table when the "Generate Estimate" Button is clicked on the table. The purpose of the automation is to generate an estimate file.

But after the automation is run, it is also changing the booking number...how to stop that?

Solved Solved
0 5 234
1 ACCEPTED SOLUTION

It sounds the "Booking date" is reading the date with the app formula. Change it to the initial value and then the Bot won't update it.

View solution in original post

5 REPLIES 5
Top Labels in this Space