Submissions: Automatically delete after a set number of days from pick-up date

I need the submissions automatically deleted after a few days have passed since the pick-up date and time. Is this possible?

Hi Donald,

Thanks for reaching out to Jotform Support. I'm an AI assistant here to assist you.

Yes, it is possible to have submissions automatically deleted after a certain period based on a date field like your pick-up date and time. Jotform offers an Auto-Delete Submissions feature that allows you to set an automatic deletion period for your form's new submissions.

Here’s how to do it:

1. In Form Builder, click on the Settings tab.
2. Click on Show More Options in Form Settings.
3. Scroll down to Auto-Delete Submissions and click on the Enable button.
4. In the Auto-Delete Submissions modal, select a time frame from the Deletion Period dropdown menu.
5. Click Next, then confirm by clicking Yes, Update to save your settings.

Note that deleted submissions are moved to Trash and kept there for 30 days before permanent deletion. You can manually purge trashed entries to free up space.

This feature will automatically delete submissions after the set period, but it does not specifically delete based on the pick-up date field itself. Instead, it deletes submissions based on the time elapsed since submission. If you want to delete submissions based on the pick-up date field specifically, you may need to manage this manually or use integrations or custom workflows.

For more detailed guidance, you can visit the Jotform guide on Deleting Form Submissions Automatically.

Give it a try and let us know how it goes.

That doesn't delete them after the pickup date and time

that deletes them after the default I set

But, I want them deleted after the date set in the forms table

Hi Donald,

I understand you want submissions to be deleted automatically based on the date set in a specific form field (like your pick-up date), not just after a fixed period from submission.

Currently, Jotform's built-in Auto-Delete Submissions feature deletes submissions based on the time elapsed since the submission was made, not based on a date field within the submission itself.

To achieve deletion based on a custom date field like your pick-up date, you would need to manage this manually or use custom workflows or integrations outside of the standard Jotform settings. For example, you could export your submissions and set up a script or use third-party automation tools to delete entries after the pick-up date has passed.

Jotform does not have a native feature to automatically delete submissions exactly after the date specified in a form field.

If you want, I can help guide you on how to set up manual deletion or explore integration options.

Let us know how you would like to proceed.

yes please proceed

Hi Donald,

You can delete submissions manually or set up integrations to manage deletion based on your pick-up date field. Let me show you how to delete submissions manually in Jotform Tables:

1. In Jotform Tables, select the submission you want to delete.
2. Click on Delete at the top right side of the Tables page.
3. In the Confirmation window, click on Move to Trash.

Deleted submissions stay in the Trash folder for 30 days before permanent deletion. You can also permanently delete them from the Trash to free up space.

If you want to automate deletion based on your pick-up date field, you would need to use third-party automation tools or custom scripts that interact with Jotform API to check the date field and delete submissions accordingly.

Let us know if you want guidance on setting up such integrations or need further assistance.

Yes, guidance on third-party automation tools

Hi Donald,

To automate deletion of submissions based on your pick-up date field, you would typically use third-party automation tools or custom scripts that interact with the Jotform API. These tools can check the date in your submissions and delete entries accordingly once the pick-up date has passed.

Popular automation platforms you might consider include:

• Zapier: You can create a workflow that triggers based on submission data and uses Jotform API to delete submissions after the pick-up date.
• Integromat (Make): Similar to Zapier, it allows for custom scenarios that can check submission dates and perform deletion actions.
• Custom scripts: Using Jotform API, you can write scripts (e.g., in Python, JavaScript) that run on a schedule to check submissions and delete those past the pick-up date.

These solutions require some setup and familiarity with APIs and automation tools. Jotform's API documentation can guide you on how to delete submissions programmatically.

If you need, I can provide links to Jotform API documentation or basic examples on how to get started with these tools.

Let us know how you would like to proceed.

Jotform API documentation

Hi Donald,

