We’ve developed some resources to help you work effectively from home during COVID-19 Click to learn more

Notification on new form submission to process (Sales only)

Is it possible to script the creation of a notification when there is a new unprocessed form submission waiting? The customer in this case is not using Service at all.

RE: Notification on new form submission to process (Sales only)

Hi

Maybe you can do it with CRM trigger? 


you can create a SeachEngine for form_submission table. Something like this 

SearchEngine formSubmissions;
formSubmissions.addField("form_submission.form_id");
formSubmissions.addField("form_submission.status");
formSubmissions.addCriteria("form_submission.form_id", "Equals", "xxx");
formSubmissions.addCriteria("form_submission.status", "Equals", "3");
for (formSubmissions.execute(); !formSubmissions.eof(); formSubmissions.next()){

If I remmeber correctly status 3 is for Submitted. 

And if there is something you can send a message notifiaction to spesific user(s)


Von: Donatas Sasnauskas 21. Feb 2020

RE: Notification on new form submission to process (Sales only)

The only trigger there is for forms is connected to tickets, so it is not of use here.

Von: Patrik Larsson 21. Feb 2020

RE: Notification on new form submission to process (Sales only)

Hello,

You could use the code Donatas provided in a scheduled CRMScript to (periodically) send a notification that an new form submission is there. You would need to add somekind of mechanism to store for which form submission you already send a notification.

See this wish about adding a trigger for when a new form submission comes in (processed or not): https://community.superoffice.com/en/product-releases/bugs-wishes/product-issue/?bid=66498

Von: David Hollegien 21. Feb 2020

RE: Notification on new form submission to process (Sales only)

Or maybe you can add another criteria in search engine for a time. To search for you data entries in a last hour and run Script every hour.
Maybe this can help you to avoid complex mechanism to store for which form submission you already send a notification.

Von: Donatas Sasnauskas 21. Feb 2020

RE: Notification on new form submission to process (Sales only)

That's true, that could be a way of solving it. Thanks guys!

Von: Patrik Larsson 21. Feb 2020