I need to add a button to my form that will load the current timestamp into a field on my form. I think I understand how to use the Dynamic Form Rules to load the value in the finely, but I can't figure out how add the button. In searching for how to add buttons, everything seems to be several years old and does not match the current GUI. Any help would be greatly appreciated!

Are you trying to make a button to be used in Virw Mode or a checkbox yo be used in Edit Mode?

Both. Although I did not think in terms of a checkbox. I have written quite a bit of VBA code in Access and was thinking of a simple push button to execute code when depressed Sorry if the question is dumb, but I am brand new on QuickBase and I am having some issues figuring out stuff like this.

Here is some code which will do that. I also have an app in the Exchange called URL Formuals for Dummies, which helps explain how to write URL formula buttons.vat text URL = urlroot() & "db/" & dbid() & "?act=API_EditRecord" & rid=" & [Record ID#]& "&_fid_999=" & URLEncode(Now());"javascript:" &"$.get('" & $URL & "',function(){" &"location.reload(true);" &"});" & "void(0);"The first line creates a formula variable called URL which does the edit. You will need to set 999 to the field ID which is being set to Now(). Here is some help on formula variables if you have never used them. https://help.quickbase.com/user-assistance/formula_variables.htmlThe second part is a handy snippet which simply runs the URL and refreshes the page.

Thanks for the quick reply. I will definitely download your URL app from the Exchange..

I have a similar issue: I have a text field "Events" which I use to log events. Each event is just a text string:DD/MM/YY text.The events are listed LIFO (most recent first).I would like to button to insert (append) the current date into the field. From there I'll type the text.I tried the above (correct vat to var) and nothing happens. Here is what I havevar text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord" & "rid=" & [RecordID#] & "&_fid_44=" & URLEncode(Now());"javascript:" &"$.get('" & $URL & "',function(){" &"location.reload(true);" &"});" & "void(0);"where 44 is the field ID of the Events field. Please advise.

How can I add a button to load the current date-time to a field

19 Replies

QuickBaseCoachD
Qrew Captain
7 years ago
This is corrected code

var text URLONE = URLRoot() & "db/" & Dbid()
& "?act=API_EditRecord&rid=" & [RecordID#]
& "&_fid_155=" & URLEncode("Hello");

The middle line in your code had an underscore.
ROBERTSACHS
Qrew Cadet
7 years ago
Great. Now that I got that to work.

I figure that need to define a var which is the concat of the Today() and the current text value of hte field of interest, and then edit the record to set to field to that value.
QuickBaseCoachD
Qrew Captain
7 years ago
Right, like

var EventAndType = ToText(Today()) & " some other Text�;

Or maybe

var EventAndType = ToText(Today()) & " � & [Event Type Field];
ROBERTSACHS
Qrew Cadet
7 years ago
I'm using the latter form.
Last question: I need a carriage return after ToText(Today()). What is the coding for that?
- ROBERTSACHS
  Qrew Cadet
  7 years ago
  I figured it out. Thanks.
- ROBERTSACHS
  Qrew Cadet
  7 years ago
  actually, I didn't. I thought I could use "%0D%0A" but that does not work.
- QuickBaseCoachD
  Qrew Captain
  7 years ago
  The Carriage Return character is backslash n
  
  So
  
  "\n"
  
  This will go to edit mode,
  
  var text URLTWO = URLRoot() & "db/" & Dbid()
  & "?a=er&rid=" & ToText([RecordID#]);
ROBERTSACHS
Qrew Cadet
7 years ago
Ah: and I need to put the record into edit mode.

Forum Discussion

How can I add a button to load the current date-time to a field

19 Replies

Related Content

Formula Date Time Will not Accept Null Condition

Using pipelines to log the date/time including the seconds of a record change

Convert timestamp to Date/Time

Date/Time format

Convert date and time to date/time