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.
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |