Users not completed form

[drmt1979]

Hi

I am new to caspio and not a fluent sql programmer but understand some of the logic. I have a Users_table, and a particular submit form, that includes a submitted_by field for the unique email address of the user. I would like to create a report that lists out the users that have not completed the form on that particular day. And a summary table of the number of users completed vs not-completed. Ideally I would be able to include other filters in the pivot.

I am having a problem structuring this in the report, can anyone help out with just the first part?

 

Thanks

 

[astroboy]

Hello @drmt1979, one possible way that I can think of to achieve this is to create a Triggered Action that will stamp the status of the entry as 'completed' upon submit and then you may create a view to filter out the users that have not completed the form based on the status field. You may check the following articles for reference:

Triggered Actions - https://howto.caspio.com/tables-and-views/triggered-actions/
View - https://howto.caspio.com/tables-and-views/what-are-views/

I hope this helps.

Cheers!