re-use of custom field

Helpdesk for my helpdesk software

Moderator: mkoch227

Post Reply
quade
Posts: 16
Joined: Tue Jul 03, 2018 5:05 pm

re-use of custom field

Post 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
Klemen
Site Admin
Posts: 10143
Joined: Fri Feb 11, 2005 4:04 pm

Re: re-use of custom field

Post 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).
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
quade
Posts: 16
Joined: Tue Jul 03, 2018 5:05 pm

Re: re-use of custom field

Post 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?
Klemen
Site Admin
Posts: 10143
Joined: Fri Feb 11, 2005 4:04 pm

Re: re-use of custom field

Post 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
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
Post Reply