https://interactivetools.com/forum/forum-posts.php?HOW-TO-MySQL-Trigger-71609 Sat, 07 Mar 2026 10:27:51 -0800 en-us https://interactivetools.com/forum/forum-posts.php?postNum=2206164#post2206164
Glad that helped! :)

There isn't documentation on creating plugins quite yet. Our plugin system is still relatively new and we're still settling on how we want to do things. Many plugins will require advanced knowledge of CMS Builder internals (or the determination to examine the source until such knowledge is gained.)

The first parameter is known as the "hookName". If you want to see where it's called, search the source code for 'record_presave'. You'll see that it's called by doAction(). There's also a sister function to that called applyFilters(). You can find out what other options there are for hookNames by searching the CMS Builder source code for doAction( and applyFilters(.

Please note: this is not for the faint of heart! ;)
]]> Wed, 18 Aug 2010 15:24:10 -0700 forum-posts.php?postNum=2206164#post2206164 https://interactivetools.com/forum/forum-posts.php?postNum=2206140#post2206140
Thanks again this was perfect.
]]> Tue, 17 Aug 2010 22:01:54 -0700 forum-posts.php?postNum=2206140#post2206140 https://interactivetools.com/forum/forum-posts.php?postNum=2206133#post2206133
I've modified the plugin to only function on a table called 'Products' and have attached it.
]]> Tue, 17 Aug 2010 16:52:46 -0700 forum-posts.php?postNum=2206133#post2206133 https://interactivetools.com/forum/forum-posts.php?postNum=2206130#post2206130
Table: Products
Field: prodname [textfield]
Field: sku [textfield] (plugin to update this field on new rec)
Field: qty [textfield]

Thank you
richb.
]]> Tue, 17 Aug 2010 15:38:19 -0700 forum-posts.php?postNum=2206130#post2206130 https://interactivetools.com/forum/forum-posts.php?postNum=2206127#post2206127
The plugin I attached will generate "unique" sku's (see the documentation for PHP's uniqid function) for new records on any table that has a field called 'sku'. If your field is actually called 'SKU' instead of 'sku', you will need to change 'sku' to 'SKU' in the plugin.

If you have other tables with 'sku' fields which you don't want auto-generated, let me know and I'll customize the plugin to only work for your Products table.

To install the plugin, save it in your /cmsAdmin/plugins/ directory, log into CMS Builder, go to Admin -> Plugins, find it there (it's called "Custom Generate SKU") and activate it.

Please let me know if you have any questions.
]]> Tue, 17 Aug 2010 15:14:16 -0700 forum-posts.php?postNum=2206127#post2206127 https://interactivetools.com/forum/forum-posts.php?postNum=2206086#post2206086 ]]> Mon, 16 Aug 2010 22:46:16 -0700 forum-posts.php?postNum=2206086#post2206086 https://interactivetools.com/forum/forum-posts.php?postNum=2206069#post2206069
The simplest solution would be to use the existing "num" field. You could add some silly-huge number to this to make your SKUs all look uniform.

I think that using a trigger might not work because of how CMS builder updates records right after inserting them. I'm not entirely sure if this would work or not, but the good news is that it's super easy to do with a tiny custom plugin (see attached.)

I hope this helps! Please let me know if you have any questions.
]]> Mon, 16 Aug 2010 14:41:42 -0700 forum-posts.php?postNum=2206069#post2206069 https://interactivetools.com/forum/forum-posts.php?postNum=2206066#post2206066 ]]> Mon, 16 Aug 2010 13:22:27 -0700 forum-posts.php?postNum=2206066#post2206066