...
Our form has 2 fields, title and area, which will be copied to fields name and name2 in the database
We have handlers for 2 events in ConfiForms - "oncreated" and "onmodified". We create and update the record in the database based on the event occurred.
We can easily add another IFTTT handler to delete the corresponding record in the database on "ondeleted" event, if necessary
ConfiForms Form Definition |
---|
|
titleTitletext areaAreatext title.length:>100Title is too long, shall be less than 100 symbolsValidation rule area.length:>50Area is too long, shall be less than 50 symbolsValidation rule Copy ConfiForms Data to DB7422036e-9a6f-4455-92d9-7140131fb9daonCreatedINSERT INTO cf_copy_2_db_demo(name, name2, confi_id_ref) VALUES('[entry.title]', '[entry.area]', '[entry.id]')id:[entry.id]
Copy ConfiForms Data to DB7422036e-9a6f-4455-92d9-7140131fb9daonModifiedUPDATE cf_copy_2_db_demo SET name = '[entry.title]', name2 = '[entry.area]' WHERE confi_id_ref = '[entry.id]'id:[entry.id]
Copy ConfiForms Data to DB7422036e-9a6f-4455-92d9-7140131fb9daonDeletedDELETE FROM cf_copy_2_db_demo WHERE confi_id_ref = '[entry.id]'id:[entry.id]
|
ConfiForms (FormView) Registrations Control |
---|
|
|
...