ContributionsMost RecentMost LikesSolutionsRe: Key field questionI think this can be done using a 2 step process 1- Create a random numberhttps://community.quickbase.com/quickbase/topics/is-there-a-way-i-can-generate-a-random-number-for-m... and populate the key field with the random number using a form rule 2 - Create an action or automation that changesthe key field to the value of record id # + 1000any time arecord is added If you choose to use an action you would need to create a report link that connects the record to itself (I do this all the time). With automations you can createtrigger when a record is addedfor the record to update itself. Good Luck :) let me know if you need any more help on htis Re: How to change a decimal to whole numberJust use the Round() function on the resultRe: Is it possible to create a ""Save and Keep Working"" button from a formula URL field?Could you please let me know how you get it back to the same spot? I am very much in need of that behaviorRe: How do I make changes save and return to where record was opened fromWould it be possible to somehow grab the native redirect URL that the save button uses and append it to the url butonRe: How do I make changes save and return to where record was opened fromNo they usualy open it directly in edit mode but they can open the record from multipule places. So for example if they opened it from a member with an embedded report they would like to return to the member they came from, if they opened from a report on the home page they would like to return to the home page etc. This is the default behaivor of the save button but haveing a hard time figuring out how to replicate it.How do I make changes save and return to where record was opened fromI have a button button that sets the record status to complete and then returns the user to his home page. The code is URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&apptoken=dxegd2ebb2dznd3pu7vi9wf2isr" & "&_fid_16=COMPLETED" & "&_fid_13= " & Today() & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid()) However users are complaining that they want to be returned to where they came from. Also I need to do a general save on the record to capture chnges that the user might have amde to to other fields. Is there a way to make the changes and then trigger the native save.Re: I would like to create a url button that redirects to the original location the record was opened fromAs perhttp://www.quickbase.com/developer/articles/using-zrurl-and-rdr-formula-url-fields"&z=" & Rurl() does not work fora=API_EditRecord. Also I may be mistaken but it seems that even if it did work itwouldbring me backto the same record I wason when pressing the button. In my case I want it to return me to the previous page, the one I wason before opening the record -as if I pressed save and closeRe: I would like to create a url button that redirects to the original location the record was opened fromWhat would I set the nextURL to be. Users can access the record from multiple locations when they hit the button I want some fields changed, the record closed and the user returned to location of originI would like to create a url button that redirects to the original location the record was opened fromI would like to create a url button that saves field values and then redirects to the original location the record was opened from, This is the code currently on the Button it redirects to the homepage. I want to redirect to the origin where the record was opened from URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&apptoken=##########" & "&_fid_16=COMPLETED" & "&_fid_13= " & Today() & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid())Re: Can jquery tabs return back to same tab once I update the form?Hi I am facing the same issue I have tabs but need a waymodify the code so it returns us to the current tab. I don't see anything in Dan's profile that would allow me to contact him. If Dan or anyone else can help me would appreciate it. My code is var markup = ""; markup += "<ul>"; $("#formContents div.sectionDiv").each(function(index){ markup += "<li><a href='#tab_" + (index+1) + "'>" + $("span.sectionTitle",this).text() + "</a></li>"; }); markup += "</ul>"; $("#formContents").prepend(markup); $("#formContents div.sectionDiv").each(function(index){ $(this).attr("id","tab_" + (index+1)); $("div:lt(2)",this).hide(); }); $("#formContents").tabs();