• Hello Fabrik Community

    Fabrik is now in the hands of the development team that brought you Fabrik for Joomla 4. We have recently transitioned the Fabrik site over to a new server and are busy trying to clean it up. We have upgraded the site to Joomla 4 and are running the latest version of Fabrik 4. We have also upgraded the Xenforo forum software to the latest version. Many of the widgets you might have been used to on the forum are no longer operational, many abandoned by the developers. We hope to bring back some of the important ones as we have time.

    Exciting times to be sure.

    The Fabrik 4.0 Official release is now available. In addition, the Fabrik codebase is now available in a public repository. See the notices about these in the announcements section

    We wish to shout out a very big Thank You to all of you who have made donations. They have really helped. But we can always use more...wink..wink..

    Also a big Thank You to those of you who have been assisting others in the forum. This takes a very big burden off of us as we work on bugs, the website and the future of Fabrik.

Upsert form plugin

  • Views Views: 15,723
  • Last updated Last updated:

Navigation

         Form Article Plugin Tutorial
      Autofill form plugin
      Clone form plugin
      Comment form plugin
      Email form plugin
      EXIF form plugin
      FTP form plugin
      J2store form plugin
      Kunena form plugin
      Limit form plugin
      Logs form plugin
      Mailchimp form plugin
      Paginate form plugin
      Paypal form plugin
      PHP form plugin
      Pingdotfm form plugin
      Receipt form plugin
      Redirect form plugin
      REST form plugin
      Slack form plugin (+)
      SMS form plugin
      Twitter form plugin
      Upsert form plugin
      VBforum form plugin
      Create a Search Form
      Accordion Form Groups
  • Introduction​

    The upsert plugin allows you to insert or update a record in a database table other than the form's current table.

    Options​


    Upsert1.png


    First we want to select which list it is we will be updating:

    • Connection - the fabrik connection
    • List - the fabrik list
    Then we need to state that list's primary key

    • Primary key - the Lists primay key
    • Row value - The value for the Primary key element. Leave blank to insert a new row. Can use {Placeholders}
    • Values - press this to select how the current form's values are mapped into the update / insert. This opens the following window:
    Upsert2.png


    • Key - the upsert list's field
    • Value - the value to update/insert into the upsert list. This can be a string or a placeholder. In the example above we are inserting the raw data from the current form's street and name Elements into the upsert Lists city and name fields.
    • Default - If nothing selected for the value or a placeholder returns an empty value, then use this.
Back
Top