Letter for Communicating
How would I create a letter for communicating to an employee? I have a table with the information needed but I need to create a letter that has that information on it for the supervisor to email to ea...
Forum Discussion
We can definitely work through this together. The first step is to create a dedicated form called perhaps monthly performance feedback. Obviously lay out the form with the employee name at the top and the various performance feedback fields on the form. For the actual text words of the form you can either have Text elements that are directly typed into the form or else you can also make rich text formula fields to construct the text.
You can then experiment by setting up an email notification to yourself being triggered when a particular date time field is updated. You can make a field called send performance feedback as a date time field.
When i I have a moment, I will post back here with the code for a button which will update that field with the current date time and refresh the page.
I suggest that you make a report filtered where that date time field is not equal to today.
That way the manager can run the report and simply quickly click on the 20 buttons to send the 20 emails. After each click the report will refresh with one less record on it. So the manager just keeps clicking until they are all gone.
I would set that email notification up so that the from or reply to email is set to be the user in the field last modified by. That way if the employee has any questions they can respond to the email as opposed to responding to Notify@Quickbase. which is a deep dark black hole.
There are more advanced techniques which would allow you to send multiple emails in one click but let's get the basics working and in all probability a manager doesn't have so many people reporting to them that clicking 10 or 20 buttons would be a problem.
I will post back with some suggested button code in the next day or two.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
You can then experiment by setting up an email notification to yourself being triggered when a particular date time field is updated. You can make a field called send performance feedback as a date time field.
When i I have a moment, I will post back here with the code for a button which will update that field with the current date time and refresh the page.
I suggest that you make a report filtered where that date time field is not equal to today.
That way the manager can run the report and simply quickly click on the 20 buttons to send the 20 emails. After each click the report will refresh with one less record on it. So the manager just keeps clicking until they are all gone.
I would set that email notification up so that the from or reply to email is set to be the user in the field last modified by. That way if the employee has any questions they can respond to the email as opposed to responding to Notify@Quickbase. which is a deep dark black hole.
There are more advanced techniques which would allow you to send multiple emails in one click but let's get the basics working and in all probability a manager doesn't have so many people reporting to them that clicking 10 or 20 buttons would be a problem.
I will post back with some suggested button code in the next day or two.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
ok, I started building a form before I posted so let me get further on that and absorb your explanation.
------------------------------
Katherine Park
------------------------------
------------------------------
Katherine Park
------------------------------
- Here is what a URL formula would look like to populate a date/time field type with field ID 99 to be updated with the current date/ time, and refresh the page you are on.
var text URL = URLRoot() & "db/" & dbid() & ?act=API_EditRecord&rid=" & [Record ID#]
& "&apptoken=xxxxxxxxxxx"
& "&_fid_99=" & URLEncode(now());
"javascript:" &
"$.get('" &
$URL &
"',function(){" &
"location.reload(true);" &
"});"
& "void(0);"
// the apptoken is only required if you have left them as being required in the Advanced Properties tab of the app Settings..
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
