I use (or used) an automation via a check box to create a duplicate quote record when e.g. the client wants to make amendments to the line items of a quote and I want to keep the existing quote.
The duplicate record automation replicates a few fields from the previous quote and copies them to the new quote record as per the image below:
The problem I’m having is that the Line Items table’s primary field is a formula field so it looks like the automation doesn’t like it and spits out the following error:
“Field “Name” cannot accept the provided value: Cannot modify a computed field.”
This automation has actually worked before so I’ve no idea why it’s not working now or something has changed somehow.
Is their any way to resolve this or shall I just forget the idea of being able to duplicate this record within the structure of my base?