Supple Forms – A WordPress CMS Plugin

supple_formsI am pleased to announce the release of Supple Forms, a CMS plugin for WordPress.  If you’ve been looking for content management on WordPress, Supple Forms may be part of your solution.  It is easy, flexible, powerful, and lightweight. Supple Forms offers two significant functions for your blog: 1) building custom write panels for the WordPress Write Post page; and 2) easy inserting of form data and HTML snippets into your posts.

Supple Forms may help you if you want to:

  • add custom data to posts through easy-to-use meta boxes
  • you want to store data in a Custom Table, giving you coders flexibility for robust queries on your data
  • easily format your custom data with HTML snippets and insert it into Posts using a simple shortcode – ex. [supple snip='address_box']
  • insert any kind of HTML or Javascript snippets into your posts using simple shortcodes

Quick Start Video Guide

Update: I have created a 2 part video guide (15 minutes total) to quickly get you started with the basics of Supple Forms. Check out both videos here.

Download

Download Supple Forms on WordPress.org:  Supple Forms

screenshot-21

Features

  • Custom write panel or Meta box that displays on the Write Post form
  • Fields utilizing textboxes, dropdown lists, radio buttons, checkboxes, textareas, and a jQuery DatePicker
  • Allows fields with multiple values
  • Options for placement of the custom meta box (after title, after the wysiwyg editor, at the bottom)
  • Choose between storing data in a Custom Table or as WordPress’ own Custom Fields….note that multiple value fields will be stored as WP Custom Fields
  • Insert field values into posts with a flexible shortcode api
  • Create reuseable HTML (really HTML, Javascript or any valid XHTML) snippets – we call them snips in Supple Forms – that can utilize field values
  • Easily insert snips into posts with a shortcode
  • Specify CSS code to be inserted with your HTML snips

On the Drawing Board (A Road Map for Supple Forms)

We’re not stopping here! Down the road, here are some features that I’d like to get into the plugin:

  • Yeah…need to add delete fields ability
  • Create separate Write Pages that utilize different Supple Form sets
  • Allow placing forms within a post that could be editable by your visitors – the data generated by these could be Post specific or not
  • Add optional ajax Auto-fill or Auto-complete to Textboxes
  • Allow execution of PHP code within HTML snips
  • Add options for automatically adding HTML snips to top or bottom of Posts
  • Let me know what your wishlist includes…just add a comment below!
  • Add sidebar widgets for snips
  • Request:  add ability to output data as a sortable table in posts
  • Option to make fields required
  • Request: add ability to use a field’s values as tags
  • Request: query capabilitis…search does not search Custom Fields
  • Request: add a WYSIWYG editor option for forms
  • Allow comma’s in the selection lists for fields
  • Template tags

Usage

Using Supple Forms is extremely simple:

  1. After uploading and activating the Supple Forms plugin (see the Installation page), you’re ready to begin building your form
  2. In the Supple Forms menu, click Form Settings to set form level defaults
  3. Enter a Form Title. This will be the title that shows in the form box on the Write Post/Page page
  4. Choose other form-level defaults such as whether to store data in a Custom Table or in WP Custom Fields
  5. In the Supple Forms menu, click Add/Edit Fields to add fields to your custom form.
  6. Add new fields or Edit existing ones by making the proper selection in the Select field dropdown box
  7. If you chose Custom Table as the storage option on the Form Settings page, a Generate Table button will be available on the Add/Edit Fields screen. You will a warning to Generate the table after a field is created or edited until you run the Generate Table option. However, do not Generate Table until you are done adding/editing your fields. It won’t break anything, but it is a best practice to wait. You can generate the table as often as you want, but waiting until you are done editing fields prevents creating extraneous fields in your database. Supple Forms will not Delete table fields or custom tables. We don’t want to risk you losing any data by stray clicks. So if you end up creating fields that later get changed, you will can delete them through phpMyAdmin or another database management tool.
  8. After you’ve added your fields and generated the Your fields will now be available on the Write Post/Page pages
  9. Saving a post/page or publishing a post/page saves your custom field data as well. Custom field data is not saved in the revisions. It is only linked to the actual Post ID record (not the revision IDs)
  10. To create HTML snips for inserting into posts/pages, in the Supple Forms menu, click the HTML Snips Editor
  11. In the HTML Snips Editor, you can create pre-formatted HTML snippets that include your data. Simply place your field names in brackets and insert them in your snips. For example: <div class=’neatbox’>I live in [city]</div>
  12. The name you give your HTML snip will be used in the shortcode that you insert into your posts/pages. For example, a snip named address_box would be inserted with this shortcode: [supple snip='address_box']
  13. Finally, place shortcodes like [supple snip='my_snip'] in your posts or pages.
  14. For the programmer in you, you have direct access to your custom table from within your template code. Use the WordPress database object ($wpdb) to perform SQL commands and queries on your data. Your table name (if using Custom Table) is shown in red on the Form Settings page. Supple Forms utilizes your defined WordPress table prefix ($wpdb->prefix) + the prefix “supple_”. So a table that you named destinations would normally be in the database as: wp_supple_destinations (unless you changed your $wpdb->prefix to something other than the default (wp_))

Changelog:

  • 0.1.62 (3/8/2009) when displaying values, now replaces new lines with br tags.  This problem was evident from the multi-line textboxes where new lines didn’t render new lines.

The WordPress CMS Revolution Continues

WordPress is such a great platform with such a strong community, that it is only natural that people will want to push it to the limits of creativity. I hope that Supple Forms will be yet another brick in paving the WordPress CMS road. I also hope that you will help me make Supple Forms better, stronger, faster…maybe one day, even, Bionic Forms.

Donations

While your using Supple Forms would be a reward in-and-of itself to me, I would certainly appreciate any donation that you cared to make if this has been helpful to you.  Of course, a little write up or review on your blog would be appreciated as well.


Thanks again for checking out Supple Forms, and Happy Blogging!
Byron

Popularity: 65%

Tags: , ,
Filed under: Blogging, WordPress

