[WD22] Update HyperfileSQL from an email

Hello,

I am trying to figure out the best way to update a HyperfileSQL database by an email, this is the process.

Program automatically sends out weekly timesheets by way of email (attached as PDF), i want the recipient to click a hyperlink on the email either YES or NO to confirm the timesheet is correct.
I want the DB to be updated by this reply.

Any ideas the best way to do this?

Cheers

ISO

The only way i can image this is to put something in the email that allow the recipient to reply to your email, like mailto:someone@yoursite.com?subject=UPDATE or mailto:someone@yoursite.com?subject=DONTUPDATE
Make one program that inspects the mailbox used for the reply and proceed acording the received emails.

If you have WebDev it will be a lot easier and a better solution in my opinion. Just send a link in the emails to one AWP page and create one button for accept and another for deny.

Regards

Paulo Oliveira

HI Paulo

Thanks for your reply, the email subject line was one that i was considering. But i have Webdev although havent really used it much, so i will try that suggestion thanks.

Paulo, wonder if you can help me im trying to create a REST Webservice to do this. But cant seem to get it to work. I have the following error message which i cant seem to find much about it:

Error:Inconsistency between the return of the entry point and the value returned by the associated WLanguage procedure. The entry point returns a response while the associated WLanguage procedure returns no value.
REST_TIMESHEET_GUARD, , line 1, column 1

it looks like your procedure associated with the entry point don't end with RESULT

Regards

Paulo Oliveira

Hi Paulo

Sorted many thanks.