Discussions

 View Only
  • 1.  How do i create a checkbox to acknowledge payment acceptance?

    Posted 07-17-2017 17:32
    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


  • 2.  RE: How do i create a checkbox to acknowledge payment acceptance?

    Posted 07-18-2017 04:13
    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.


  • 3.  RE: How do i create a checkbox to acknowledge payment acceptance?

    Posted 07-27-2017 20:17
    i am the admin


  • 4.  RE: How do i create a checkbox to acknowledge payment acceptance?

    Posted 07-18-2017 10:57
    Ryan,
    Are you looking for a checkbox or a URL formula button button to perform some edits to the record?


  • 5.  RE: How do i create a checkbox to acknowledge payment acceptance?

    Posted 07-27-2017 20:16
    both


  • 6.  RE: How do i create a checkbox to acknowledge payment acceptance?

    Posted 07-27-2017 20:36
    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