Skip to main content
Question

is it possible to add current date in report description

  • October 29, 2019
  • 0 replies
  • 128 views
Hi Everyone,

Can you please let me know if is it possible to add current date in report description

Some thing like : This is the students report as of (current_date).

Basically i am trying to add the current date by a key word . Just want to know if there exists a key word in quickbase that can be used or is there any other way to achieve this?



------------------------------
Pushpakumar Gnanadurai
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+15
  • DonLarson
  • Registered
  • October 29, 2019
Pushpakumar,

I do not know of a way to do that, but will be watching this thread to see if anyone else can solve it.  This could be useful.


------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
  • BabiPanjikar
  • Registered
  • October 29, 2019
You cannot specify/add markers in report description. It is free text only currently.  But this is a great question and you should post this under user voice for QB product team to work with. 

The other work-around is to add a formula text field and add as a column in your report. However, this will repeat the number of records in your report.


------------------------------
Babi Panjikar
------------------------------
EverettPatterso
Forum|alt.badge.img+10
If you are familiar with script, then yes it's easily done. 



HTML in description
Legend <br><div style="border: 1px solid black; width: 450px;">
<img src="https://images.quickbase.com/si/24/206-enable.png">Completed<br>
<img src="https://images.quickbase.com/si/24/238-triang_gray.png">Missing Phone Start Date<br>
<img src="https://images.quickbase.com/si/24/240-triang_green.png">On Time<br>
<img src="https://images.quickbase.com/si/24/213-warning2.png">Past Due<br></div><br>

Report as of: <span class="mytoday" style="font-size: 24px"></span>​


Script to replace description text with HTML and inserts current date/time

(function(){
  var querystring=document.location.search;
  if(/a=q/i.test(querystring)) {
    var description = $("#introText").text().replace(/script/g, "span");
    $("#introText").html(description);
    var mytoday = new Date().toLocaleString();
    $(".mytoday").html(mytoday);
  }
  if(/a=td/i.test(querystring)) {
    var description = $("#descriptionInFacets").text().replace(/script/g, "span");
    $("#descriptionInFacets").html(description);
    var mytoday = new Date().toLocaleString();
    $(".mytoday").html(mytoday);
}
  if(/dlta=mog/i.test(querystring)) {
    var description = $("#descriptionInFacets").text().replace(/script/g, "span");
    $("#descriptionInFacets").html(description);
    var mytoday = new Date().toLocaleString();
    $(".mytoday").html(mytoday);
}
})();



------------------------------
Everett Patterson
------------------------------
    Terms & ConditionsAccessibility statement