Sep 27, 2024 12:24 PM
hi!
I have an error in my base that when a project name is changed, the allocation column is deleted. I do not want this to happen, please give guidance on how to adjust automations so that project name changes will not delete allocations.
Thanks!
Sep 27, 2024 06:57 PM
Hey @lauragallagher! Could you please share further details and/or screenshots of the automation?
The issue is most probably found on an "update record" action block of your automation, which is setting the "Allocation" field blank -as per my understanding of your set up.
Happy to help out if you send that over.
Mike, Consultant @ Automatic Nation
Sep 27, 2024 07:03 PM
Could you provide a screenshot of the project name field and the allocation field? Knowing how your base is set up allows us to help you with troubleshooting
Sep 30, 2024 02:25 PM
Sep 30, 2024 02:25 PM
Sep 30, 2024 06:49 PM
Hmm, the screenshots don't provide enough detail to figure out what's happening I'm afraid
If you could provide a read-only invite link to a duplicated copy of your base with some example data I could take a look at this for you! https://support.airtable.com/docs/adding-a-base-collaborator#adding-a-base-collaborator-in-airtable
If you could also indicate which table and field the allocation column and project name column are that'd be great
Oct 01, 2024 06:30 AM
here is the link: https://airtable.com/invite/l?inviteId=inv7cvWCDEeUirq5x&inviteToken=649ac2a0365ea77ca7b2e5aa393f097...
it is under 'monthly forecast allocations'. when the individual projects name changes, the 'projected allocations' and 'actual allocations' columns will delete. thanks!
Oct 01, 2024 09:21 PM
Hmm, it looks like when the Project name changes, it's triggering the automation "3. Create Monthly Team Assignments" which in turn is creating new records for each month and team member for that project. I think the records with the old Project name are then deleted by "6. Delete Inactive Monthly Forecast Allocations Records"
And so I suspect it's not that the column values are being deleted, but that the whole record is being deleted. To test this, try opening a "Monthly Forecast Allocations" and then modifying its linked Project and see whether hte opened record gets deleted