Filters

Filters
is
 
Forum Title
OldPostUrl
Content
 
Button with Save and Edit functionality PostURL "<a class='Vibrant Success' onclick=$('#RedirectURL').val(document.location.href.replace(/&rl=[a-z0-9]*/,''));$('[name=rl]').val('');$('#saveButton').trigger('click'); href='#'>Save & Edit</a>"
How to create a pop up thumbnail/snapshot of a formula field text field/Text Multi line field PostURL "<img src=https://images.quickbase.com/si/16/118-scroll.png " & "title='" & [Text] & "'>"
How can I use a formula field to create a table based on the data in a record? PostURL "<table>" &
"  <tr>" &
"    <td>" & [field1] & "</td>" &
"    <td>" & [field2] & "</td>" &
"    <td>" & [field3] & "</td>" &
"  <tr>" &
"  <tr>" &
"    <td>" & [field4] & "</td>" &
"    <td>" & [field5] & "</td>" &
"    <td>" & [field6] & "</td>" &
"  <tr>" &
"</table>"
Is there a way to have urls from a Formula URL field appear as buttons in a notification email? PostURL "<a href='" & 
[url] & 
"' style='box-sizing: border-box; color: #ffffff; text-decoration: none; border-radius: 5px; cursor: pointer; display: inline-block; font-size: 14px; font-weight: bold; text-transform: capitalize; background: #1271db; margin: 0; padding: 12px 25px; border: 1px solid #1271db;'>Click Here</a>"
How to get hits on French accented words like Lévis when searching Levis. PostURL var Text F = URLEncode([field]);

var Text PA = Part($F, 1, "%");
var Text PB = Part($F, 2, "%");
var Text PC = Part($F, 3, "%");
var Text PD = Part($F, 4, "%");
var Text PE = Part($F, 5, "%");

var Text QA = $PA;
var Text QB = NotLeft($PB, 2);
var Text QC = NotLeft($PC, 2);
var Text QD = NotLeft($PD, 2);
var Text QE = NotLeft($PE, 2);

var Text RB = Left($PB, 2);
var Text RC = Left($PC, 2);
var Text RD = Left($PD, 2);
var Text RE = Left($PE, 2);

var Text SB = Case($RB,
  "C0", "A",
  "C1", "A",
  "C2", "A",
  "C3", "A",
  "C4", "A",
  "C5", "A",
  "C7", "C",
  "C8", "E",
  "C9", "E",
  "CA", "E",
  "CB", "E",
  "CC", "I",
  "CD", "I",
  "CE", "I",
  "CF", "I",
  "D0", "D",
  "D1", "N",
  "D2", "O",
  "D3", "O",
  "D4", "O",
  "D5", "O",
  "D9", "U",
  "DA", "U",
  "DB", "U",
  "DC", "U",
  "DD", "Y",
  "E0", "a",
  "E1", "a",
  "E2", "a",
  "E3", "a",
  "E4", "a",
  "E5", "a",
  "E7", "c",
  "E8", "e",
  "E9", "e",
  "EA", "e",
  "EB", "e",
  "EC", "i",
  "ED", "i",
  "EE", "i",
  "EF", "i",
  "F0", "i",
  "F1", "n",
  "F2", "o",
  "F3", "o",
  "F4", "o",
  "F5", "o",
  "F6", "o",
  "F9", "u",
  "FA", "u",
  "FB", "u",
  "FC", "u",
  "FD", "y",
  "FF", "y"
);

var Text SC = Case($RC,
  "C0", "A",
  "C1", "A",
  "C2", "A",
  "C3", "A",
  "C4", "A",
  "C5", "A",
  "C7", "C",
  "C8", "E",
  "C9", "E",
  "CA", "E",
  "CB", "E",
  "CC", "I",
  "CD", "I",
  "CE", "I",
  "CF", "I",
  "D0", "D",
  "D1", "N",
  "D2", "O",
  "D3", "O",
  "D4", "O",
  "D5", "O",
  "D9", "U",
  "DA", "U",
  "DB", "U",
  "DC", "U",
  "DD", "Y",
  "E0", "a",
  "E1", "a",
  "E2", "a",
  "E3", "a",
  "E4", "a",
  "E5", "a",
  "E7", "c",
  "E8", "e",
  "E9", "e",
  "EA", "e",
  "EB", "e",
  "EC", "i",
  "ED", "i",
  "EE", "i",
  "EF", "i",
  "F0", "i",
  "F1", "n",
  "F2", "o",
  "F3", "o",
  "F4", "o",
  "F5", "o",
  "F6", "o",
  "F9", "u",
  "FA", "u",
  "FB", "u",
  "FC", "u",
  "FD", "y",
  "FF", "y"
);

