Button to Create Record in Edit Mode
Hello, I'm trying to create a formula URL button that creates a new record and displays it in edit mode. Is this possible? If so, what would the code be? ------------------------------ Howard F...
Forum Discussion
Howard,
You can accomplish this using API_GenAddRecordForm . I suggest that you a Formula Rich Text. I am assuming that you want to add a Child Record to the Parent that User is currently on.
You need to make a few modifications
This will give you an image that the User clicks on, creating a record related to the one they were just on and being able to edit the values from the default add form.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
You can accomplish this using API_GenAddRecordForm . I suggest that you a Formula Rich Text. I am assuming that you want to add a Child Record to the Parent that User is currently on.
// Images
var text IMG = "<img src=https://images.quickbase.com/si/48/045-lock.png>";
// URLs
var text URLGenAdd =
URLRoot() & "db/" & Dbid() &
"?a=API_GenAddRecordForm&_fid_XXX=" & URLEncode ([Record ID#])&
"&z=" & Rurl();
// User Interface
// User Interface
"<a href=" & $URLGenAdd & $IMG & "</a>"
You need to make a few modifications
- Pick an image that you want to display for this. The one above is from the Quick Base Image Library. The one I have included is of a Lock.
- Edit the URLGenAdd variable replacing the XXX with number of the Related Parent Record. You find this in the fields of the Child Table where your record is being created.
This will give you an image that the User clicks on, creating a record related to the one they were just on and being able to edit the values from the default add form.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
HI Don,
I'm trying to create a record in the same table from an existing record. The reason I want to do that is because we use the mobile interface to receive packages. Each packages gets a unique "Receiving Number". When I am done filling out the information for a received package and want to move onto the next new package, I want to click a button from the record I just finished to create a new record that displays the new "Receiving Number" (which is an auto-generated number based on record ID) but also display it in edit mode. Currently I have:
URLRoot()&"db/"&Dbid()
&"?act=API_Addrecord"
& "&disprec=1"
Right now, when I press the button, it will create a new record and show the new "Receiving Number" . I have to click edit to start editing. I'm just trying to save a step by displaying the record in edit mode.
------------------------------
Howard Fu
------------------------------
I'm trying to create a record in the same table from an existing record. The reason I want to do that is because we use the mobile interface to receive packages. Each packages gets a unique "Receiving Number". When I am done filling out the information for a received package and want to move onto the next new package, I want to click a button from the record I just finished to create a new record that displays the new "Receiving Number" (which is an auto-generated number based on record ID) but also display it in edit mode. Currently I have:
URLRoot()&"db/"&Dbid()
&"?act=API_Addrecord"
& "&disprec=1"
Right now, when I press the button, it will create a new record and show the new "Receiving Number" . I have to click edit to start editing. I'm just trying to save a step by displaying the record in edit mode.
------------------------------
Howard Fu
------------------------------