Create an easy way to vote on any record in a Quickbase app. A little visual thumbs up and down emoji allow users to show the thoughts in a record easily.

Great for apps that collect feedback or are used for retros in an agile team process.

**Use this voting to also control coloration of records:
https://demo.quickbase.com/db/bpj7nsk6n?a=dr&rid=61&rl=pc6

In the table with the records you want to upvote:
1. Add 7 fields: 
Thumbs-up icon (Type: Formula - Rich Text)
Thumbs-down icon  (Type: Formula - Rich Text)
No votes (Type:Numeric)
Yes votes (Type:Numeric)
Vote nope formula (Type: Formula - URL)
Vote yep formula (Type: Formula - URL)
Vote bar  (Type: Formula - Rich Text)

2. For each field listed above, except the 2 numeric fields, copy and paste the formulas (in the 
Copy paste code" on the right) for each into its field properties.

3. For the first 2 fields (Thumbs-up icon and Thumbs-down icon) change the reference of the table in the formula [_DBID_FILES] - to match the name of the table in your app that contains your emoji images.

4. In the "Vote nope" and "Vote yep" formulas change the field ID in the formula to match the corresponding numeric fields. No votes with the No votes ID and Yes votes with the Yes votes ID.

5. Any where you want to add the voting ability, add the "Vote bar" field and users will be able to vote for their hearts desire.

** Upload the images you would like to use for emojis into an Quickbase table. Easiest way is find two images and upload them into an "images" table in your app. 

** if your application has app tokens enabled, you may receive an error. Search our help center for tips on adding or disabling app tokens

Thumbs-up icon: Formula - Rich Text (Copy the formula below)

"<img alt='' src='" & URLRoot() & "/up/" & [_DBID_FILES] & "/g/rc/eg/va/Thumbs%20Up%20Hand%20Sign%20Emoji.png' style='width: 20px; height: 20px;' />"


Thumbs-down icon: Formula - Rich Text (Copy the formula below)

"<img alt='' src='" & URLRoot() & "/up/" & [_DBID_FILES] & "/g/rd/eg/va/Thumbs%20Down%20Sign%20Emoji.png' style='width: 20px; height: 20px;' />"


Vote nope formula: Formula - URL (Copy the formula below)

var text URLOne = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#]& "&_fid_17=" & ([No Votes] + 1) & "&rdr="&URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl()); 

var text URLTwo = URLRoot() &"db/" & AppID(); 

$URLOne & "&rdr=" & URLEncode($URLTwo)


Vote yep formula: Formula - URL (Copy the formula below)

var text URLOne = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]& "&_fid_17=" & ([Yes Votes] + 1) & "&rdr="&URLEncode(URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl());

var text URLTwo = URLRoot() &"db/" & AppID();

$URLOne & "&rdr=" & URLEncode($URLTwo)


Vote bar: Formula - Rich Text (Copy the formula below)

"<div style='display:flex;justify-content: flex-end;margin-bottom: -5px;'><div style='display:flex;'><a href='" & [Vote yep formula] &"'>"& [Thumbs up icon] & "</a><span style='align-items: stretch;vertical-align: bottom;display: inline-block; line-height: 20px;font-size: 14px;padding-left: 5px;padding-top: 3px;'>" & [Yes Votes] & "</span></div><div style='display:flex;padding-left: 25px;padding-top: 3px;'><a href='" & [Vote nope formula] &"'>" & [Thumbs down icon] & "</a><span style='align-items: stretch;vertical-align: bottom;display: inline-block; line-height: 20px;font-size: 14px;padding-left: 5px;'>" & [No Votes] & "</span></div></div>"