How do i create a checkbox to acknowledge payment acceptance?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
Want to add a checkbox to be used to mark when a payment has been received, and whether it was made on time or late
Photo of Ryan

Ryan

  • 940 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
I'd work with your application admin to make the needed checkbox, and any report filtering or other criteria that might be needed with the checkbox.
Photo of Ryan

Ryan

  • 940 Points 500 badge 2x thumb
i am the admin
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,702 Points 50k badge 2x thumb
Ryan,
Are you looking for a checkbox or a URL formula button button to perform some edits to the record?
Photo of Ryan

Ryan

  • 940 Points 500 badge 2x thumb
both
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
The general structure of a formula-url button that will edit a record (in view or edit mode) and then refresh the screen is like this:

var text URL= URLRoot() & "db/" & [_DBID_PO] & "?a=API_EditRecord&rid="&[Record ID#]&"&apptoken=xxxxxxxxxxxxx
&_fid_113=1
&_fid_124=0
&_fid_115="&URLEncode(Now())&"
&_fid_116="&URLEncode(User())
;
"javascript:" &"$.get('" & $URL & "',function(){" &"location.reload(true);" &"});" & "void(0);"

The first part will do the "Edit" and the second forces a page refresh so you can see the new change.

The formatting for the specific fields you want to change are as such;

&_fid_(the Field ID that is to be changed)=(The value it needs to be changed to)

If you have numeric fields you can just have
=1234

Text fields or values with 'spaces' in them are best to use "URLEncode"