Flag removed projects from next cycle report.
Hello,
Each month (around 20th day of month) I am manually uploading the report to Projects table in Quickbase. Users can work on projects and modify them.
I would like to flag the projects which were in previous month report but are not in current month report.
For example in report from April I have projects with id 1, 2, 3 and I upload them to Projects table. In May my report contains project with id 3 only, so I upload this report and update the values for project 3. But I would also flag the projects 1 and 2 as removed.
Do you have any idea, how can I automate this process in Quickbase?
------------------------------
Piotr Kryszkiewicz
------------------------------
Each month (around 20th day of month) I am manually uploading the report to Projects table in Quickbase. Users can work on projects and modify them.
I would like to flag the projects which were in previous month report but are not in current month report.
For example in report from April I have projects with id 1, 2, 3 and I upload them to Projects table. In May my report contains project with id 3 only, so I upload this report and update the values for project 3. But I would also flag the projects 1 and 2 as removed.
Do you have any idea, how can I automate this process in Quickbase?
------------------------------
Piotr Kryszkiewicz
------------------------------