Skip to main content
Question

Auto-Fill an end date?

  • April 3, 2017
  • 0 replies
  • 59 views
Hey, guys, I'm pretty new to QuickBase, but I currently have a button that sets the status of a task to "Complete" and redirects to the table view (where you originally clicked the button)

I tried to use a form rule that would Auto-Fill the end date with today's date once the status changes to complete, but it isn't cooperating with the button. So the status will change but it won't populates the date. 

Can I get my current "complete" button to populate the date too?

Here's the button code, thanks!

var text url=
URLRoot()& "db/" &Dbid()& "?a=API_EditRecord" & 
"&rid=" & [Record ID#]&
"&apptoken=cn3eu67ch3m9b76jdmn5b7vzn6d"&
"&_fid_10=Complete";

"javascript:" &
"$.get('" & 
$url & 
"',function(){" &
"location.reload();"&
"});
      This topic has been closed for replies.

      • MCFNeil
      • Registered
      • April 3, 2017
      Form rules only work while manually editing the form.  

      You'll need to add the date field to your code above.  

      What is the field ID of the date field you are wishing to populate?
      • MannyCruz
      • Author
      • Registered
      • April 3, 2017
      Thank you for the reply!

      See, I didn't know that about QuickBase, 

      The field ID of the date field I want to populate is "9
      • MCFNeil
      • Registered
      • April 3, 2017
      Insert this into your equation;

      "&_fid_9="&URLEncode(Today())

      So it will look like this...

      var text url=
      URLRoot()& "db/" &Dbid()& "?a=API_EditRecord" & 
      "&rid=" & [Record ID#]&
      "&apptoken=cn3eu67ch3m9b76jdmn5b7vzn6d"&
      "&_fid_10=Complete"&
      "&_fid_9="&URLEncode(Today())
      ;

      "javascript:" &
      "$.get('" & 
      $url & 
      "',function(){" &
      "location.reload();"&
      "});
      Terms & ConditionsAccessibility statement