Approval with Mail reply to Quickbase

Question

Team,
I am looking for solution where user can click button and approve request over mail.
WHAT I WANT: I saw that in some services (like SNOW) you can click on the bottom, and it create "Reply" mail which you send from your mail client.Afterwards this mail it used to confirm in system required fields.Any idea how to achieve it with quickbase?
DO NOT WANT: I do not want button to direct user to quickbase app as:1) I cannot set it to EOTI2) I do not want to share App Token it button URL3) Do not want people to be directed to quickbase, as I used it before, and if they are not logged in, they will see XML error.------------------------------Adam Krzyzanek------------------------------

markshnier__you · Answer

There are two adds on I know that will receive incoming emails and parse them to write out a quickBase record.

Juiced tech has an email parser. &nbsp;https://www.juicedtech.com/email-parser

Soft Tech Experts also has one. &nbsp;https://www.softtechexperts.com/
or else perhaps a pipeline could accept the email and then you would need to figure out how to parse the response.

Mark------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

chayceduncan · Answer

Is your intent that the 'reply' will prepopulate the email with the content you're looking to confirm / gather? You can get really creative with a mailto in a &lt;a&gt; tag that prepopulates the entire thing for them to fill something in or say yes / no etc.&nbsp;
Like:&nbsp;
&lt;a href='mailTo:inbox@company.com?subject=Confirmation&amp;body=Fill in whatever HTML data you want to prepopulate&gt;Reply&lt;/a&gt;
You could fill in the body with whatever Quickbase data or format you were looking to collect.
Then to Marks point your could use Pipelines or the native Connected Table Sync to parse out their responses / look for certain values as their sign off.&nbsp;------------------------------Chayce Duncan------------------------------

chayceduncan · Answer

The email would be up to you - I would suggest making a new email address like replies@companyname.com that you set up specifically for this process so that you don't get any additional traffic that you have to worry about.&nbsp;

As for the Pipeline - you would do the trigger when a new email is received&nbsp;

And then from there if you needed to search attachments or search for more detail you would use the query features based on the outlook ID of the email received.&nbsp;------------------------------Chayce Duncan------------------------------

adamkrzyzanek · Answer

Yes I know that I can use Mailto for this to constructWhat I find difficult to imagine is:1) Where to send this mail (to which mail address as reply) - We use MS Office Outlook.2) How Pipeline should reach for this mail with answer (should I use Search Email?)
Any idea for such process??How do you see that after I send mail it is add to "Table" where later Quickbase&nbsp;pull it by "Native Connected Table Sync"------------------------------Adam Krzyzanek------------------------------

Forum Discussion

Approval with Mail reply to Quickbase

4 Replies