I have a resource request form which people need to fill in to make a booking on the production team. Requests then come through as line items. We work in 6.5 hour days so if the amount of time needed is over 6.5 hours I need the item to duplicate so it can be 1 booking per day for the workload widget to show accurate capacity on people. I can't use the timeline feature for the workload widget as it spreads the time evenly across days and often we need someone to work different amounts of hours per day on a project to fit other work around it.
I tried to set up an automation so 'when item is created and hours needed is over 6.5 then duplicate the item'
Unfortunately this just created a never ending duplication as each new item then duplicated as it was over 6.5 hours. Does anyone know how to get it to duplicate once then stop?
I've tried to put conditions in place by clearing columns on duplication but it was only wiping the info out of the original item and didn't stop mass duplication.