var Text SD = Case($RD,
  "C0", "A",
  "C1", "A",
  "C2", "A",
  "C3", "A",
  "C4", "A",
  "C5", "A",
  "C7", "C",
  "C8", "E",
  "C9", "E",
  "CA", "E",
  "CB", "E",
  "CC", "I",
  "CD", "I",
  "CE", "I",
  "CF", "I",
  "D0", "D",
  "D1", "N",
  "D2", "O",
  "D3", "O",
  "D4", "O",
  "D5", "O",
  "D9", "U",
  "DA", "U",
  "DB", "U",
  "DC", "U",
  "DD", "Y",
  "E0", "a",
  "E1", "a",
  "E2", "a",
  "E3", "a",
  "E4", "a",
  "E5", "a",
  "E7", "c",
  "E8", "e",
  "E9", "e",
  "EA", "e",
  "EB", "e",
  "EC", "i",
  "ED", "i",
  "EE", "i",
  "EF", "i",
  "F0", "i",
  "F1", "n",
  "F2", "o",
  "F3", "o",
  "F4", "o",
  "F5", "o",
  "F6", "o",
  "F9", "u",
  "FA", "u",
  "FB", "u",
  "FC", "u",
  "FD", "y",
  "FF", "y"
);

var Text SE = Case($RE,
  "C0", "A",
  "C1", "A",
  "C2", "A",
  "C3", "A",
  "C4", "A",
  "C5", "A",
  "C7", "C",
  "C8", "E",
  "C9", "E",
  "CA", "E",
  "CB", "E",
  "CC", "I",
  "CD", "I",
  "CE", "I",
  "CF", "I",
  "D0", "D",
  "D1", "N",
  "D2", "O",
  "D3", "O",
  "D4", "O",
  "D5", "O",
  "D9", "U",
  "DA", "U",
  "DB", "U",
  "DC", "U",
  "DD", "Y",
  "E0", "a",
  "E1", "a",
  "E2", "a",
  "E3", "a",
  "E4", "a",
  "E5", "a",
  "E7", "c",
  "E8", "e",
  "E9", "e",
  "EA", "e",
  "EB", "e",
  "EC", "i",
  "ED", "i",
  "EE", "i",
  "EF", "i",
  "F0", "i",
  "F1", "n",
  "F2", "o",
  "F3", "o",
  "F4", "o",
  "F5", "o",
  "F6", "o",
  "F9", "u",
  "FA", "u",
  "FB", "u",
  "FC", "u",
  "FD", "y",
  "FF", "y"
);

$QA & $SB & $QB & $SC & $QC & $SD & $QD & $SE & $QE
Need help showing Notes in an alert box. Notes is a multiline text and alert chokes on it. PostURL var Text notes = URLEncode([text]);