You can find the Jotform API documentation for managing submissions, including deletion, on the official Jotform API documentation page. It provides detailed guidance on how to use the API to interact with your form submissions programmatically.

For general API documentation, please visit the Jotform API Documentation page.

Additionally, there is a helpful video guide on how to delete and manage form submissions on Jotform. The video explains how to access submissions, delete them, move them to trash, and permanently delete them. You can watch the video at the following link: Guide to Deleting and Managing Form Submissions on Jotform.

At 00:22, the video shows how to navigate to the submission section of your form. At 00:47, it demonstrates how to delete submissions by moving them to the trash, which keeps them recoverable for 30 days. Finally, at 01:10, it explains how to permanently delete submissions from the trash.

This video can help you understand the manual process and complement your use of the API for automation.

Give it a try and let us know how it goes.

• Zapier: You can create a workflow that triggers based on submission data and uses Jotform API to delete submissions after the pick-up date.

Hi Donald,

Yes, with Zapier you can create a workflow that triggers based on your form submission data and uses the Jotform API to delete submissions after the pick-up date has passed.

Here’s a general outline of how you can set this up:

1. Create a Zapier account if you don’t already have one.
2. Set up a trigger in Zapier for new Jotform submissions from your specific form.
3. Add a filter or condition to check if the pick-up date in the submission is before the current date (meaning the pick-up date has passed).
4. Use the Jotform API action in Zapier or a Webhooks by Zapier action to delete the submission via the API if the condition is met.

This requires some familiarity with Zapier workflows and API usage. You can refer to Jotform API documentation for the specific API calls needed to delete submissions.

If you need detailed steps or examples on setting this up, please let me know.

Give it a try and let us know how it goes.

1. Set up a trigger in Zapier for new Jotform submissions from your specific form.

Hi Donald,

Let me help you with that:

1. Log in to your Zapier account.
2. Click on "Create Zap" to start a new workflow.
3. For the trigger app, search for and select "Jotform."
4. Choose the trigger event "New Submission."
5. Connect your Jotform account to Zapier if you haven't already by providing your API key.
6. Select the specific form you want to monitor for new submissions.
7. Test the trigger to ensure Zapier can pull in sample submission data from your form.

Once this trigger is set up, you can proceed to add filters and actions to delete submissions based on your pick-up date field.

Give it a try and let us know how it goes.

Which option is the simplest to set up?

Hi Donald,

The simplest option to set up automatic deletion of submissions is to use Jotform's built-in Auto-Delete Submissions feature. Let me show you how:

1. In Form Builder, click on the Settings tab in the orange navigation bar at the top.
2. Click on Show More Options in Form Settings.
3. Scroll down to the Auto-Delete Submissions section and click on Enable.
4. Select the Deletion Period you want and click Next.
5. Click Yes, Update to save your settings.

This method deletes submissions based on the time elapsed since submission, not the date field in your form. If you need deletion based on a specific date field like your pick-up date, it requires more complex automation using third-party tools or custom scripts.

Give it a try and let us know if you need any other help.

This method deletes submissions based on the time elapsed since submission, not the date field in your form. If you need deletion based on a specific date field like your pick-up date, it requires more complex automation using third-party tools or custom scripts.

Can you recommend someone to set this up for me?

You can get in touch with the right Solutions Partner for you by sorting them by location, type of service, industry, language support, or partner tier. Just fill out the contact form for the Jotform Partner you'd like to work with, so they can make the necessary preparations to help you. Keep in mind, though, that these parties operate independently of Jotform, so we assume no responsibility or liability for their work or their actions.

Where to find Jotform partners?

Hi Donald,

You can find Jotform Partners by visiting the Jotform Partners page on the Jotform website. There, you can sort and filter partners by location, type of service, industry, language support, or partner tier to find the right fit for your needs.

This allows you to connect with professionals who can help set up custom automations or other advanced features for your forms.

Let us know if you have any other questions.