On Click Counter
Two years ago, @lin posted requesting help creating an on click counter. Mark and Dan shared solutions and the post has been closed to commenting so I am posting a new post, post post. When I use the ...
Forum Discussion
My increment field is fid 686. I did change it and it does not function.
Here is the code revised for my fields:
var number NewValue = [test counter field] +1;
var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=xxxxxxxxxxxxxxxxxxxxxxx&rid=" & [Record ID#]
& "&_fid_686=" & ToText($NewValue);
When I delete the JavaScript, there is an error stating: column: 0 > Expecting text
Here is the code revised for my fields:
var number NewValue = [test counter field] +1;
var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=xxxxxxxxxxxxxxxxxxxxxxx&rid=" & [Record ID#]
& "&_fid_686=" & ToText($NewValue);
When I delete the JavaScript, there is an error stating: column: 0 > Expecting text
- Add
$URL
As the last line so it runs the URL
When our run it,, it will either come back with a success or error message. - Did that and got an error about the app token so I turned off require apptoken and got this message:
When I went back to the record it did increment.
Looks like it was an issue with the apptoken. I was trying to use one that was created as not ok to copy. Added a new token and all is good with the world.
Thanks for the feedback and direction Mark! - OK, so you are all good now. You see that by running the URL raw you get to see the successor error message.
When you have that javascript refresh code enabled, your button could have started WWIII with nuclear war and the screen would just quietly refresh with no indication of a problem. So you run the raw button until it works and then enable the refresh.