"<a href='#' onclick='alert(unescape(`" & 
$notes & 
"`));'>Notes</a>"
Can html be used solely in a formula text field? Is it possible to generate a chart type picture written in html? PostURL "<div style='display: table; border-collapse: collapse; border: 1px solid black;'>" & 
"  <div style='display: table-row'>" & 
"    <div style='display: table-cell; border: 1px solid black; padding: 10px;'>Two</div>" & 
"    <div style='display: table-cell; border: 1px solid black; padding: 10px;'>Seven</div>" & 
"    <div style='display: table-cell; border: 1px solid black; padding: 10px;'>Six</div>" & 
"  </div>" & 
"  <div style='display: table-row'>" & 
"    <div style='display: table-cell; border: 1px solid black; padding: 10px;'>Nine</div>" & 
"    <div style='display: table-cell; border: 1px solid black; padding: 10px;'>Five</div>" & 
"    <div style='display: table-cell; border: 1px solid black; padding: 10px;'>One</div>" & 
"  </div>" & 
"  <div style='display: table-row'>" & 
"    <div style='display: table-cell; border: 1px solid black; padding: 10px;'>Four</div>" & 
"    <div style='display: table-cell; border: 1px solid black; padding: 10px;'>Three</div>" & 
"    <div style='display: table-cell; border: 1px solid black; padding: 10px;'>Eight</div>" & 
"  </div>" & 
"</div>"
I need to create a cumulative column that has a running total. PostURL "<a class=\"Vibrant Success\" onclick=\"$.getScript(gReqAppDBID+'?a=dbpage^pagename=" & [Script] &  "');return false;\">" & [Script] & "</a>"
I Just Got Reamed Out By The QuickBase Coordinating Council!!!!   (1) Users keep asking for counters on their reports. You know count 1, 2, 3 etc for each record in the report regardless of the existing [Record ID#]s.
    Here is a simple formula that will count starting at 1:

    "<img src onerror='++window.QBU_Count||(window.QBU_Count=1);this.outerHTML=QBU_Count'>"

(2) Users often want to calculate quantities for which there are no existing functions in the QuickBase formula language. For example there are no trigonometric functions available. 
    Here is a simple formula that will calculate and display the sine of the field [x]:

    "<img src onerror='this.outerHTML=Math.sin(" & ToText([x]) & ")'>"

(3) Users often want to perform counting, looping or some other iterative process in a QuickBase formulas. Well we all know you can't do that and the workaround has been to write siome long formula that performs the processing some maximum number of times. Why this question just came up the other day with someone wanting to count the number of words in a multi-line text field.
    Here is a simple formula that will count the number of words in the multiline text feild [Words]:

    "<img src onerror='this.outerHTML=`" & [Words] & "`.split(/\s+/).length'>"

(4) Calculate Prime Numbers Less then [Number]

"<img src onerror='this.outerHTML=( function(max) { var sieve = [], i, j, primes = []; for (i = 2; i &lt;= max; ++i) { if (!sieve[i]) { primes.push(i); for (j = i &lt;&lt; 1; j &lt;= max; j += i) { sieve[j] = true; } } } return primes.join(", &quot;); } )(" & [Number] & ")'>"
how do I force a number field to format as a ratio?   "<img src onerror='this.outerHTML=( function(x) { var tolerance = 1.0E-6; var h1=1; var h2=0; var k1=0; var k2=1; var b = x; do { var a = Math.floor(b); var aux = h1; h1 = a*h1+h2; h2 = aux; aux = k1; k1 = a*k1+k2; k2 = aux; b = 1/(b-a); } while (Math.abs(x-h1/k1) &gt; x*tolerance); return h1+&quot;/&quot;+k1; } )(" & [Number] & ")'>"
Cumulative column without summary report   "<img src onerror='window.QBU_Sum = (window.QBU_Sum || 0) + " & [Quantity] & ";this.outerHTML=QBU_Sum'>"
Extracting PO# or Invoice # from a Field into another Field   "<div class='Vibrant Success' onclick=\"var QBU_subject=_fid_6.value;var QBU_matches = QBU_subject.match(/([a-z]?[0-9]{5,})/gi);_fid_7.value=QBU_matches.join('\\n');\">Parse</div>"
Hide table row in quickbase table PostURL "javascript:" &
"$('#rid' + " & [Record ID#] & ").hide();" &
"void(0);"
Using Fields in Formula Text PostURL "<div " &
 "style='color:white;background-color:#339900'" &
 "title='" & 
  [Appointment - Outlook Start] & "-" & 
  [Attending?] & "-" &
  [Appointment] & 
 "'>" & 
 [Resource Name] &
"</div>"
Is there a way to insert a Quickbase field into a html text item on a form? PostURL "<table border='1'>" &
"<tr>" &
"<th>Header 1</th>" &
"<th>Header 2</th>" &
"</tr>" &
"<tr>" &
"<td>" & [Field1] & "</td>" &
"<td>" & [Field2] & "</td>" &
"</tr>" &
"</table>"
URL formula to include login / authentication. PostURL "https://www.quickbase.com/db/main" &
"?a=SignIn" &
"&nexturl=" &
URLEncode("https://www.quickbase.com/db/DBID?a=er&rid=1&dfid=2") &
"&rc=psi"

=====

"https://www.quickbase.com/db/main" &
"?a=signin" &
"&what=" &
"nexturl=" &
URLEncode("https://www.quickbase.com/db/DBID?a=er&rid=1&dfid=2&loginid=USERNAME&password=PASSWORD&SignIn=+++Sign+in+++")
can I adjust the width of a field with multiple choice text items? PostURL "<img src=\"/i/clear2x2.gif\" " &
"onload=\"javascript:if(typeof QBU=='undefined'){QBU={};$('#formContents select').css('min-width','5em');}\">"
Add Record and control the form id# used to display upon saving PostURL "<img qbu=\"module\" src=\"/i/clear2x2.gif\" " &
"onload=\"javascript:$('input[name=RedirectURL]').val('http://www.infowars.com/');void(0);\">"
Restricting underlying data to users in summary report PostURL javascript:$("body").load("https://www.quickbase.com/db/7c2gsmqv?a=q&qt=tab&query={'24'.SW.'y'}&slist=24&opts=so-A.gb-V.not.&ivf=1 #ViewTotalsTable",function(){$("a").contents().unwrap();});void(0);
where do the deleted posts go? PostURL var Number fid=6;

var Text url="https://www.quickbase.com/up/" &
 Dbid() &
 "/a" &
 "/r" & [Record ID#] &
 "/e" & ToText($fid) &
 "/v0";

var Text stub = "https://images.quickbase.com/si/16/";

If(
 Right([file],".")="xls","<a href=\"" & $url & "\"><img src=\"" & $stub & "142-excel.png\"></a>",
 Right([file],".")="doc","<a href=\"" & $url & "\"><img src=\"" & $stub & "143-word.png\"></a>",
 Right([file],".")="pdf","<a href=\"" & $url & "\"><img src=\"" & $stub & "144-adobe.png\"></a>"
)
Link to detail record (answer) PostURL If([# of Test 2 Records]=0,URLRoot() & "db/" & [_DBID_TEST_2] & "?a=API_GenAddRecordForm&_fid_8=" & URLEncode ([Record ID#])& "&z=" & Rurl(),
https://www.quickbase.com/db/bfqdyahuq?a=s&query={'8'.TV.'1'}&opts=disprec)
Font control to match QuickBase Native Forms Section Headiings PostURL "<img src=\"/i/clear2x2.gif\" " &
"onload=\"javascript:alert('before');$('td[id^=tdf]').css('background-color','#FFFFFF');alert('after');void(0);\">" &

"<div style=\"background-color:white; font-family: arial; \n\n font-size: 128%; font-weight: bold; color: #226;\">History Log2</div>"
Print out QR Bar Code labels in QuickBase PostURL var Text plaintext ="https://www.quickbase.com/db/bf6yfm8aj?a=q&qid=7&nv=1&v0=";
var Text ciphertext = URLEncode($plaintext & [sku]);
var Text url = "http://chart.apis.google.com/chart?cht=qr&chs=180x180&chl=" & $ciphertext;

"<img src='" & $url & "'>"
How to use API calls PostURL URLRoot() & "db/" & DBID() & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_#=value&rdr=" & URLEncode(URLRoot() & "db/" & DBID() & "?a=dr&rid=" & [Record ID#])
WeekDaySub Function - want my times of day too!! PostURL var Date theOldDate = ToDate(Left(ToText([Date/TimeOLD])," "));
var TimeOfDay theOldTime = ToTimeOfDay(NotLeft(ToText([Date/TimeOLD])," "));

var Date theNewDate = ToDate(Left(ToText([Date/TimeNEW])," "));
var TimeOfDay theNewTime = ToTimeOfDay(NotLeft(ToText([Date/TimeNEW])," "));

var Duration theDays = Days(WeekdaySub($theNewDate,$theOldDate));

var Duration theHours = Hours(Hour($theNewTime) - Hour($theOldTime));

var Duration theMinutes = Minutes(Minute($theNewTime) - Minute($theOldTime));

ToHours($theDays + $theHours + $theMinutes)
Formula Help?? PostURL var number theoldday = DayOfWeek(ToDate([Date Created]));

var number theoldhour = Hour(ToTimeOfDay([Date Created]));

var number theoldmin = Minute(ToTimeOfDay([Date Created]));

var number thenewmin = If(($theoldhour<7 or $theoldhour>=17) or ($theoldday=6 or $theoldday=0),0,$theoldmin);

var date daydif = 
If($theoldday=6,
   ToDate([Date Created])+Days(2),
 $theoldday=0,
   ToDate([Date Created])+Days(1),
 $theoldday=5 and $theoldhour>=17,
   ToDate([Date Created])+Days(3),
 $theoldday=1 or $theoldday=2 or $theoldday=3 or $theoldday=4 and $theoldhour>=17,
 ($theoldday=1 or $theoldday=2 or $theoldday=3 or $theoldday=4) and $theoldhour>=17,
   ToDate([Date Created])+Days(1),ToDate([Date Created])
);

var number thenewhour = 
 If(($theoldhour<7 or $theoldhour>=17) or ($theoldday=0 or $theoldday=6),
 7,$theoldhour
);

ToTimestamp(
 $daydif,
 ToTimeOfDay(ToText($thenewhour & ":" & $thenewmin))
)
Can I create a administrator editable "nickname" for users? PostURL Case([group],
 "Group A",ToUserList(ToUser("dandiebolt@yahoo.com"),ToUser("dandiebolt@gmail.com")),
 "Group B",ToUserList(ToUser("dandiebolt@yahoo.com")),
 "Group C",ToUserList(ToUser("dandiebolt@gmail.com"))
)
Can if(..) statements do 2 things? PostURL [text (with some HTML)]=
If([number] >= 0,
 "<span style='color:black;'>Positive</span>",
 "<span style='color:red;'>Negative</span>"
)
Link question PostURL [TYPE (text with some HTML allowed)]=
var Text label="Logons: " & [Function/ Logon Count] &  " Primary HW: ";
var Text url=ToText([Function/Device Name]);
If([Function/ App List],
 $label & " <a href='" & $url & "'>" & $url & "</a>",
 ""
)
Help with HMTL on Text Formula field PostURL If([field] = "Custom",
 "<span style='color:green'>Custom</span>",
 "<span style='color:blue'>Not Custom</span>"
)
QR codes to find specific record? PostURL "http://chart.apis.google.com/chart" &
"?cht=qr" &
"&chs=300x300" &
"&chl=" &
  URLEncode("https://www.quickbase.com/db/bg86ky424?a=dr&rid=" & [Record ID#])

"http://chart.apis.google.com/chart" &
"?cht=qr" &
"&chs=300x300" &
"&chl=" &
  URLEncode("https://www.quickbase.com/db/bg86ky424?a=printr&dfid=2&rid=" & [Record ID#])
Formula Text field accessing the contents of a Rich Text Page PostURL "<img src=\"/i/clear2x2.gif\" " &
"onload=\"javascript:$(this).closest('td').load('https://www.quickbase.com/db/DBID?a=dbpage&pagename=rich.html');\">"

Can I collapse a text field on reports? PostURL var Text a = Left([field],100);
var Text b = NotLeft([field],100);

$a & 
" <a onclick=\"$(this).hide();$(this).next().show().next().show();\">More</a>" &
" <span style='display:none'>" & $b & "</span>" &
" <a style='display:none' onclick=\"$(this).hide();$(this).prev().hide().prev().show();\">Less</a>"
What formula should i use to create a "save and go to the next record" button? PostURL "<a class='Vibrant Success' onclick='try{saveAndNextMenuOption.click()}catch(exception){try{saveMenuOption.click()}catch(exception){saveButton.click()}}'>Save ...</a>"
multiple file download PostURL // Format of File Attachement URL:
// https://quickbase.com/up/DBID/a/rRID/eFID/vVID
// DBID Database ID
// RID Decimal Record ID
// FID Decimal Field ID
// VID Decimal Version ID (starts at 0)

"javascript:" &
"window.open('https://www.quickbase.com/up/" &
Dbid() &  
"/a/r" & 
[Record ID#] & 
"/e6/v0');" &
"window.open('https://www.quickbase.com/up/" &
Dbid() &  
"/a/r" & 
[Record ID#] & 
"/e7/v0');" &
"void(0)"

We're glad you're interested in doing more with Quick Base!

Now we need to make you official before you share apps or manage your account.

Verifying your email lets you share Quick Base with others in your company.

Your work email
Your company
Report Name *
Description
Reports and Charts Panel
Each table has a panel listing its reports and charts, organized in groups.
This report will be listed only for you, in the group Mine.
Only you can see the report in the panel. You can't ever list it for other users. You can still let others open it by sending them links.
Please wait while your new report is saved...
You've made changes
Save
Field label
Column heading override
Justification
What does auto mean?
Fields in:

Fields to Extract:

Name for the new table:
Items in the new table are called:

When you bring additional fields into a conversion, Quick Base often finds inconsistencies. For example, say you're converting your Companies column into its own table. One company, Acme Corporation, has offices in New York, Dallas and Portland. So, when you add the City column to the conversion, Quick Base finds three different locations for Acme. A single value in the column you're converting can only match one value in any additional field. Quick Base needs you to clean up the extra cities before it can create your new table. To do so, you have one of two choices:

Read more about converting a column into a table.

Show fields from Show fields from Show fields from a related table