Qrew Legend I think that that you way overcomplicated this. The button should just be
"https://XXXXXX.quickbase.com/db/XXXXXX?a=dbpage&pageID=2"
or better yet.
Urlroot() & "db/" & AppID() & "?a=dbpage&pageID=2"
ie, like that all for the whole button!
Once you dirty the input form when you go to navigate away from the record (to send the user to the code page) it will auto save without all that code.
I think what's actually happening now as you were sitting on the input form and when you push the button it immediately adds a record and then because the form has been dirtied before it navigates the way it saves the record. So now you have a duplicate of the record.
Mark, I replaced the formula URL button's formula with
Urlroot() & "db/" & AppID() & "?a=dbpage&pageID=2"
Replacing AppID() with my actual app ID in quotes, and I'm still getting the same exact behavior. Although there's no redirect to the code page, it's just redirecting back to an empty form. But each save still creates a duplicate. Seems like a bug, but it's hard to tell because I can't debug what's actually happening.
Thanks!
------------------------------
AR
------------------------------
Qrew LegendI'm now confused. Can you post your complete current formula.
Mark,
I replaced the original formula I wrote (and posted in the original question) with the formula you posted:URLRoot() & "db/" & "MyAppID" & "?a=dbpage&pageID=2"
With MyAppID being the 9 character string of the app ID in quotes.
When I use this in my formula URL field, the same thing happens where two records are created once I press this button to create a new record.
Thanks,
Qrew LegendI'm not sure what to suggest. Some one would need to have a look while you do this. It's not possible that you fill out a blank add record form, and then click that button to navigate away and have it create two records.
The expected behaviour would be to autosave the record with that yellow pop up and then display that PageID 2 page.
