1. "Fabrik 4" helpers needed!

    You are invited to join other community members active in coding, maintaining and improving Fabrik. Please visit https://fabrik.help for more information!
    Dismiss Notice

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.