1. Fabrik 3.7 is now available. This version contains critical security updates, please update as soon as possible. Please remember to backup your site before updating, we also recommend testing your updates on development sites if possible.
  2. We had to restore the site around midday (CST) on Wed 7/26 from a backup approximately 8 hours old. So a few posts in the forums were lost. You may want to check to see if you need to re-post anything.
  3. The release of Fabrik for J! 3.8 is not yet ready. Do not update your sites to J! 3.8 until this notice is removed.

Upsert form plugin

May 2, 2015
Upsert form plugin

  • Introduction(top)

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



    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:

    • 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.
raimis, samani, CEDTV and 1 other person like this.