Discussions

 View Only
  • 1.  Create copy record then redirect

    Posted 05-04-2023 01:36

    I'd like to add the Formula URL field to the table so that each record has the "copy" button next to that row. When that button is clicked the Formula URL will first create a copy of that original record, then navigate to the form to edit the newly created record.

    How would I do this?




    ------------------------------
    James van der Walt
    ------------------------------


  • 2.  RE: Create copy record then redirect

    Posted 05-04-2023 12:14

    There are different technical alternatives, but under the category of pretty stupid simple (my favourite) try this as a formula URL field.

    URLRoot() & "db/" & dbid() & "?a=GenCopyRecord&rid=" & [Record ID#] 

    That will land you on an ADD Record form with the data entry fields carried forward.  Also note that there is a setting on each field as to whether or not a particular field should be copied when using this technique. 



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Create copy record then redirect

    Posted 05-04-2023 23:52

    Perfect! That's what I needed! You're a star, thank you

     

    Sent from Mail for Windows