I am trying to create a URL formula that will display on a report as a button. i want this button to automatically open up the record check the box and then save it.
the reason i want this is because i am creating a project management system. and i have it set up to assign tasks to everyone in a certain department. once these tasks are assigned to the 4 or 5 people in the department, one individual can then go in and pick up the task and personally assign it to himself.
right now i have form rules set up so that whenever someone check the box "i want to pick this task up" it automatically fills in the user field "picked up by".
it would be great if they were able to pick up tasks right from a report on the homepage dashboard instead of having to open the individual record, edit it, check the box, and then save it. any help would be greatly appreciated. thank you in advance.
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=b5cpi9xccqucym2avvkqhhs53k&rid=" & URLEncode ([Record ID#])
& "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=q&qid=1")
Replace b5cpi9xccqucym2avvkqhhs53k with an application token from your own application (or create one if you do not have one already)
Replace 28 with the Field ID (FID) of the checkbox-field you are updating (=1 represents a true value for a checkbox field; conversely 0 would be unchecking a box)
Replace qid=1 where 1 is the query ID of the report you want the User to return to when the Edit Record is finished. If the user starts in a report, you want to use the qid value of that report (you can see this in the URL bar when you click on any report in QuickBase). If you want the user to return to the Table Dashboard; then change it to "?a=td"
Remember - if you expect the User to be on a table-dashboard report to activate this button; the button must exist in either the default report for the table; or the report which is used for their Role on the table-dashboard page.
URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=b4cpi8xccqucym2avvkqhhs53k&rid=" & URLEncode ([Record ID#])
& "&_fid_33=" & URLEncode(User())
& "&rdr=" & URLEncode(URLRoot() & "db/bhfdbn634")
Your last line rdr (redirect) needs to hard code the application dashboard page (substitute bhfdbn634 for your Home-Page DBID - click on the HOME icon then copy the DBID in the URL); although I am surprised you want to do this since your button-update link is going to be on the table-dashboard page. Your Users will be redirected to a different dashboard; but if they have to make more updates they will need to go back to the table-dashboard to get to the link again.
once again you have been beyond helpful for me. thanks so much!