Page 1 of 1

re-use of custom field

Posted: Thu Jul 05, 2018 1:51 pm
by quade
I've setup a custom field called Business Name

If a user emails in (rather than use the form) the Business Name is blank
However, I can edit it

On the next ticket that email address raises, is there a way to pickup the that custom field so i dont have to enter it each time?
if not, how would i achieve this, i can setup a cron job, or call after the pop3 check cron job runs

Re: re-use of custom field

Posted: Thu Jul 05, 2018 7:56 pm
by Klemen
It's not something built-in. You'd have to query the database to get the previous ticket custom field data when the new ticket is being submitted.

This shouldn't be a hard task for someone familiar with PHP so you might consider hiring someone for help (for example on sites like freelancer.com or upwork.com).

Re: re-use of custom field

Posted: Thu Jul 05, 2018 9:16 pm
by quade
Great, we have in house resource
Happy to provide this mod to the community

Which table do I need to query?
Happy to kick off tomorrow

Anything you need for specific mod approval? Or just a forum post?

Re: re-use of custom field

Posted: Fri Jul 06, 2018 6:50 am
by Klemen
All the tickets are in hesk_tickets table. I'd simply find the last ticket with the email address, pull out custom field value and insert it into the new ticket.

You can simply post any modification to the "mods and add-ons" forum:
viewforum.php?f=14