Comments

  1. Amir Helzer Says:

    This plugin looks powerful. How do you balance between features for power users and making it simple for basic users?

    My preference is to have a minimal setup that works without understanding anything, but can then later be customized to any degree.

    Can you make ‘beginner’ usage instructions which would be comprised of no more than 3 simple steps?

  2. Byron Bennett Says:

    Hi Amir,

    Based on your preference for minimal setup without having to know the details, I think Supple Forms would be a good fit. It should be very easy to get going and start displaying your data. But it also give a power user a lot of flexibility as well.

    I will indeed be putting together both a quick start guide and power user reference.

    Hopefully over the next few days, it’ll be available.

    Cheers,
    Byron

  3. Amir Helzer Says:

    Hi Byron,

    We’re putting together a mega-plugin for turning WP into a multilingual CMS:
    http://sitepress.org

    If you’re familiar with Drupal, you’ll see that our implementation and the Drupal i18n module share the same architecture.

    It includes a plugin packager that can auto-install plugins with themes. The idea is to bundle a few powerful plugins and include with themes so that theme designers can implement CMS features without having to invent the wheel time and time again.

    We don’t have a contact form feature right now. Would you be interested in including your plugin in this package?

    I must admit that I haven’t tried your plugin yet but from this review it sounds just right.

  4. baron Says:

    hi. Thanks for plugin

    perfect.

    Regards

  5. Kathy Says:

    This is just what I was looking for, REALLY! Thank you :)
    What is an HTML Snips Editor?
    My wish list:
    1. Ability to delete fields. I played around with it as a test, now I can’t get rid of my testing fields.
    2. Ability to make fields required.

  6. Marc Says:

    Bryon,

    Thanks for the plugin, havent started using yet. Is it possible to utilise so that I can extract values from the wordpress database and then output in a sortable table format that will be included on a post or page. Think the wp-table plugin did that however no longer works with the latest wp version. Could I achieve similar with your plugin.

    Thanks

    Marc

  7. Byron Bennett Says:

    Hi Baron.
    Thanks! Glad you’re liking it.

    Kathy
    Yes, that is the very next thing I need to do…delete fields. Should have been in there before…sorry.

    As for the HTML Snips Editor, that lets you create any HTML that you want and have it inserted into your Posts using the shortcode: [supple snip='mySnipName']

    You can show field values in snips by including a code like: [myfieldname]

    They make it really easy to format your values and put them in your posts.

    Thanks for trying it out. Hope to have your feature request done soon!

    Marc
    Welcome! As it is, Supple Forms doesn’t do what you’re looking for by itself. If you’re a coder, you can pretty easily do it in your templates, but SF doesn’t do it out of the box. I will put your request on the wish list…Good suggestion

    Thanks to everyone who is breaking in Supple Forms. Today is day 2 of it being in the wild, so I wouldn’t be surprised to find a few things that don’t work quite right.

    Cheers,
    Byron

  8. Supple Forms - Quick Start Guide » WhyPad Says:

    [...] is a quick start guide to get you up and running with Supple Forms as fast as humanly possible. Supple Forms is a CMS plugin for WordPress that lets you add custom data to posts and pages. It is both powerful [...]

  9. Kathy Says:

    Worked fine on a test blog. Now when I install on a new WP site, I’m getting this error message.

    Parse error: syntax error, unexpected T_STRING, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or ‘}’ in /home/ragin8/public_html/songdatabase/wp-content/plugins/supple-forms/supple-admin.php on line 63

  10. Byron Bennett Says:

    Hi Kathy,

    That sounds like the file might not have gotten copied in completely. Could you delete the Supple Forms plugin folder and upload the whole folder again? That might fix it. Let me know if it doesn’t

    Thanks,
    Byron

  11. Kathy Says:

    No, didn’t work. I deleted it and then reinstalled it, twice. Once from your download link, and once from the WP download link. :(

  12. Kathy Says:

    I don’t understand it. It’s still working on my test site, but not in the new site.

  13. Byron Bennett Says:

    Kathy,
    I hear you…I’m looking into it. It might have to do with the fix I put in for Deleting Fields. Does your test site have the Delete button on the fields? (Just checking to see if it’s the same version of Supple Forms).

    Hopefully I’ll get it figured out shortly.

    Byron

  14. Byron Bennett Says:

    Kathy,

    Another theory…I think it might have to do with the ‘public’ keyword that is used in the function on line 63. I believe there might be a difference between the ways PHP 4 and PHP5 deal with it (maybe even different versions of PHP 5).

    I’m going to remove that keyword and see if that fixes it for you. Give it 20 minutes or so for WordPress to cycle through to version 0.1.3.

    Let me know if we don’t get it with this one.

    Byron

  15. Kathy Says:

    ERROR ALL GONE NOW !!! :)
    Thank you.

  16. Byron Bennett Says:

    0.1.3 is out on WordPress. It might take a bit for it to show up in the automatic upgrade, but you can download automatically. Hopefully that fixes it.

    BB

  17. Byron Bennett Says:

    Ah….typing at the same time, we were ;-) Glad it worked! Thanks for the heads up.

    Byron

  18. Aris Says:

    Hi Byron,

    This is a phenomenal piece of work! Really excellent execution and concept. I can’t wait until you get a chance to work on the widget as well.

    One thing I’ve noticed that seems to be a bit of an issue – when I go to update an article it erases the custom field data. It seems like there must something in the wordpress engine that could assist you here (easier said than done). Keep up the great work!

    Aris

  19. Byron Bennett Says:

    Hi Aris,
    Thanks! Glad you like it.

    I see what you mean about the Custom Fields disappearing. Looks like the Multi-Value items are working fine, but when you’ve got Custom Fields turned on…not saving the data.

    Looks like there’s going to be a version 0.1.4 after all ;-)

    Thanks!
    Byron

  20. Byron Bennett Says:

    Aris,

    0.1.4 is out on WordPress now. That should fix the Custom Fields issue. Let me know if you see anything else. Just hope I didn’t break anything with fix!

    Cheers!
    Byron

  21. Aris Says:

    Great I’ll let you know as soon as the update comes in.

    Thanks much,
    Aris

  22. Episode 42 - How Could WordPress Die? : WordPress Tavern Says:

    [...] – Supple forms – Supple Forms is a CMS plugin for WordPress that lets you easily add a custom write panel or meta [...]

  23. Avaz Ibragimov Says:

    Hi,

    I can’t make it work with Cyrillic alphabet :/

    Here’s the error:

    Invalid field name: Ð?оделÑ?. Use only letters, numbers, and underscore (_).

  24. Episode 42 - How Could WordPress Die? - Word Press Magazine Says:

    [...] – Supple forms – Supple Forms is a CMS plugin for WordPress that lets you easily add a custom write panel or meta [...]

  25. Aris Says:

    Excellent update Byron! It works perfectly. Thanks for the top notch code.

  26. Byron Bennett Says:

    Aris
    Cool! Glad to hear it’s working. I appreciate the comments!

    Hi Avaz,
    I’m sorry, but I’m not really sure how to deal with any character sets other than standard English. The problem you’re running into is that there is a Regular Expression in supple-admin.php that checks to the field name you give it to make sure that it is A-Z, a-z, 0-9, or underscore. I thought these would be safe for field names in the MySQL table. If MySQL can handle field names that use the characters your trying to use, you should probably be able to disable that RegEx call by returning TRUE in the checkName function.

    To do that, open file: supple-admin.php
    Find function: function checkName($text)
    Make the first line of code in the function (after the opening ‘{‘ ): return true;

    That should shortcut the check and let you make the field names anything you like. Just make sure you keep it something that is acceptable as a field name in MySQL. I’d prefer not to take the check out of the standard code because it should steer most people in the right direction.

    Hope that helps,
    Byron

  27. Trisha Says:

    Running WP 2.71., and when I try to activate SF, I am getting the following error message:

    Supple Forms not installed properly.
    Tables not installed properly: wp_sppl_fields, wp_sppl_snips, wp_sppl_forms, wp_sppl_lookup

    I’m logged in as the Admin user – can you tell me how to fix this error?

  28. Byron Bennett Says:

    Trisha,

    This sounds like a problem that I’ve been struggling with on my PhotoSmash plugin as well. You could build those tables manually, but if you ever wanted to use the Custom Table option in Supple Forms, it probably wouldn’t be able to build your custom table. You could probably use the WP Custom Fields option, without a problem, but I’m having trouble figuring out why these plugins won’t build tables on some WordPress systems.

    Is your blog running on a Linux server or a Windows server? Are you running PHP 4 or 5? What version of MySQL are you running? 4 or 5?

    I may be barking up the wrong tree with those questions, but I’m trying to see if there is a pattern.

    So, here are the things you can try:
    1) deactivate the plugin and reactivate it….just to see if something went temporarily haywire
    2) go into your database manager, probably phpMyAdmin, and create the tables manually using the sql statements below…you should be able to post them into the SQL section.

    I’ll get you the SQL shortly…debugging it now.

  29. Byron Bennett Says:

    Trisha,

    Here’s the SQL if you want to try creating the Supple Forms tables manually. Again, the problem you’re having probably precludes you from using the Custom Table option, but you should be able to use the WP Custom Fields option just fine. Snips and everything else ought to work as well. Hopefully I figure out what the problem is and have a fix soon. If anybody else knows what I should try, I’d be much obliged if you’d give me a clue ;-)

    The SQL:

    CREATE TABLE wp_sppl_fields (
    field_id INT(11) NOT NULL AUTO_INCREMENT,
    form_id INT(4) NOT NULL default ‘0′,
    field_name VARCHAR(50) ,
    label VARCHAR(255) ,
    type INT(4) ,
    numeric_field TINYINT(1) NOT NULL default ‘0′,
    multi_val TINYINT(1) NOT NULL,
    default_val varchar(255),
    html_filter TINYINT(1),
    seq INT(4) ,
    status TINYINT(1) NOT NULL ,
    PRIMARY KEY (field_id)
    ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    CREATE TABLE wp_sppl_lookup (
    id INT(11) NOT NULL AUTO_INCREMENT,
    field_id INT(4) ,
    value VARCHAR(255) ,
    label VARCHAR(255) ,
    seq INT(4) ,
    PRIMARY KEY (id)
    ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    CREATE TABLE wp_sppl_snips (
    snip_id INT(11) NOT NULL AUTO_INCREMENT,
    snip_name VARCHAR(30) ,
    auto_add TINYINT NOT NULL default ‘0′,
    snip TEXT ,
    css TEXT ,
    lists VARCHAR(255) ,
    PRIMARY KEY (snip_id)
    ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    CREATE TABLE wp_sppl_forms (
    form_id INT(4) NOT NULL AUTO_INCREMENT,
    form_title VARCHAR(250) ,
    placement TINYINT(1) NOT NULL default ‘0′ ,
    use_custom_fields TINYINT(1) NOT NULL default ‘1′,
    custom_tablename VARCHAR(30) ,
    post_related TINYINT(1) NOT NULL default ‘1′,
    write_page INT(4) NOT NULL default ‘1′,
    hide_wp_customfields TINYINT(1) NOT NULL default ‘1′,
    seq INT(4) ,
    status TINYINT(1) NOT NULL default ‘1′,
    PRIMARY KEY (form_id)
    ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

  30. Byron Bennett Says:

    BTW, that SQL should work on MySQL 5, not sure about 4…let me know if it doesn’t go through.
    BB

  31. Trisha Says:

    Okay I tried that, and got this error (below) – likely because I have MySQL 4.0 – I can upgrade to 5.0 if necessary but I’d prefer to not have to go that route if I don’t have to.

    Error
    SQL query:

    CREATE TABLE wp_sppl_fields(
    field_id INT( 11 ) NOT NULL AUTO_INCREMENT ,
    form_id INT( 4 ) NOT NULL default ‘0′, field_name VARCHAR(50) , label VARCHAR(255) , type INT(4) , numeric_field TINYINT(1) NOT NULL default ‘0 & #8242;,
    multi_val TINYINT( 1 ) NOT NULL ,
    default_val varchar( 255 ) ,
    html_filter TINYINT( 1 ) ,
    seq INT( 4 ) ,
    STATUS TINYINT( 1 ) NOT NULL ,
    PRIMARY KEY ( field_id )
    ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci

    MySQL said: Documentation
    #1064 – You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ‘0′,
    multi_val TINYINT(1) NOT NULL,
    default_val varchar(

  32. Steve Says:

    Hello,

    I’m really pleased that I stumbled across Supple Forms, it’s a great plugin and has helped me a lot in building a storefront site using WP. I have run into a problem though: After installing Supple Forms I can no longer use the “Add Image” button on the main Post edit box. Instead of the normal image dialog display, the dialog shows:

    Are you sure you want to do this?

    Please try again.

    I’m using WP 2.7

    Cheers,
    Steve.

  33. Byron Bennett Says:

    Trisha,

    I have just uploaded a new version to WordPress. You should see 0.1.5 out there some time soon. I have changed the database table creation code to hopefully be compatible with MySQL 4. Let me know how it goes. Fingers crossed that it’ll fix your problem.

    Byron

  34. Byron Bennett Says:

    Steve,
    Glad to hear the SF is helpful….at least your error is one that I can actually reproduce – makes debugging a little easier (knock on wood!). I’m on it!

    Thanks,
    Byron

  35. Byron Bennett Says:

    Steve,
    I think I’ve got the image upload problem fixed in version 0.1.6. Give that a try when it comes out. Good catch…Thanks!
    Byron

  36. Trisha Says:

    Fabulous Byron! Worked like a charm! Took me just a little bit to work thru the instructions and figure out what to do, but I’ve got it working great – thanks for your help and for this great plugin!

  37. Byron Bennett Says:

    Thanks Trisha,
    I’m glad that the fix worked for you. With the problems I’ve been having on my PhotoSmash plugin, it’s good to have something working right for a change :)

    Byron

  38. Kathy Says:

    I have version 0.1.4 If I download 0.1.6, will I have to reenter my Fields?
    I’m happy with it now, so I hesitate to mess with it.

  39. Byron Bennett Says:

    Kathy,
    I 100% hear you, but it should not affect any data that you have entered already. I have upgraded my test blog with no harmful effect on existing data.

    All the same, if you are concerned, it really would be good to make a copy of your database just in case. You will definitely want to keep up with the most current versions going forward. 0.1.6 fixes a problem with uploading images to your posts.

    If you have the wp-backup plugin ( http://wordpress.org/extend/plugins/wp-db-backup/ ), be sure to select your Supple Forms tables as additional tables to back up.

    I don’t want to say, fear not, but it really should be ok to upgrade.

    Byron

  40. Boots Says:

    Great Plugin Byron….

    Question: How do I format the date field output?

    Thanks for your hardwork.

    Boots

  41. Boots Says:

    Hmm… I’m wondering if there is something wrong. I used the data viewer and saw 52 rows for 4 posts. It is as though it is keeping prior states of data.

    I would have expected one row of supple data for each post.

    Do I have a problem? If so, how do I fix this? I was using 1.4 and upgraded 1.6 without editing any posts.

    Thanks

    Boots

  42. Byron Bennett Says:

    Hi Boots,

    Thanks for bringing that back up. I’d seen that problem before, but then it “went away”, but not really. The duplication only happened when you saved a post without changing the Supple Forms data for that post. It thought because nothing was updated that nothing existed. I’ve fixed that in version 0.1.61. If I could name versions, that one would be named Boots ;-) cause that’s all that got fixed. If you resave a post, Supple Forms will clean up the duplicates for that post. It doesn’t clean them all up at once, unfortunately, but hopefully this won’t be too much of pain.

    Now somebody is asking about formatting dates….hmmm.

    Cheers!
    Byron

  43. Byron Bennett Says:

    Boots,

    I didn’t realize that was you asking about the dates :) I’m looking into how we can make that easy. Will keep you posted.

    BB

  44. Boots Says:

    Byron: Thanks for 1.6.1 aka Boots. :) I’ll report back how it cleans up the db file.

  45. Boots Says:

    Byron:

    1.6.1 still writes a new event line if I’m updating info in the message box while not updating data in supple form.

    Can you tell me what tells supple which event record it displays for a given post? The most recent?

    `supple-write.php start line 150

    $reccnt = $wpdb->get_var(“SELECT COUNT(post_id) as cnt FROM ”
    . ” $tablename WHERE post_id = “.$data['post_id']);

    if( $reccnt 1){
    //delete existing records based on POST ID…must change when go to
    //forms that don’t rely on POST ID
    $wpdb->query(“DELETE FROM $tablename WHERE post_id = $post_id”);
    $wpdb->insert($tablename, $data);
    $this->message = “Supple data inserted.”;
    } else {
    $this->message = “Supple data updated”;
    }`

    I can’t see what’ not working here.

    Boots

  46. Narcie Says:

    First of all, this is REALLY AWESOME plug in, Love it!

    couple of questions:

    1. If I am updating a record, it is actually incerting a new record, as Boot said above

    2. In date picker, can it just show date, not year and time? In my site, I use it for “application deadline”, it appears year, date and time, while all I need is only date. take a look at: http://narcie.org/index.php/rice-university/

  47. Byron Bennett Says:

    Boots,

    Bummr….this code cleared out my duplicates fine, unless I made some change after I tested, but I don’t think I did. One thing I do need to change in that code is in the line:

    $wpdb->query(”DELETE FROM $tablename WHERE post_id = $post_id”);

    I want to change the “= $post_id” to ” = ‘.$data['post_id']” just to be consistent with the lines above, and as an injection safeguard.

    But, doesn’t the logic of that snippet you posted look right? (Note that the if($reccnt) statement lost the > and < due to html parsing).

    To your question on which record gets used by Supple Forms when there are duplicates for a post, it just grabs the first record. They should all be the same because the UPDATE statement ends up updating all records that have the same post ID. The trouble is that you don’t want to be updating 50 records everytime you update a post.

    Please let me know if you figure something out…I’ll keep trying.

    Byron

  48. Boots Says:

    Byron – I’m a knuclehead… I had to cycle each post to clean up all the redundant supple records. 1.61 Boots is looking much better :)

    On another note, I was having difficult formatting the message with embedded snips to provide where needed. I even made a snip to line_space Sometimes WP is just finicky… may not be the plug-in at all. And I have a 43 total plugins so it’s hard to isolated issues.

    Your roadmap looks good. I will have some items to add to it.

    Best regards,

    Boots

  49. Byron Bennett Says:

    Boots,

    That’s really good news. It looked solid and seemed to work for me, but you never know.

    For a snip, the code should be like:

    [supple snip='line_space']

    just put it wherever you like. What I don’t know is if there is a filter that comes after the shortcode call that is wiping out your new text.

    BB

  50. Byron Bennett Says:

    Hi Narcie,
    Sorry I missed you comment when it was originally posted. To your questions:

    1) We have the duplicate entries problem fixed in version 0.1.61
    2) Boots also requested this one…I’m going to have to work on that a little bit, but I should be able to give you some formatting options

    BB

  51. Boots Says:

    To: BB

    I had a list going for a wish list and then I found a plugin that I’m hoping will insert your snips with its sniplets. Kinda convolutated, heh? Will see if Mr. Urban Giraffe can quickly resolve the issue with his today’s build.

    Here’s my real short wish list. More to come.

    1) quicktag function to view and insert available snips and snippets – huge productivity booster
    STOP THE PRESSES – Urban Giraffe has a superb plug that will do the trick: http://www.urbangiraffe.com/plugins/sniplets/ – See the love shared in my comment on John’s site.

    2) form assignment granuality: set to none, posts, pages, or both; set to specific category or categories; this will allow form to show in edit mode only for desired targets.
    at specific post/page add new/edit stage, toggle form on/off. in future version of plugin with multiple forms, offer select list to attached to post

    … just for you to ponder.

    Cheers,

    Boots (aka 0.1.6.1, aka bb)

    PS: You ABAP?

  52. Byron Bennett Says:

    Hey Boots,

    No ABAP…mostly BeBop for me…sorry, soooooo corny. You? I’m a FICO/accounting guy, moved back to IT a couple years ago (wow how time flies).

    Thanks for the mention on Urban Giraffe!!! I hope that the more people use SF, the better it can become for everyone. Also thanks for sharing your wish list….I have my own list, but knowing what is important to users will help me prioritize my work on this plugin.

    1) I read through a bit of the Sniplets documentation, and that does look powerful. I particularly envy the execution of PHP code that it allows. I’ve been pondering how to allow that within the Snips in SF, but I’m a little scared to open up that box just yet. I’ve considered the dreaded eval(), or also letting you create a .php on the fly within the Snips Editor and giving you an [include] tag, though I don’t know if that would be any more secure than eval().

    At any rate, the Snips Editor is a particular area I want to beef up. I’m not sure what you meant by the “quicktag function”. Do you mean like a previewer? Please elaborate.

    2) Yes, this is definitely a major deal, and I’ve tried to build this initial release so that it can accommodate the things you’re discussing. Here’s a little list of the things I want SF to ultimately do in the forms area:

    • Be tied to posts/pages or not
    • Allow multiple records in the Custom Table (versus multiple value fields, the whole form would create multiple records as you like, giving you a little grid that you could click to edit/delete existing records)
    • Perform the category magic you indicated
    • Toggle on/off
    • The non-post related forms would be configurable to allow anyone to post or users of a certain role
    • The non-post related forms could be used for all sorts fo things…contact forms, polls, data gathering, you name it
    • Build some triggers into the non-post related forms that would let you trigger emails or a PHP funciton

    There’s a lot to be done there. Baby steps for now.

    Thanks again for spreading the love!
    Byron

  53. MichaelH Says:

    @Byron – I’d guess reference to quicktag is request for something on the toolbar of the editor. The “more” is an example of that on both the WYSIWYG and HTML post editors.

  54. Byron Bennett Says:

    Michael,

    Oh, thanks for weighing in…That would be a great addition. Adding to the rapidly expanding list.

    Cheers,
    Byron

  55. Krystyna Says:

    I just installed the Supple Forms plug in and tested it. And it looks like everything I’m wondering about the plugin doing or not doing is in one of your posts. I’ve listed below and how they pertain to my site.

    * Be tied to posts/pages or not

    -data from form to display on one particular page,
    -only author and up level to be able to add data to the form

    * Allow multiple records in the Custom Table (versus multiple value fields, the whole form would create multiple records as you like, giving you a little grid that you could click to edit/delete existing records)

    -data to display as multiple records on the page in a spreadsheet-like format

    Ideally, because this is a racing site, I’d like for visitors going to that page to have the ability to search for specific data by horse, and the spreadsheet could refresh itself with just that horse’s data. But for now if all that’s available is the entire spreadsheet of data to display on a page, that would be fine with me. Can this be done? I don’t want this form attached to posts, just to a page.

    The fields in the custom table are
    horse, sire, dam, dam’s sire, trainer, race record 1,2,3, total earnings, graded stakes earnings, workout distance, workout time, workout date, workout location.

    So when going to the “Triple Crown Workouts” page, I’d like visitors to be able to view a running spreadsheet with data that’s only updatable by authors, editors and the site administrator. Hope this makes sense!

  56. Byron Bennett Says:

    Hi Krystyna,

    Yes, that makes perfect sense. SF is not there yet, but it’s definitely on the road map….unfortunately, not much help to you right now.

    The solution for this would be to allow multiple records for post/page. And build an option for outputting a spreadsheet with some filters.

    Thanks for weighing in on the roadmap. The list is growing faster than I can type ;-) Once we get there, Supple Forms will be a pretty powerful little tool for data management and querying.

    I’m always open to folks contributing code if anyone gets the itch to write some :)

    Byron

  57. Steve Says:

    I’ve tried out the latest build at it fixes the problem with the Image Upload dialog.

    Thanks!

  58. Sumit Says:

    the first quick start movie stops @ 0.44 Minutes. Second played well.

  59. PhotoSmash Galleries WordPress Plugin Released » WhyPad Says:

    [...] other [?]box image viewers.  Haven’t tested with IE 7 or 8.  FF appears OK.  Check out Supple Forms for a Flutter [...]

  60. Narcie Says:

    I have two requests to improve the code.

    1. is it possible to make it UTF-8 code? I am using it, but once I input Chinese, it can’t displayed, I have to inject it in phpmyadmin, but once the admin page is reloaded, it displays unrecognized and add more codes again itself, making it totally unrecognized in display in the frontend.

    2. Multi-value is not useful. Say I use it for following multi-value: political science, information sciences, public administration studies. In display it joints together, simply becoming “political science information sciences public administration studies”, no comma, no line breaks, just becomes one big whole chunk of text, which is not formated at all, especially for me, when I have a long list of faculty names. I studied your code and postmeta again and again trying to formated but still cann’t achieve it. Is it possible to solve this problem? or simply not using postmeta?

  61. Byron Bennett Says:

    Hi Narcie,

    1) On UTF-8, Supple Forms utilizes whatever default character set you have set in WordPress when it creates the tables. Search supple-admin.php for:

    $wpdb->charset

    You should be able to see what character set is getting created by looking at the field definitions in phpmyadmin. If it is indeed storing the data in UTF-8, let me know and I’ll look into whether you can affect the character set on the output side. If it is not creating UTF-8, make sure that your WordPress default character set is UTF-8.

    2) For multi-value fields, you should be able to use a shortcode like: [supple field='my_multivalue_field' list='ol']

    For the separator, you can also use: ul, ol, or any string enclosed in quotes. Only ul and ol will be changed to tags.

    You can also do this using snips. There is a section at the bottom of the snip editor page that lets you specify different styles of separators for multi-value fields.

    Hopefully that will get you what you’re looking for.
    Byron

  62. Arkantos Says:

    I got the following messages when I tried to activate the plugin:

    Supple Forms not installed properly.
    Tables not installed properly: wp_sppl_fields, wp_sppl_snips, wp_sppl_forms, wp_sppl_lookup

    Fatal error: Cannot redeclare class SuppleForms in /home/***/public_html/test2/wp-content/plugins/supple-forms/supple-forms.php on line 36

    Please help! It looks like the plugin I was looking for… I need something to do sport player profiles and this is the closer plugin I’ve found to do that.

  63. Arkantos Says:

    PS: I have php 5, and yes, I tried to create the tables manually “copypasting” the sql consult you post and it threw a syntax error.

  64. Sven Says:

    Hey Byron

    If I make add character like öäüõ then after updating post it will give öäüõ then updating again it make this into Ã?¶Ã?¤Ã?¼Ã?µ and so one…

    I tried to find how to fix this encoding problem it but failed… If I disable this plugin and use wordpress own field it works.

    can you help out people who use weird characters in their everyday life :)

  65. Sven Says:

    sorry i missed last comment, but i have everything in UTF8

    echo $wpdb->charset; outputs UTF8

  66. Byron Bennett Says:

    Hi Sven,

    Could you check the database with phpMyAdmin and see what the text fields are being encoded as? Look for tables like: wp_sppl_forms or for you custom table: wp_supple_YourTableName

    I’d like to know if the problem is on the database side or if it’s somewhere else. I’m really lost when it comes to this part. Your help is appreciated!

    Byron

  67. Byron Bennett Says:

    Hi Arkantos,

    That error message has come up a couple of times (the cannot redeclare error). Try deactivating the plugin and activating again. I don’t know whether the problem went away for people or if they gave up.

    Does anyone have an idea why the plugin would get a “cannot redeclare” error on the main class when it is being installed?

  68. Narcie Says:

    About the encoding UTF-8, I checked the phpmyadmin, the table fields are set to utf8_general_ci, the display in phpmyadmin and front end, it displays Chinese correctly, but once after updating post it gives öäüõ then reload again it adds more codes which makes both phpmyadmin and frontend display wrongly. I have to try NOT to reload post in admin area and update the records in phpmyadmin to prevent this.

    About multivalue, I also tried hours to make it work, is possible to post couple of screenshot of your tutorial on this to guide me? your form is so wonderful except this…

  69. Arkantos Says:

    Problem solved! I just updated all to the latest version of WP. Now the plugin is correctly activated and working.

  70. Olive Says:

    Something is not right. I’m trying to use a multiple value check box field. No matter what I do, I cannot seem to get the values to space or break.
    for example, I’d have check boxes for red, white, blue. No matter what I try (those examples to follow) the published result is always redwhiteblue if all three are checked.

    in HTML filtering, no matter what I check, all, none, formatting… after clicking save field, it always reverts to NONE.

    for the values, I’ve tried
    red, red
    white, white
    blue, blue

    red, red \n
    white, white \n
    blue, blue \n

    red, red (\n)
    white, white (\n)
    blue, blue (\n)

    red, red
    white, white
    blue, blue

    What can I do, or what am I do wrong, so that I can have the values separated?

  71. Steve Says:

    Thanks for working on this Byron!
    I tried it with a multi-line text field and notice that no matter what settings are used, that the line breaks (or carriage returns/para breaks) get stripped out and everything shows up as just one line of text. Is there any way to fix this?
    Steve

  72. Byron Bennett Says:

    Arkantos,
    Excellent! Glad it’s working for you.

    Narcie
    I will get some screen shots for you. I really need to beef up the instructions for this plugin. I’m pretty sure I can get you what you’re looking for.

    Olive
    Hi! Thanks for trying SF. You control the display in your post through the shortcode or in the snips editor. I will get you an example tonight.

    Steve
    You may have found a bug there. Let me check it out tonight. I’ll need to play around with it…might require a new version.

    Thanks to you all for helping me make this thing better. I actually have some really big plans for SF, we’ll see if I’m up to the task :)

    Cheers!
    Byron

  73. Byron Bennett Says:

    Olive, Narcie

    I think that you both have the same question. Hopefully this will help.
    Ok, there are some options around displaying values from a multi-value field. Basically, all you have to do is use a shortcode in your post like:

    [supple field='my_multivalue_field' list='ol']

    The ‘ol’ will render an ordered list. You can also use:

    ‘ul’ = unordered list
    ‘br’ = line break
    ‘, ‘ = separate by comma and a space
    ‘???’ = pretty much anything you put in between the quotes will be used as a separator. So the key is to add: list=’???’ to your shortcode. Right now, ol, ul, and br are the only separators that will turn into html tags. Everything else is just taken verbatim.

    Here’s a screenshot of the write Post page where I’m including 2 multi-value fields (weblink and tag), using 2 different list styles:

    Screenshot showing multi-value list code

    Hope that helps. If not, send let me know what you’re trying. We’ll get to the bottom of it.
    Byron

  74. Byron Bennett Says:

    Steve,

    I’ve updated SF to 0.1.62 with a fix for the multi-line textbox issue. I hope I didn’t take it too far since SF now changes all new lines into br tags. Well see.

    Let me know if you hit any other snags.
    Byron

  75. Steve Says:

    Thanks Byron!
    In my searching around I have also come across this plugin: “More Fields” which is in some ways similar, but not quite. Anyway it may be useful to have a look at it and see if there’s anything in there that can save you some work…
    http://labs.dagensskiva.com/plugins/more-fields/
    Steve

  76. Byron Bennett Says:

    Hi Steve,
    Thanks for passing along the More-Fields. It looks like a very well done plugin. It may indeed shortcut the learning curve for me in some areas.
    Cheers,
    Byron

  77. Narcie Says:

    Bryon,

    Thank you so much for that quick tutorial for multi-value, it finally worked. I guess if someone knows how to use your multi-value, it becomes really powerful. The key is to put the seperator in a shortcode in the post rather than the Snipts part.

    About the displaying Chinese Charater part, as you instructed me, in both WP Admin and phpmyadmin, they are both set in UTF-8, so Chinese just didn’t pass though your plugin output part.

    So, I think this is wonderful plugin, and thank you again for making this one for our bloggers!

  78. Sven Says:

    about this UTF-8 problem, Im storing data to WP Custom Fields.

  79. Vasilis Says:

    Excellent plugin!

    Unfortunately it just does not work with UTF-8 characters as mentioned above…

    I tried it with Greek and when I update the post, all fields with values in Greek become a bunch of symbols.

  80. Byron Bennett Says:

    Narcie, Sven, and Vasilis,

    Sorry I don’t have a fix for the UTF-8 issue yet. I’ve been tied up with PhotoSmash, and quite frankly am procrastinating on this problem because I don’t have a clue as to where to start looking.

    I have another issue or 2 with PS that need resolving so they’re eating up my plugin development time for a couple more days. This is churning away in the back of my mind. Sometimes the old subconscious works a miracle if I give it time, but it has to have something to work with, and in the case of UTF-8, I’m a blank slate.

    I’ll keep you posted as things develop.

    Meanwhile: does anybody have any pointers on why a plugin might display garbage with non-English characters when the database is set to UTF-8?

    Any hints would be appreciated!
    Byron

  81. Jukka Says:

    Hello !

    Whenever I have text fields that have setting “allow multiple entries” on, I get this kind of error in the write panel:

    Warning: htmlentities() expects parameter 1 to be string, array given in C:\wamp\www\mysite\wp-content\plugins\supple-forms\supple-write.php on line 384

    I’ve tried “html-filtering” to “filter all” and “no filtering”, it seems that it doesn’t change anything. Also I’ve tried setting “numeric” on and off.

    I’m using Wordpress 2.7.1. and I disabled all other plugins.

    Jukka

  82. Jukka Says:

    Hello again!

    I’m creating html-snipplet, but whenever I add html to “List of values”-textbox in snippet editing page and save, html is filtered somehow and
    becomes . Same thing if using ” instead of ‘.

    And if I keep hitting save snip button, html does get filtered every time, and after hitting save for few times, it becomes like this: . What could be wrong ?

    WP 2.7.1 and WP customfields (not custom table) in use.

    Jukka

  83. Kel Says:

    Love the Plugin – thank you. I’d already put a post together a few weeks ago listing the “Best Of” WordPress CMS style plugins, but I added yours to the list.

    http://www.badcat.com/journal/wordpress-as-a-cms.html

    I especially like that you’ve give the user the choice of a custom DB entry or using WP’s own Custom Fields.

    Nice work! Thanks again.

  84. Byron Bennett Says:

    Hi Kel,

    Thanks for the press! Supple Forms is still in its infancy right now, but there’s a bit of power there if you get creative with it. The Snips builder gives you a lot of flexibility.

    I have this grand vision for Supple Forms, but I really run the risk of biting off more than I can chew as you mentioned with the Flutter plugin. It really gets me going when thinking of the possibilities. I just need to get my PhotoSmash plugin to a point where I can devote some development cycles to SF ;-)

    Cheers!
    Byron

  85. olive Says:

    It would be amazing if one could enable certain fields to become tags.

  86. Byron Bennett Says:

    Hi Jukka,

    It looks like you’re having 2 separate issues: 1) with the htmlentities error, 2) the snips editor is stripping your Html tags.

    I noticed from the error message that you’re running that from a Windows machine. I wonder if there are some differences that I’m not allowing for that could be causing these issues?

    What version of PHP and MySQL are your running?

    I have used anchor/href, bold (b), and ol tags and they appear to be working.

    What tags are you having problems with?

    As for the Custom Fields versus Custom Tables, that shouldn’t matter if you are entering the html into the “List of Values” field. (I really need to rename that, BTW…it should be something “HTML Snippet” :( ).

    Please let me know any additional info that you think might be helpful in trouble shooting. I don’t know where to start with this one.

    Does anyone have any suggestions?

    Byron

  87. Byron Bennett Says:

    Hi Olive,

    I’ll put the suggestion on the list ;-)

    BB

  88. Kathy Says:

    Hi Byron, again, thanks for this plugin.

    I discovered that searching for words inserted using the custom fields doesn’t work. I tried adding “Search Everything” and “Search Unleashed” plugins, but it still doesn’t work.

    Do you know of a solution?

  89. Byron Bennett Says:

    Hi Kathy,

    You’re very welcome. I don’t know of anything that searches custom fields. I do plan to add some query capabilities to SF down the road. I don’t know what form that will take yet, but I’ll put a tickler on my list about search.

    Byron

  90. ?????????????????WordPress?????TOP 60 - ElectronicBrain is eating BreakFast Says:

    [...] Supple Forms [...]

  91. Kel Says:

    @kathy I think one of the search plugins you mention should work if you’re using the standard database and not the custom one in Supple Forms. Can you confirm which db you’re using?

  92. Chuck Says:

    Hey,
    I would like to add a form to my posting called “Free Shipping” with two radio buttons, the choices being “Yes” or “No”.
    Is there a way to use Supple Forms so that when “Yes” is selected, it displays a picture of a free shipping icon, but when no is checked, it displays nothing?

    This could also be done with a single Checkbox as well. I could call it “free shipping” with a “Yes” checkbox if I want the icon to be displayed.

  93. Byron Bennett Says:

    Hi Chuck,

    Sorry, SF can’t show an image as the display label for items, but I love the idea. I’m adding to the list of requested features. Unfortunately, between Supple Forms and PhotoSmash, my list of requested features is getting incredibly long.

    Byron

  94. Patrick Says:

    I think a WYSIWYG editor for form fields is probably the most important development, because without it, the functionality is very limited.

    After that, the ability to associate specific forms with specific post or page templates would be very powerful.

    Thanks for the great plugin so far!

  95. Byron Bennett Says:

    Hi Patrick,
    A WYSIWYG editor is a good idea…I’ve put it on the list. Your second suggestion is part of a major, major overhaul that I have planned.

    Cheers!
    Byron

  96. adi Says:

    I found a little bug on your script
    check out here:
    http://img217.imageshack.us/img217/1097/sumple.jpg

    I add “Daftar Kerjasama LIPI” database and some fields there.
    When I choose dropdown list with value nota kesepahaman the result on the post just a ,b>nota text.
    and it happens on dropdown list and checkbox with value which separated with spaces

    I try using   (html code for space) but failed.
    maybe a simple modification on your entry function to database fix this, cause when I watch on my database the value is nota

    anyway, I love your plugin. Really
    The multiple database capability and external menu (out from write new) would be a great thumb
    good work!

  97. Byron Bennett Says:

    Hi Adi,

    Thanks for bringing that to light. I’ll see if I can get a fix out in the next couple of days.

    Glad you’re liking the plugin. I think that a lot of people are starting to see the potential for this plugin (or one like it) to become something really useful in developing applications within WordPress.

    Cheers,
    Byron

  98. Juampi Says:

    Someone who can help me… i dont know very good how to use this plugin… can anyone help me or edit this plgin for me and i can pay for that! Tx. juampolo (at) gmail.com

  99. Byron Bennett Says:

    Hi Juampi,

    I may be able to help. I’ll send you an email.

    Cheers,
    Byron

  100. Gabriel Says:

    Hi,

    Would it be possible to have a special text area that has an insert/upload box like in the image bellow. Something that uses the preexisting wordpress upload page.
    http://imgur.com/IXCP5.png

    Thank you,

    Gabe

  101. Byron Bennett Says:

    Gabe,
    Not at this time. Uploads are on the list, but it’s down the road, I’m afraid. Sorry,

    BB

  102. Some Powerful WordPress Plugins | Shefeekj.com Says:

    [...] Supple Forms Supple Forms for WordPress offers two significant functions for your blog. You can build custom write panels for the WordPress Write Post page and easy insert form data and HTML snippets into your posts. Supple Forms lets you store your data in either WordPress Custom Fields or your own custom table that the plugin will create for you. So you can format and insert your data into pages and posts with shortcodes, and without tweaking templates. [...]

  103. Gabriel Says:

    I wouldn’t want you to do that. IMO, the default wordpress upload box is good enough.

    Maybe you can incorporate some elements from the “Custom Field Images” plugin into your plugin like media buttons and the “insert CFI” button which allows you to copy the url of the image onto desired custom field.

    I prefer your plugin because it give the user full control of the output and it easier for computer illiterate people(my father) to edit and change pages.

    Thanks,

    Gabriel

  104. Gabriel Says:

    after checking the source of the plugin, it looks like it is javascript based. I’m gonna try to integrated into supple pages.If I get it to work, I’ll post the code here.

    Gabriel

  105. Jarvis88 Says:

    Hi, sorry if this is a stupid question.

    Is it possible to have more than one form? Cause at the moment it doesn’t look like it can and I reeeeeally need to be able to have more than one form! Please help!

    Have been testing out flutter, but its got so many bugs and it displays funny with most of my crucial plugins! Plus I like the fact that supple forms makes it so easy to add the content with the html snips! There’s no way you could build in some of the features that flutter has?

    Thanks!
    Jarvis

  106. Byron Bennett Says:

    Hi Jarvis88,

    Not at this time. Sorry.

    I actually do have plans for a major overhaul to Supple Forms that will add a number of new features, including multiple forms. The bad part is that between Supple Forms and PhotoSmash, I’ve got a huge list of features to add.

    Just sorry to have to report that it’s down the road.
    BB

  107. Byron Bennett Says:

    Hey Gabriel,

    Thanks for weighing in on uploads. And double thanks for dipping into the code to see if using WordPress standard links would work!!

    One of the reasons I plan to add uploads is that I want to add the ability to use SF forms outside of the WordPress Write Post/Write Page pages (in other words, you would be able to include forms in Posts and Pages to collect info from users). In those cases, it would make sense to have uploads liberated from the standard WP upload functionality. The other reason is that I want to put some query capabilities in SF, so you could include uploads in queries.

    Of course, all of this is…”down the road”. My plans for this thing are much bigger than the time I have available.

    Any code that you have that might help would be much appreciated :) Seriously!

    Cheers,
    Byron

  108. Charlie Barks Says:

    Bryon, I sure do need some assistance in tweaking a wp site. Are you available for hire and consultation by chance?

  109. Byron Bennett Says:

    Hi Charlie,
    I may be able to help. Send me an email at byron @ whypad.com and let me know what you’re looking for.

    Cheers,
    Byron

  110. Michael Montgomery Says:

    Hi Byron,

    I discovered your plugin yesterday. I’m experimenting with it But found the following issue, as soon as I add a class in the HTML snippet box the following HTML () gets converted to this ().
    I tried editing the wp_kses array in the “supple-write.php” page without any success.

    Could you please assist me.

    Thank You Kindly

  111. Byron Bennett Says:

    Hi Michael,

    It appears that the comment system didn’t like it either, as all i see is (). Could you send it to me in an email and I’ll take a look. byron @ whypad.com

    Byron

  112. Michael Montgomery Says:

    Hi Byron,

    I see my example code was “trimed” in my previous entry . let me then explain. a forward slash gets inserted before the quote / double quote’s in my class identifier.

    Thats it
    Thank You Kindly

  113. Aris Says:

    Hi Byron,

    You’ve really been doing some great work with this plugin, excellent job. Two things:

    One is that for folks who are frustrated that custom meta doesn’t get returned from the standard wordpress search, use the search-unleashed plugin, it will allow you to specify which meta data to return as well. Works great.

    Secondly, I’ve noticed that when someone edits an article with an existing meta-data value containing an apostrophe and updates the post another \ is added to the current \’ value. This can result in long trails of \\\\ if an article is edited more than once.

    Not the end of the world, but certainly causing a few headaches.

    Thanks much Byron.

    Aris

  114. Byron Bennett Says:

    Aris,

    Michael was having the same problem with the back slashes. I have been completely unable to reproduce that behavior, and can find no reason for to be occurring. Do you have any ideas on what the problem is or how to fix it?

    I worked with Michael offline for a bit, and he eventually came to the conclusion it was because Magic Quotes was turned off in his environment. I don’t know if turning Magic Quotes on fixed it for him or not. But even if it did, that’s not really a good solution. And my code basically does a stripslashes if Magic Quotes is on. That shouldn’t be affecting it if they’re off.

    This is really a stumper. Any help from anyone would greatly be appreciated.

    Byron

  115. Michael Montgomery Says:

    Hi Aris,

    Turning on magic quotes solved the problem of backslashes \\\ . Using PHP 5

    Thanks Guys.

  116. Robert Says:

    Hi Byron. I’m so excited about this plugin. You have done some incredible work and I can see that you have much more up your sleeve. :)

    Quick question:

    Is there a way for me to make use of [other short codes] from other plugins. I tried to do this and unfortunately what I got was the text of the short codes….but not the functionality. :(

    Any ideas?

  117. Byron Bennett Says:

    Hi Michael,
    I’m kind of glad that turning on magic quotes solved the problem. The only trouble is that I don’t know why it was a problem when magic quotes was turned off. It shouldn’t have been adding the slashes :(

    At any rate, if anyone has ideas, I’d LOVE to hear them!

    Cheers,
    Byron

  118. Byron Bennett Says:

    Hi Robert,

    Thanks! I’ve got more plans than I have time!

    Short codes are Plugin-specific. You could make your plugin use the same short codes as another plugin, and that can in fact be a problem some times. I’ve noticed some plugins use very generic short codes like [gallery] or [form], but I think they run the risk of colliding with other plugins.

    I’ve tried to make Supple Forms and PhotoSmash plugins use short codes that are unlikely to be duplicated in other plugins so the plugins can coexist peacefully.

    So, to answer your question, if you use shortcodes from other plugins, you have to have those plugins activated, or else it will just print out the short code as text.

    Byron

  119. Aris Says:

    Hi Byron,

    I’ve poked around a bit and the only thing I’ve noticed is this little doozy at line 174 in supple-write.php


    } else{
    if(get_magic_quotes_gpc()){
    $val = stripslashes($val);
    }

    There does not seem to be any other stipslashes done, which means anyone without magic quotes (like myself) get’s no slash stripping. I’m assuming that perhaps the slashes are being introduced by html_filter?

    Does that seem like a possible trouble spot? Or have I just revealed myself to be far out of my depth with your plugin?

    Aris

  120. Byron Bennett Says:

    Aris,

    I bet you’re on to something. I’ll look into the html filter and see if it’s adding slashes. It may slash everything for everyone, and I’m just stripping slashes for those with Magic Quotes.

    I’ll post an update as soon as I can.

    Thanks for digging in!!!

    Cheers,
    Byron

  121. mephisto Says:

    Hi, good works. It would be very useful the ability to create a group of combined select that show data from external tables…example:

    -1st SELECT -> “Please Select State…” (select state, id from city_state)
    -2nd SELECT ->”Please Select City…” (select city from city_state where idstate=$idstate)

  122. Byron Bennett Says:

    Thanks, Mephisto!

    That’s a great suggestion. It’s on my list. I want to build into SF a complete query designer that will let you do what you’re asking, as well as display results based on your custom queries.

    Unfortunately, I’ve been slammed with PhotoSmash and haven’t been able to get my development rolling with SF. It’s coming though.

    BB

  123. Alan Says:

    Byron,
    Thanks for taking the time to develop your plugin! Supple Forms is unique in it’s capability of creating a new table within the WP database… Could you give this php novice a simple example of code or a function (php–not shortcodes) needed to connect to and display values on a custom page from the database that Supple Forms creates?

    Wish I could grant you more hours in the day–you sound like a busy guy! Thanks

  124. Manik Says:

    Byron,

    Good plugin there…. But I have slight problem… whenever I enter new data into the custom field when writing new post and save the post ( or publish the post )… the the values inside the custom fields revert to default values or become empty…

    have any idea what might be causing it?

  125. Ian Says:

    I’m having a problem setting up snips in your plugin. I know its because I’m not doing something right and it would probably take you 5 minutes to do it for me. Could I send you the html I’m trying to set up and you could tell me where I’m messing up?

    Thanks,
    Ian

  126. Byron Bennett Says:

    Hi Ian,

    Sure, no problem. Email to me at byron @ whypad. com

    Hopefully it will be an easy fix. Fingers crossed!

    Byron

  127. Glen Barnes Says:

    I’m wondering if you could provide an easy way to access the fields/snips from templates? I was thinking something like:

    get_supple_field(‘field_name’); //returns text of field
    get_supple_field_by_value(‘field_name’); //returns value of field

    Basically I am trying to display/hide content based on the value of certain fields and do some other logic. I know I can do my own DB queries but a simple interface would be good.

    Thx.

  128. Andy in Tenerife Says:

    Could this be used as a real estate plugin?
    I´m looking for a good WP plugin to manage a real estate website, also need on for car rentals and classifieds.
    I want to check this out but the video tutorials arent working.

  129. Glen Barnes Says:

    Thanks for the plugin – It works pretty well but I do have one small issue. I am trying to do a select box that has a label with a comma in it:

    1, Treasure, The
    2. Some other value
    3, Department of Something, The

    It is stripping the ‘, The’ at the end. Is there any way to allow commas in the field name?

  130. Byron Bennett Says:

    Glen,

    I’ve fallen behind on Supple Forms comments…sorry.

    Both of the items you’ve inquired (template tags and commas in lists) about are not possible in the current iteration of Supple Forms, but I will add to the list.

    On the comma’s, I tried the Ascii code, but that didn’t work. I’ll be able to make it work in the next iteration, which unfortunately is a bit down the road as I’m trying very hard to get the big PhotoSmash upgrade out the door.

    Byron

  131. neo74 Says:

    Would like to ask for help!
    I tried to add Supple Forms. Very pleased, easy to use. I use hunagrian language in my blog.
    The latin2’s characters do not display properly. For example: ?sz, üzen,üget?.
    The database UTF8 WP, WP 2.7.1 version.
    Is there a solution? Thank you in advance!

  132. Byron Bennett Says:

    Neo,

    Sorry. I haven’t figured out how to fix that yet, but I need to. This has been a problem for a few poeple. Unfortunately, I’m tied up with my other project at them moment and can’t get to this.

    If anyone has any idea of how to fix this, I’d be very interested to know!

    Byron

  133. neo74 Says:

    Bennett,
    Thank you for your quick answer. Possible to resolve the problem. The plugin is UTF8 encoded files changed, as well as all the files in the “htmlentities” are extracted. Thus, the characters appear correctly, but also tested. If you have a perfect solution, it will be welcome. This plugin is very good, good luck to continue.

  134. neo74 Says:

    Byron,
    I think I have the solution. In the rows, where in the “htmlentities”, there should be improved and supplemented by the appropriate character set. For example:
    htmlentities ($ variable, ENT_NOQUOTES, ‘UTF-8′).

    I tried, I have works perfectly.

  135. Byron Bennett Says:

    Neo,
    Thanks for diving into that! I will give it a try and see about getting it into official code.

    That is a huge help!

    Byron

  136. Chris Says:

    Is there anyway this can be used with pages instead of posts? This has the exact functionality I am looking for except I would rather it hook onto pages.

    I would also LOVE to have this as a stand alone funtction in the admin area, not being attached to posts or pages but each entry having a unique ID and being able to call that entry on any page or post using a snipet. That would be wonderful! You could have an entry form in the admin area (not in pages or posts) and also have an edit form where you can select which entry you want to edit. Let me know if this is at all possible as I am trying to get something going with my project ASAP!

  137. Chris Says:

    ok, I’m DUMB. I now see that it is available on pages, got ahead of myself :)

    I would like the ability to turn off the “form” for posts and only have it on pages. I don’t want my authors adding these custom fields to posts. :)

    My biggest request is still the stand alone functionality where you separate the entry form from pages/posts and put it into a new admin page for this plugin.

  138. Byron Bennett Says:

    Hi Chris,

    The functionality you’re looking for isn’t in Supple Forms yet. Hopefully one day in the not so distant future.

    If you can’t find anything else, you might take a look at my other plugin, PhotoSmash. I’ve been pouring all my time into it, and I think it might do what you’re wanting. It does the custom form and custom fields thing, and custom layouts, and does it in such a way that it can be related to a post or independent.

    The only trick would be that it doesn’t have the form in the Admin yet, but you could create a page with the form on it and not publish it, and add your data in the Preview mode. Or you could make it Private so only you could access.

    These functions are only available in the Development version 0.2.991. It’s available on Wordpress.org/extend, but it’s not the official release yet. I’m hoping to release it as 0.3 next week.

    So…basically, if you can’t find anything else out there, you might try PhotoSmash version 0.2991 or higher.

    BB

  139. Chris Says:

    I am having issues with the dropdowns. I have created the drop down list but when in the post area and I select one of the drop downs, it does not save the value. It created the entry for metakey in postmeta for the correct page but is not saving the value. Any idea what I may be doing wrong or any ideas how I can get this fixed?

    Thanks

  140. Chris Says:

    lol, once again, getting ahead of myself. I had named the field the same name as a different custom field and it seemed to have been messing up. I renamed it and it worked great!

  141. Byron Bennett Says:

    Chris,

    That makes me so happy! I was like: “Oh crud! What could this possibly be?” I’ve seen so many different reasons that things might not work, you just never know what will crop up next. ;-)

    Cheers,
    Byron

  142. Chris Says:

    Do you know of a quick hack that would allow a conditional statement to be put in place for the showing of the form. Example, ONLY show this form ini the page editor for pages that have XXXX as its parent page? I am using the form for a special purpose that only applies to a certain set of pages that are sub pages of one category. This would help minimize confusion immensely to the people helping me build the pages.

    I’m probably stretching the power of wordpress here but it’s worth a shot :)

  143. Byron Bennett Says:

    Hi Chris,
    You’re not stretching WordPress, but you are stretching the current version of Supple Forms. SF can’t do that yet.

    The Flutter plugin may be able to do what you’re asking. They’ve come a long way over the last few months in getting the kinks straightened out.

    BB

  144. Michael Montgomery Says:

    Hi Byron,
    Firstly hope you enjoy your 4th July…

    Is there a way of implementing a hidden field, I’m thinking of adding a user id to each post. As I need to execute a custom mySQL query.

    I see you were thinking of this function, as theres some “leftover” code in the scripts.[case 6].

    Thank You

  145. Byron Bennett Says:

    Hi Michael,

    It was a good 4th!

    Yes…I was planning to do a hidden. It’s not in there now. It will be when I can get to it.

    Byron

  146. Michael Montgomery Says:

    Hi Byron,

    I was able to sort the hidden field – Thank You.
    I needed to add ($myvalue= $current_user->user_login) into the database, as I needed to retrieve info. with custom queries. I simply completed what I think you intend doing.

    I won’t post the update (hack) here as it’s very specific to my use. I now know why you’re holding back on this feature as it can create many problems for the uninitiated, like myself :)

    Keep Well

  147. Brockbarn Says:

    Hi, I was wondering if anyone would help me.

    I am using Supple Forms and wish to hide a field when no value is inputed – i am trying to use an if statement in the HTML snips editor with no luck

    Is there anyway to do this?

    Thanks

  148. wzqhzsc Says:

    I have the same issue as Olive:
    in HTML filtering, no matter what I check, all, none, formatting… after clicking save field, it always reverts to NONE.

    Anybody can help?

  149. Byron Bennett Says:

    @Brockbarn,

    Sorry, but there is no way to do conditionals at this time. That is an excellent idea for future versions, though.

    @wzqhzsc,
    When you select html filtering, it’s not doing any filtering at all?

    I am very sorry that I can’t dive into these items very deeply at the moment as I’m completely tied up with PhotoSmash at the moment. I do have big plans for Supple Forms, but PhotoSmash has come in and taken over my time :(

    Byron

  150. wzqhzsc Says:

    > @wzqhzsc,
    > When you select html filtering, it’s not doing any filtering at all?
    The situation is that no matter what I check, it always filters out the hyperlink. For example, I input My Site. It always only has ‘My site’ left without hyperlink after publishing.

  151. Paul Says:

    Amazing plugin Byron. It does what I need. One thing: Can I modify it to also collect the author_id? How can I do that? Thanks.

  152. Jorge Says:

    Great Plugin!

    Was wondering if you have considered, or if it is possible, adding a file upload box to the list of field options.

    Thanks!

  153. Byron Bennett Says:

    @Paul,
    I’m glad you like SF!!
    The Author ID is being captured in the Custom table in the field supple_created_by and supple_updated_by (for subsequent updates). You might try one of those.

    @Jorge,
    Thanks!
    The file upload is on the list.

    Byron

  154. Paul Says:

    Byron,
    Thanks. I am really probably just missing it so I hate to ask again but I have looked through all of the database tables in my WP and have not found the fields supple_created_by or supple_updated_by. I would really like to use these as filters to chart the data collected in my membership site. Which table can these be found in? wp_sppl_fields, wp_sppl_forms, wp_sppl_lookup, wp_sppl_snips or wp_sppl_pdu

    Thanks for your help.
    Paul

  155. Byron Bennett Says:

    Paul,

    This is only being captured if you’re using the Custom Table feature, in which case the table will be: wp_supple_{custom table name}

    Note that the custom table uses prefix: wp_supple_ while other tables use wp_sppl
    Hope that helps.
    Byron

  156. Paul Says:

    Thanks for writing so quickly.
    I double checked and I am using the custom table feature which gives me the table wp_supple_pdu. In that table are the fields I created and also these three: id post_id supple_status but there are no others. supple_created_by and supple_updated_by are not there. Now, I did look and found that when I created the table I had chosen to “Hide WP custom fields” and also chose “Custom Table” and gave the table the name “PDU.” So I went back and unselected the hide feature, saved the form and then regenerated the table. The two fields still do not show up.

    I am running WP 8.2.1 and the latest Supple Forms. Its a really great plugin.

    What am I missing?

  157. Byron Bennett Says:

    Paul,

    Sorry!!! I was looking at my development version of SF, which I can’t put out there for you because I don’t know what state it’s in.

    You’re right…those fields are not in the official release.

    I’m going to have to take a break from PhotoSmash and get Supple Forms caught up.

    Sorry.
    BB

  158. Paul Says:

    Thanks again for your quick reply.
    The additions of those fields would be really helpful to me so I would love it if you would take the break. I’ve looked at PhotoSmash and it is pretty cool.

    If adding the fields is not too complicated I’d be happy to try it myself…with a little help of course.

    Whatever you can do. Thanks for all your hard work.
    Paul

  159. Pete Says:

    This seems to be a great plugin, and is exactly what I need!

    I’ve created a form and all fields and made a few posts with those fields filled in.

    But when I created a SUPPLE SNIP with HTML code and place it in a post, the HTML portion transfers over, but the fields are BLANK!

    ie: If my supple snip code is: I live in [my_city].
    the resulting html is: I live in .

    Any idea why this is happening?

  160. Pat Says:

    Is there a way to add javascript (to do a calculation) in supple forms? I have a series of textboxes where someone will enter their age, weight (either in lbs or kgs decided by a radio button), gender (m/f decided by radio button), average heart rate, and duration in hours and minutes. This will all be used to calculate calories burned for a workout. How can I add a snip to accomplish this?

  161. Byron Bennett Says:

    @Pete,

    I’m not sure why that isn’t working. The things to check are: 1) do the field names match exactly the field names in your list of custom fields: [my_field]; 2) do you have data for the post you’re looking at; 3) are you calling the right snip: [supple snip='my_snip']

    I know those are basic, and you’ve probably got them right, but I honestly can’t think of why else it might not be working…I’ll keep thinking.

    @Pat,

    You can’t add that code through Supple Forms at this time, but you might be able to include a JavaScript file through your theme or through a plugin you write yourself. If you can hook into the fields through jQuery, it should work.

    BB

  162. Jeromy Says:

    What are the template tags? Is there a list of them anywhere?

  163. Byron Bennett Says:

    Jeromy,

    Sorry…no template tags at this point. It’s all done through the shortcode in the body of the posts and pages.

    BB

  164. Jeromy Says:

    oh really? #16 above under usage says: 16. Template Tags. Can you get them through the custom field meta?

  165. Byron Bennett Says:

    Jeromy,

    Yeah…sorry. 15 & 16 were supposed to be in the “On the Drawing Board” section. Thanks for bringing to my attention…i’ve moved to proper location.

    If you’re using the WordPress Custom Fields option, you can access the Supple Forms Custom Fields through the Custom Field Meta, but if you’re not, you’d need to access directly through the $suppleForms object variable that gets created for the plugin.

    If you use: $my_variable = $suppleForms->getPostData($post->ID, $fields)

    (where $fields is an array of the fields you want) you’ll get back an array of the fields for a post.

    That may work for you. I haven’t tried this, so I don’t know if it works…I’m not sure if you’d need to do a: global $suppleForms
    in your template or not.

    Here’s the header for the function that I’m referencing there. It’s in supple-forms.php around line 552.

    /**
    * Retrieve form and custom field data for a Post
    *
    * @param int $post_id The post ID
    * @return $data – an associative array with field names as keys
    *
    * Multiple value fields with have their values as an array
    */
    function getPostData($post_id, $fields)

  166. Darcy Voutt Says:

    Bryon,

    I want to embed a supple form into a theme so that I do not need to enter the short code each time I wish to create a new post.

    How can I embed the short code into my Wordpress theme?

    Cheers,

  167. Byron Bennett Says:

    Darcy,

    There are no template tags at this point, but check out the reply to Jeromy (immediately above) for an experimental method…you would need to know some PHP to accomplish this at this point. Sorry,
    BB

  168. Darcy Voutt Says:

    You may be glad to know I figured out an alternative, download a plugin called FT Signature Manager, and you can embed the short code into the signature which will give you the option per post (only it seems) to your “signature” or not!

    Cheers

  169. Byron Bennett Says:

    @Darcy,
    Cool! Glad you’re in business!
    BB

  170. Sara Says:

    Does the plugin render images? I pretty much need the user to be able to select from a dropdown list of images, and I currently can’t find a way. Any suggestions at all would be incredibly wonderful.

  171. Troy c Says:

    Byron,

    This is great work. I know PhotoSmash is taking up your time (I know how that is). I wouldn’t mind helping on the post/page/category-specific forms, but it sounds like you’ve done some major rewriting of the code.

    Would it be worth it take a shot at an inelegant solution based on the existing code?

    I’m thinking it’s gotta be possible to at least “hide” the forms if it’s a page instead of a post. Those are distinct WP templates that could be altered – I assume???

    Let us know the best way to proceed. This would killer functionality, especially in combo with Role Scoper plugin.

  172. Byron Bennett Says:

    Sara,
    I tried that, but wasn’t able to get it to render the images…I’m sure it could be done, I just wasn’t able to get it going.

    BB

  173. Byron Bennett Says:

    Thanks Troy!

    I had made a little headway with the BIG move for SF, but not enough. So, if you wanted to take a shot at hiding the forms based on the existing code, it probably wouldn’t be totally wasted.

    The architecture of PhotoSmash is a lot closer to where I was going with Supple Forms than the current SF code. In fact, PhotoSmash does a lot of what SF does, except for the Write Post/Write Page forms, and it also is limited to a single Custom Table, and it doesn’t have an option for WP Custom Fields. But you can build custom forms/fields for PhotoSmash with layouts, etc.

    The good news for Supple Forms is that I’ve learned a LOT with PhotoSmash, so it should benefit from experience when I get back to it.

    I’d be glad to consider any modifications you make. I’d be very glad to have some contributors on this project!

    Byron

  174. Maathilde Says:

    Hi Byron,
    many thanks for this great plugin :-)

    I am posting in French and I have the same UF-8 issue than a few users.
    I’seen all the replies and Neo’s one may be a solution :

    I refer to the Neo’s reply (june, 19)
    “Byron,
    I think I have the solution. In the rows, where in the “htmlentities”, there should be improved and supplemented by the appropriate character set. For example:
    htmlentities ($ variable, ENT_NOQUOTES, ‘UTF-8?).

    I tried, I have works perfectly.”

    The problem is I don’t understand what it means and how to do …
    can you help me with a more explicite explanation ?

    thanks in advance, Mathilde

  175. Supple Forms – A WordPress CMS Plugin » WhyPad | Squico Says:

    [...] In: Wordpress plugins 25 Aug 2009 Go to Source [...]

  176. Byron Bennett Says:

    Hi Mathilde,
    You’re welcome!

    I will try to get this code into an updated version of SF in the near future. Hopefully this will help several people!

    Cheers,
    Byron

  177. Paul Says:

    That is great news Byron. Your work is really amazing and the update on SF will be really great. Thanks!

  178. Maathilde Says:

    Thanks, read U soon ;-)

  179. Jeromy Says:

    how do I “generate” my fields? I get an error saving my posts with the shortcode and all my fields on the snip editor page say “not generated” (I’m using WP Custom fields):

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY meta_id' at line 1]
    SELECT * FROM 417766_postmeta WHERE post_id = 6 AND meta_key IN ORDER BY meta_id

  180. Jeromy Says:

    Hey Bryon, any thoughts on my question above?

  181. Jeromy Says:

    I deactivated all the plugins on the site and the mysql error went away, but I still don’t get anything displayed when showing my snip in a page. I’m using brackets and I’ve created a post and filled out the supple form info, but when I go to the page, nothing shows

  182. Jeromy Says:

    ahh, found another error in my logs that I missed just now:

    WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ORDER BY meta_id’ at line 1 for query SELECT * FROM 417766_postmeta WHERE post_id = 6 AND meta_key IN ORDER BY meta_id made by require, require_once, include, include, the_content_limit, apply_filters, call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, SuppleForms->shortCode, SuppleForms->showSnip, SuppleForms->getPostData

  183. Jeromy Says:

    a little more info (sorry to spam the board!) – more testing revealed these 2 errors:

    PHP Notice: Undefined variable: cf in /web/content/wp-content/plugins/supple-forms/supple-forms.php on line 630
    PHP Notice: Undefined variable: listformats in m/web/content/wp-content/plugins/supple-forms/supple-forms.php on line 479

  184. Byron Bennett Says:

    Jeromy,

    Sorry I haven’t gotten back to you…been out of town. I’ll work through your messages tonight! :)

    BB

  185. Michael Says:

    Hi Byron,

    Great plugin. Already have it running and am very impressed. Its going to be very useful for me, as its going to make my clients life 100x easier not having to touch any html.
    But is there a way to create a button in the form that auto inserts the shortcode? I dont want the shortcode to be automatically entered, but i would like it easier for the clients to use than adding the shortcode manually.

    Thanks in advance.

    -m

  186. Byron Bennett Says:

    Michael,

    There isn’t anything in the plugin that does this right now. It would be possible to create a button for TinyMCE to insert the Short Code, but it would be down the road for me to do at this point.

    BB

  187. Byron Bennett Says:

    Hi Jeromy,

    What versions of MySQL and PHP are you using? Not sure that this is the problem, but could be.

    Byron

  188. Jeromy Says:

    the latest stable versions of each – I actually switch to the flutter plugin which seems to work for me – sorry man! Great plugin either way, maybe I was just missing something :(

  189. Byron Bennett Says:

    No problem…glad you’re up and running.
    BB

  190. johny why Says:

    hi Byron
    love this plugin! just what i was looking for. but can’t really use it yet. looking forward to these features:

    -multiple forms, with a form pick-list on the page/post editor
    -a file-path picker with a browse-button and upload button (for visitor downloads)
    -integration of WP’s media uploader/library (to insert pictures/videos)
    -ability to put your tags into the page/post template of the theme (does this work already?)
    -integration with one of the many page/post template pickers, so multiple supple forms would be associated with multiple page/post templates

    hmm, that’s a start. thanks!

    ~johny

  191. Max Says:

    Hi! Thanks for plugin. All is working perfectly. But I have one problem. I am using Russian language on my site and all snippets and fields values are showing right on the front-end. but in back-end there is problem with encoding. All fields values and al russian symbols in html snippets editor are in wrong encoding.
    Any suggestions?

  192. Felix Says:

    it would be great if you can add upload file functionality, so that we can upload at least one pic to the record.

  193. Joe Says:

    Hi,
    The plugin looks very interesting, so I downloaded it and installed it according to the instructions. Everything seems to work: I can create different fields; I can see the fields in the add new/edit post form and I can write in them; through phpmyadmin I see that whatever I wrote is correctly inserted in the database; moreover, I also see the contents of the fields through the Supple Database Viewer page. Also, I can create and save the HTML snippet. However, if I use [supple snip='my_snip'] in a post nothing happens (I have a white page), and at the bottom of the page I have the following message:

    WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ORDER BY meta_id’ at line 1 for query SELECT * FROM wp_postmeta WHERE post_id = 755 AND meta_key IN ORDER BY meta_id made by require, require_once, include, bfa_center_content, eval, bfa_post_bodycopy, the_content, apply_filters, call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, SuppleForms->shortCode, SuppleForms->showSnip, SuppleForms->getPostData

    755 id the post id with [supple snip='my_snip'].

    Any idea on what’s going on? did I do something wrong during the installation? (I also tried to uninstall and reinstall the plugin, but nothing changed)? is there a conflict with some other plugin?

    thanks

    Joe

  194. Byron Bennett Says:

    Joe,

    I take it that you’re not using the custom table option…I’ll need to poke around.

    Can you post your snip?

    BB

  195. Byron Bennett Says:

    Johny, Felix,

    I’m not sure where development of the Flutter plugin for WP is right now, but I think they’ve got many of those features. It’s going to be a while before I can get those added :-(

    Max,
    Do you have any experience in how to get the encoding right? I’d like to add in the proper code, but am a bit lost with it.

    Byron

  196. Joe Says:

    Hi Byron,
    I am using a custom table called Pubblicazioni. I can see it in the database and it contains the data I wrote.

    here is the snip. If I add some text in between the fields I can see the text when I use [supple snip='my_snip'] in a post, but I don’t see the content of the fields.

    [Autore_pub]
    [Titolo_pub]
    [Titolo_Libro_o_Rivista]
    [Editor_pub]
    [Luogo_pub]
    [Casa_Editrice_pub]
    [Categoria_pub]
    [Anno_pub]
    [Pagine_pub]

    one thing I noticed when I activated again the plugin is the following message for a couple of seconds:

    Wordpress database error Table ‘Sql266420_1.sppl_forms’ doesn’t exist for quesry SELECT * FROM sppl_forms WHERE form_id=1 made by activate_plugin, include, SuppleForms->SuppleForms, SuppleFOrms->getFormSettings WordPress database error Multiple primary key defined for ALTER TABLE wp_sppl_lookup ADD PRIMARY KEY (id) made by activate_plugin, do_action, call_user_func_array, SuppleForms->init, SuppleFormsInit->SuppleFormsInit, dbDelta WordPress database error Multiple primary key defined for query ALTER TABLE wp_sppl_snips ADD PRIMARY KEY (snip_id) made by activate_plugin, do_action, call_user_func_array, SuppleForms->init, SuppleFormsInit->SuppleFormsInit, dbDelta

  197. Joe Says:

    Hi,
    since I really like this plugin, and I would like to use it in my blog, I tried to understand why it’s not working. So, I completely uninstalled the plugin, deleted the supple tables from the database and reinstalled the plugin. this time I don’t have any error message, so I think that the problem was due to the activation/deactivation/reactivation of the plugin.
    However, even though I no longer have the above error and everything seems to work fine, I’m still unable to see the content of the different fields in my posts/pages. What do I do wrong? Is there anything I should check in the php code so that I can get the plugin to work?
    thanks
    Joe

  198. ShareKnow Says:

    [quote]it would be great if you can add upload file functionality, so that we can upload at least one pic to the record.[/quote]
    I second it.. :)

  199. satsuke Says:

    Good plugin!! but can you adding captcha?

  200. satsuke Says:

    ah sorry, Its a plugin for administrator. then can you make a plugin like this but that for users?
    I want make a page that user can make post to my site.

    thanks you!

  201. Byron Bennett Says:

    ShareKnow, I’m not sure where development of the Flutter plugin for WP is right now, but I think they’ve got many of those features. It’s going to be a while before I can get those added. :(

    satsuke, yeah…sorry, it’s for Admins right now. You might want to check out my PhotoSmash plugin that lets your users upload images, you can also add custom fields and create custom forms that do not have a file upload field. I do have a companion plugin to PhotoSmash called PhotoSmash Extend that will create a new post when a user uploads. It uses the custom layout feature of PhotoSmash to let you design what the post should look like and where to put all of the field information. PhotoSmash is free, but I’m charging $25 for PhotoSmash Extend. If you want to try it, load up PhotoSmash first and make sure it works on your system/theme properly and then send me an email for PhotoSmash Extend and I’ll get you set up.

    Cheers to all!
    Byron

    BB

  202. Moor Says:

    Hi, Byron

    Thanks for that plugin, it might be very useful for me if it’ll work :)

    I’ve got 0.1.62 version on my WP 2.9. Everything seems OK, all DB fields created and filled properly (both for plugin and post), I can see HTML content of snip in my post, but there no fields content. I thought it’s because of cyrillic characters in field’s label, but changing it gave no fix. Looks like plugin “can’t see” existing data in post’s meta.

    Any ideas please?

    Regards, Moor

  203. Byron Bennett Says:

    Hi Moor,

    I know the plugin has had problems with non-English languages in other areas, but not sure if this would be one. It would seem that if you’re using the same field names, the pre-existing data would work.

    I’m afraid I’ve been away from this plugin for so long I don’t have any suggestions on how to fix. Sorry.

    If it doesn’t work with new posts and new data, it’s probably an encoding issue. If Supple Forms doesn’t work out, you might look at GravityForms or Flutter. Gravity has a fee, but might work for you.

    Sorry I wasn’t much help,
    Byron

  204. Michael Says:

    Hi Byron,

    Thanks for the plug in. Had a quick question. I see that you have the ability to execute php on the drawing board, but was wondering if you could lend me any suggestions in the mean time.
    Im trying to use supple forms to generate different shortcodes for the NextGen Gallery on template pages. This way, the client can make a new page for each gallery. Their shortcode I’d be using is [imagebrowser id=1'], with the id changing in the supple form.

    In order to get shortcodes to work though in template pages, i need to use
    So when I use that script for the Supple Form Shortcode, I am left with just the supple form results, that also need to be run through that same script (for the NextGen Gallery).
    Do you have any suggestions for me?
    Thanks so much in advance for the help.

    Best,

    -m

  205. Bru Says:

    Hi, and thanks for a good plugin for wordpress. I am just wondering, is there any trick I can use to let all my post include the snip on top or something? So I don´t need to paste the code for each post?

    It would help a lot.

    Sorry my bad english..

  206. Byron Bennett Says:

    Michael,
    I’m not sure how that would work…sorry. If you want to execute a shortcode in a template page, you need to add PHP like: < ?php echo do_shortcode('[imagebrowser id=1]'); ?>

    So, if you can figure out that ID # in PHP, you could make it:

    < ?php echo do_shortcode('[imagebrowser id=' . $the_id . ']'); ?>

    Not sure if that helps, but it’s all I’ve got at the moment.

    As for Supple Forms, I’m recommending people either use Gravity Forms, Flutter, or PhotoSmash depending on what you need to do. Each of these plugins does something slightly different, but each does them well.

    BB

  207. Byron Bennett Says:

    Bru,

    The only way to do that at the moment would be to put some PHP in your template page…something like:

    < ?php echo do_shortcode("[supple snip='address_box']"); ?>

    Nothing in SF will add automatically.

    BB

  208. Bru Says:

    Thanks a lot, that did the trick. I love this plugin:-) Keep up the good work.

  209. Ghalt Says:

    Love the plugin! I’m building a site for some less-than-technical folks, and this will be a godsend.

    I’ve run into the problem with the quotes getting the backslashes added. Didn’t see a fix for that yet.

    Also, I want to be able to call my snip inside the shortcode of another plugin. For example (madeup):

    [flickrslideshow set_id="[supple snip='my_flickr_set']” border=”0″]

    The problem is that the flickrslideshow shortcode is ‘closing’ at the first right-bracket.

    Any suggestions?

  210. Byron Bennett Says:

    Bru,
    Thanks!

    Ghalt,

    Thanks! On your shortcode issue, you might leave the brackets out of the flickrslideshow shortcode and add them in your code if you’re calling the shortcode manually with a do_shortcode…

    do_shortcode(‘[' . $set_id . ']‘);

  211. Content Management « A DotNet Intellectualism Says:

    [...] February 23, 2010 — Ashok Kumar Supple Forms Supple Forms for WordPress offers two significant functions for your blog. You can build custom [...]

  212. Banna Says:

    for template tag you can use like ordinay custom field retrival.

    ID, ‘room_price’, true); ?>

    —–room_price is my database filed name.

    i think this will help

  213. Banna Says:

    $room_price = get_post_meta($post->ID, ‘room_price’, true);

    echo $room_price;

  214. Bru Says:

    Hi Byron. Just wondering, is there any way to sort post by date field in supple form? I use custom table.

    Brgds. Stian

Leave a Reply