Discussions

 View Only

Flag removed projects from next cycle report.

  • 1.  Flag removed projects from next cycle report.

    Posted 06-11-2021 06:41
    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
    ------------------------------