Trigger post service e-mail review

If you did this all in Quick Base then you would not need to go through the steep learning curve of how to trigger and external 3rd party app and then get that survey info back into Quick Base.


I suggest a separate App for this purpose as it will need to be open to everyone on the Internet and I strongly prefer that those apps be stand alone as opposed to just an extra table in your app.


There are probably some posts here or knowledge base article on best practices for everyone on the Internet apps, but the main thing is to have a form for Add and a form for View. The View for is just a blank form saying thank you for your survey,

Doing it natively in quickbase will be great, just need to check the following:


1) If the application is "open to everyone on the internet", how will this affect privacy of information being submitted?  im not sure i fully understand this "open to everyone" concept.  I will do some research

2) How does quickbase natively send an email with a [button] to let the user create a new review record?

The security is far from iron clad, but the nature of the information is that it is not that interesting to try to hack.  I don't have all the links handy to best practices, but more or less you set up a Role and lock down everything that your can to not let the users in that Role do anything but add a record.  Hence the View form which just says "Thank you for your Survey"  So that is they start to hack around with the URL to see a different rid, they will just get the Thank you form.

As for triggering the email, I suggest having an ACTION create a survey request form in the EOTI Role and then set up an "Open" Type Notification which can go to any email address, not just a user.

Ok so i'm starting to understand what you are saying - Makes sense.  One thing that i just need to clarify:

An action creates a new record - Survey request. 
Client will then get an e-mail notification to ask if they can please complete a survey for us.

1) In actual fact has a "New record" has been created, waiting for them to edit it?
1) How will I create a button in the email for them to follow the link and complete the information?
2) From a CSS point of view - How "nice" can i make the e-mail look?

OK, good point about that editing. Never mind the Action. That was muddled thinking on my part.  I think that when the project is completed you need to trigger an email which contains a link to create a new Survey record, as the EOTI Role can only create but not edit or View records.

If you make a hyperlink field to Add a record, then it will look more attractive in the email notification.  I can help you with that.

The form can probably achieve the standard of "not unattractive".  So like not Jennifer Anniston, but still not unattractive.  But it will not be as beautiful and as flexible as a 3rd party service like Survey Monkey where that is their business to be beautiful.   You can have your logo on the form.

Jennifer Anniston, ha ha!  i like that analogy.  OK,  so let me wrap my head around this;

how would the new record that is created be tied into the related project without the e-mail link sending something (other than to just add a new record) to quick base when the record is created?  What i am saying is that the review will be unrelated to the job that was completed.

The Survey record can be a child of the main Job record, but via a cross app relationship.  So the formula for the button will be very similar to the typical native Add Child button that you see all over your app.  Except that the child would be in another app, not just in another table.

I see, so the button will then have the "Information package" for each individual project that tells quick base who the parent is.


The button that gets sent in the e-mail will automatically associate the customers response to the related project.  Does it display as a button or just a URL in the e-mail?

Well if you just put the URL field for Add Survey into the email Notification, it look to the user like a URL that you would see at the top of any Quick Base screen - so that is more like the Wicked Witch of the West as opposed to Jennifer.

But if you make a formula Rich text field like this

"<a href=" & [my add survey user field] & ">"   & "Click here to begin our Short Survey" & "</a>"

Then it will be a nice looking link.  It may even be possible to color the words.

"<a href=" & [my add survey user field] & ">"  

& "<font color=blue>Click here to begin our Short Survey</font color>"  & "</a>"

Mark, why would suggest that a separate app be used for this purpose?  purely from a security point of view?

I suggest a separate app for two reasons.
1. Better security for your main app so that you don not accidentally expose say a new table to your EOTI users because you add the table and forget to hide it.

2. It is sort of weird for the internal staff that when they go to the app not signed in they will not be asked to sign in, as the app is already open to everyone of the internet.  So if you do keep it in the same app, then you need to land users on a dashboard that has an inviting sign on button for employees.

It is a personal preference sort of thing that i am 60/40 on or 70/30 on. not like 100% dead set against having it all in the same app. You can do it all in one app if you like.

I mainly just feel more comfortable with security and the user experience in a separate app.  Keep in mind for example if your EOTI users or your on signed in employees click on the home button or land on the main dashboard they will see the same dashboard.

Ok, so i created the form - It works as planned, but a few things are irritating me.  See the attached image:  Is there no way to hide all this "noise" in the form?  It looks very unprofessional for a stranger to land on this page imo.

And another issue:  they can follow the e-mail link and add as many reviews as they want - Is it not possible to prevent this?