close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Guestbook?

Thread began 10/23/2012 10:44 am by Martin | Last modified 10/25/2012 2:18 pm by Jason Byrnes | 1169 views | 5 replies |

Martin

Guestbook?

Greetings. I have had a request from a client to create a Guestbook for a website. Any suggestions or ideas on how I would do this with PowerCMS builder. Can it be done?

Or do you have any other ideas that you would recommend?

Thanks,
Martin

Sign in to reply to this post

Jason ByrnesWebAssist

Power CMS Builder for a guest book is a bit like using a 50 pound sledgehammer to hang a picture.

all you really need is to use Data Assist insert record.

create the guest book form. Then add the insert record behavior to save the entered data to a table.

Sign in to reply to this post

Martin

LOL!

Do you have a tutorial on how to do this? I imagine, I need to create a bunch of database fields in the Power CMS DB, then add in all sorts of show/hide events and post approval etc.

Thanks again,
Martin

Sign in to reply to this post

Jason ByrnesWebAssist

a guest book is really just a simple insert.

a form that allows the users to enter their name or other data you wish to collect and stores that in a guest book table. No need for show regions or post approval, I'm not sure where that comes from.

perhaps you are trying to create something other than a guest book, but in my expieincek, a guest book is just used to capture information about users that visit your site.

Sign in to reply to this post

Martin

Thanks for the feedback Jason! Much appreciated!

The guestbook I would like to create is similar to this one.

guestbook-2/

I would like to have who it was posted by, the time, the comments and URL if applicable.

I would also like to have the post stay pending until I approve it. That way saving on people spamming and posting negative stuff.

Do you have any suggestions as to how to go about this using WA tools? (which I own everything of course!)

Thanks again, I really appreciate it!

Sign in to reply to this post

Jason ByrnesWebAssist

you would need a table with columns for time, the comments, URL, and status.

set the default value for status to 0

create a form with a elements to enter the comments and URL

since the status is set to default to 0 (we'll use that for pending) new entries will automatically be set to pending.

on the page where you show the entries, use a where clause to only show entries where the status is = 1.

you would create an admin page where you can review all entries where the status is 0 and update them to 1 if you wish, or delete them if they don't pass your inspection.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...