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

[Aditya_K1999]

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?

[AleksiAlkio]

What is the Bot changing with your columns Booking Date or Booking ID?

[Aditya_K1999]

Hi Aleksi,

The bot was changing the booking date.

For now I changed the formula in such a way that booking date is not there in the booking number, its only the booking ID. So hence it is working for me now. Anyhow if you have a suggestion please do suggest.

[AleksiAlkio · 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.

[Aditya_K1999]

Okay, Aleksi. Thank you!

[AleksiAlkio]

You're welcome!