LinkedIn
Twitter
I have a table that we create a PM record on with a PM_Number (equals frequency) 7, 14, 28 day.
From there the save event writes a record of it to the PM_Services there with a formula to calculate the Deadline_Date.
From there PM_Services rows will either be
Completed (Completed Date added by User)
or
Expired (If todays date > Deadline_Date)
I was using an automation to run at 2am every wednesday if completed date is not blank it would change status to Completed and make a copy of that row and add a new row on the PM_service table with a new deadline date for next week. if the completed date was blank it would change the status to Expired and make a copy of that row and add a new row on the PM_service table with deadline date for next week. The issue is with this is the Key column. i am using the following formula
concatenate(
"PM_Job-",
count(PM_Service[PM_ServicesID])+1
)
So When the automation runs it might create 10+ Rows and by doing so it gives them all the same key....
Solution i found was using appsheet API however i cant seem to make it work. Here is what i have so far.
