ContributionsMost RecentMost LikesSolutionsRe: URL RedirectThank you Mark! Always with the timely solution. ------------------------------ John Ogle ------------------------------ Re: URL RedirectIf I want the Formula - URL to create a record in another table in another app, fill a few fields and return you to where you started. Are the attempts below even a good place to start? I've tried GenAddRecordForm and AddRecord with no success. Please help //v3.0 //"Blocked" var text URL=URLRoot() & "db/nn77nnnnn?a=API_AddRecord&_fid_36=" & URLEncode([Record ID#]) & "&_fid_6="&Now() & "&_fid_7="&Now() & "&_fid_15=11" & "&_fid_72="& [Project - Customer] & "&_fid_53=51"; "&rdr="&URLEncode(URLRoot()) //v2.0 //fails to add record var text URLOne= URLRoot() & "db/nn77nnnnn?a=API_GenAddRecordForm&_fid_36=" & URLEncode ([Record ID#]) & "&_fid_6="&Now() & "&_fid_7="&Now() & "&_fid_15=11" & "&_fid_72=" & [Project - Customer] & "&_fid_53=51" & "&dfid=10 &z="& Rurl(); var text URLTwo= URLRoot() &"db/"&Dbid()&"?a=dr&dfid=2&rid="&[RecordID#];$URLOne&"&rdr="&URLEncode($URLTwo) ------------------------------ John Ogle ------------------------------ Re: URL To Return To ReportThat did! As usual, reading more carefully solved the problem. The report I was pointing to was private/unlisted. My first code modification produced the error message, record does not exist. I cleaned up the code to what it looks like now and got was I thought was the same error. It was not. The new error message was the report does not exist. Thanks again Mark ------------------------------ J. T. Ogle ------------------------------ Re: URL To Return To ReportI believe I understand what you're asking, forgive me if this does not help. This is the part that works, var text URLOne= URLRoot() & "db/" & Dbid() & "?act=API_EditRecord & rid=" & [Record ID#] & "&apptoken=abcd" & "&_fid_98=" & ToNumber([Current Inventory]+[delta value]) & "&_fid_112=" & "&_fid_110=" & URLEncode([Inventory Delta]=0); var text URLTwo= URLRoot() & "db/" & Dbid() & "?a=er&dfid=2&rid=" & [Record ID#]; $URLOne & "&rdr=" & URLEncode($URLTwo) It stops working when I attempt to point it to a report when done by making it look like this, var text URLOne= URLRoot() & "db/" & Dbid() & "?act=API_EditRecord & rid=" & [Record ID#] & "&apptoken=abcd" & "&_fid_98=" & ToNumber([Current Inventory]+[delta value]) & "&_fid_112=" & "&_fid_110=" & URLEncode([Inventory Delta]=0); var text URLTwo= URLRoot() & "db/" & Dbid() & "?a=q&qid=3"; $URLOne & "&rdr=" & URLEncode($URLTwo) ------------------------------ J. T. Ogle ------------------------------ URL To Return To ReportI've managed to cobble together this URL to return to the relevant record after changing some field values. In a separate context, I want to execute the same actions but return to a report. The solution I believed should work does not, see below: var text URLOne= URLRoot() & "db/" & Dbid() & "?act=API_EditRecord & rid=" & [Record ID#] & "&apptoken=abcd" & "&_fid_98=" & ToNumber([Current Inventory]+[delta value]) & "&_fid_112=" & "&_fid_110=" & URLEncode([Inventory Delta]=0); var text URLTwo= URLRoot() & "db/" & Dbid() & "?a=er&dfid=2&rid=" & [Record ID#]; $URLOne & "&rdr=" & URLEncode($URLTwo) //I replaced the above line with the following and did not get the result I was looking for //URLRoot() & "db/" & Dbid() & "?a=q&qid=3"; $URLOne & "&rdr=" & URLEncode($URLTwo) ------------------------------ -JT ------------------------------ Kanbans Across Tables & AppsI am attempting to utilize a kanban report to assign employees to work crews in one case and to assign equipment to work crews in another. The first app has two relevant tables, Employees (child) & Crews (parent). I would like to be able to move Employee records from one crew to another but can't seem to get a Kamban friendly multiple choice field which also changes the related crew accordingly. The second case seems similar, where the child is an equipment table in a separate app and the parent is the crew table from the above example. Any suggestions for solving this? ------------------------------ J. T. Ogle ------------------------------ Re: Formula URL Form ID Shows Wrong FormThank you, I'll give it a try. Guess I'll know tomorrow if it works ------------------------------ J. T. Ogle ------------------------------ Formula URL Form ID Shows Wrong FormHi, I'm using the following formula to operate a button. Pressing the button opens a specific form, form 11. URLRoot() & "db/" & [_DBID_TABLEINQUESTION] & "?a=er&dfid=1000011&rid=" & URLEncode ([Record ID#])& "&z=" & Rurl() Every morning I test the button. Although the URL displayed in my browser address bar shows "...dfid=1000011", I am looking at form 2, the default form. If I go to settings/forms and preview each form, the button works properly again until the next day. Please help ------------------------------ J.T. Ogle ------------------------------