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! Go to 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.
User | Count |
---|---|
16 | |
9 | |
9 | |
7 | |
3 |