I am copying rows from one spreadsheet to another through my app. Basically importing them and adding the column values as needed.
This works as an action on a view. I use it in a combined action, image #3.
This works as well. I use it in a combined action, image #3.
This is the combined action. Works perfectly from a deck view. But it wonโt work when called from a Report.
My report settings.
Log Error: โErrorsโ: โError: โExecute a Sequence of Actionsโ Grouped action โComboCopyDonorRequestsSetAddedโ child action โCopyDonorToRequestsโ failed due to error: Error: Perform DataAction โCopyDonorToRequestsโ failed because Row having key โ8715fb8eโ in table โRequestsโ in field โSTART_DATEโ is required to have a value. \nError: โAdd Rowโ Data action โCopyDonorToRequestsโ failed with exception Collection was modified; enumeration operation may not execute. .โ,
All the rows in the copy FROM table have a value in [Date Added] which is copied to [START_DATE] so I donโt understand the error. What am I missing?
Solved! Go to Solution.
Ok. After HOURS of work, it turns out it was a DATA problem. One cell in the spreadsheet was blank. I thought I had checked thoroughly enough for blanks but obviously I hadnโt. I fixed that cell and it ran perfectly from the report.
I also added IF(CONTEXT(โHostโ)<>โServerโ,[START_DATE]>=DATE([Timestamp]),TRUE)to the Start_Date valid if in the table I was adding records to. I needed to be able add records with dates older than today.
I also added a report to run before this report to fix missing dates.
Hopefully, lesson learned.
does it work if you trigger it from a workflow? Might be something along the lines of VCโs and a value not being calculated. I dont see anything that is inherently wrong. Maybe try re-arranging the action ordering in your grouped action?
I tried it from a workflow and it worked.
When I switched the order it the actions it set the value to TRUE and the date which then caused it not to find any records to copy on a Report. Running it as an action still worked. So the order has to stay that way when used on a Report.
Ok. After HOURS of work, it turns out it was a DATA problem. One cell in the spreadsheet was blank. I thought I had checked thoroughly enough for blanks but obviously I hadnโt. I fixed that cell and it ran perfectly from the report.
I also added IF(CONTEXT(โHostโ)<>โServerโ,[START_DATE]>=DATE([Timestamp]),TRUE)to the Start_Date valid if in the table I was adding records to. I needed to be able add records with dates older than today.
I also added a report to run before this report to fix missing dates.
Hopefully, lesson learned.
User | Count |
---|---|
44 | |
28 | |
28 | |
21 | |
13 |