I'm trying to use the entries of this form to make spreadsheets for billing my clients. I'd like to set a custom filter for each client so that on the day I need to bill them I can simply apply the preset filter and it will display a period of entries from, say, last monday through friday. I typically will run this on Monday mornings, so I was trying to filter by "today" through "today" minus six days. But, I can't figure out the syntax of how to write that in the advanced editor.
Cognito-forms – Filtering entries by a date range
cognito-forms
Related Solutions
This is definitely something we have discussed supporting. I have sponsored the feature on our Trello Board, as I too would like this ability. https://trello.com/c/Qf0BxQEt
Please up-vote and add your comments to the card on how you would be using entry embedding and what particular functions you would like to see in the feature.
For now, there are a couple of ways you can accomplish getting the data into your website, they just take a little bit more work and know-how.
The first is using our "Post JSON data to website" feature. By writing a custom webhook, you would be able to retrieve your entry data and display it on your site. For more information on this method, read our blog post: https://www.cognitoforms.com/support/66/data-integration/webhooks.
The second method would be to use our recently released Zapier integration. Here, again, you can use the Webhook, or many other options that Zapier offers, such as having the data sent to a SQL or MySQL database. Read more about our Zapier integration here: http://blog.cognitoapps.com/connect-your-cognito-forms-to-almost-anything-with-zapier
My name is Parker, I'm a developer with Cognito Forms. The date based searches on the Entries page must be in the US based format, regardless of the localization settings of the form. Unfortunately, for certain date/time formats the date picker control on the search criteria dialog does not handle this properly.
We are currently working on a fix for this, in the meantime you can switch over to the Advanced Editor for the search criteria and enter a valid US date and the search should work as expected.
Best Answer
The Advanced Filtering code I figured out approaches it a little backward from how I was thinking. This is the filter code that worked for me: