Friday, February 10, 2012
  Search
Support Forum
OK - I must be an idiot :{
Last Post 07 May 2011 02:15 AM by DenelW. 7 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Not Resolved
Lliam Holmes
New Member
New Member
Send Private Message


--
22 Dec 2009 02:34 PM  
This is one of the BEST form makers that I have EVER seen; much less for DNN. It is SO simply to use, layout and validate...yes there is a but comming :}

I am trying to integrate this with salesforce.com for a promotion that is kicking off TOMORROW (yikes!!). I think that I have everything perfect - there is not that much too it... but just can't seem to quite get it...  HELP HELP HELP!

I have a "regular" HTML based form that works perfectly; I am trying to translate this into Form Master so that it is an in-line form that is easy to maintain.

Here is what I have done...
1) create form
2) make sure that on each field that I set the field name to the required field for SalesForce.
3) under Send Value by Option I selected Silent Post and set the Value name
4) added the 3 hidden fields (oid, retURL & lead_source) and set their default values
5) set the form's Silent Post URL (under settings / basic settings)

no joy :{ not quite sure how to troubleshoot - Help "}

Thanks,
Lliam
DenelW
New Member
New Member
Send Private Message
Posts:13


--
24 Apr 2011 07:32 AM  

Please Check out what? I did not see any kind of link.

I am using DNN 5.6.2 and Form Master 2008 2.0.8. You can see the form I am working on at

Here is my problem...

I created the form, and used the field rules to display some fields when others are selected. I used Field Queries in the controls themselves to populate the drop down lists. The tables I pulled from I created using OnyakTech's H2O Forms...but those are not as user-friendly as Form 2008 (at least not for me), so I only used it to create the tables.

Anyway, if you play with the form, you will notice prices come up on the right side when certain fields are selected. I created those fields using the "Label" field type. The only problem is, I cannot assign a label a value. I need these fields to have values so that I can do a calculation at the bottom of the form of everything the client selects.

Also, I can't figure out how to send the whole completed form to a "Review" form. I can't make all the fields labels, because I am unable to do any kind of field queries when they are labels. And the only way I can see to retrieve info is via field queries. But if I use text boxes, it either allows the client to edit it, or if I disable user input, it greys it out.

This is suppose to be just a simple three-step order. Step one, place order. Step two, review the order. Step three, pay for the order. At which point, both the client and the owner get an email notification of the order. That's it. But I can't get past step one.

Code 5
Moderator
Advanced Member
Advanced Member
Send Private Message
Posts:907


--
24 Apr 2011 02:37 PM  

The last upgrade to this forum module make all the existing links hidden. Who knows why. I tried to fix it today and further destoyed the post so I deleted it. I think the link was http://www.code5systems.com/Support...fault.aspx to a Salesforce example but that does not help you. Also this one may have been in there http://www.code5systems.com/support...fault.aspx

I am not sure you can make a shopping cart type of workflow with Form Master. It is really designed to be a data collection aka one way module.

I think jQuery could come to your assistance here if you are familiar with it. Even if you are not, it is really not that difficult to use. For the Review form you could have the first form send session variables to the review form and put them in hidden fields, then use jQuery to populate Labels. On submit the hidden field data would be saved to the DB. You couls actually use jQuery to do the display of the prices and the calculations in the first form as well.

Form Master field ID's are cryptic, you can right click on the page and get the one for Box or Tube dropdown which is dnn_ctr427_FormMaster_ctl_9cf39df146be4ae58d377d5aeb208728
Getting a reference to this in jQuery would be
var boxOrTubeddl = $('#dnn_ctr427_FormMaster_ctl_9cf39df146be4ae58d377d5aeb208728')

 

DenelW
New Member
New Member
Send Private Message
Posts:13


--
24 Apr 2011 11:06 PM  

Thank you. I am going to try to figure that out. Part of my problem is that I am still trying to learn SQL - what the scripts are, where to put them, how to make them execute, etc. How do I use sessions, the difference between field queries and field rules, how to use form queries...and when to use them...so on and so forth. Let alone, using hidden fields and how they work...and now JQuery...lol.

I got a book that is called "Sams Teach Yourself SQL in 10 Minutes"...it lied! I have taken several hours just figuring out how to get some sort of client to work on my computer and upload the tables they use in the book and want me to follow along with. I am still on Lesson 2...lol.

I did not think I was a dummy...but this is really making me feel like one. And my poor client is patiently waiting for me to figure out how to do all this stuff.

Here is an example of what he wants. http://real-post.com/install2.html

My hubby thinks this guy is just using html and posting it to a php application. That is way over my head...lol.

I guess my previous link of the form I am working on vanished. Here it is again. http://titansignposts.net/1/Order.aspx

Code 5
Moderator
Advanced Member
Advanced Member
Send Private Message
Posts:907


--
25 Apr 2011 11:17 AM  
I am busy like most people in the tech field but I could help you with this form if you and your client are willing to let me use it as an example form in the Share your Creative Side forum http://www.code5systems.com/Support...fault.aspx

I would need your current form exported.
A detailed requirements document
Your SQL to create the tables and data you have for the lookup fields.
DenelW
New Member
New Member
Send Private Message
Posts:13


--
06 May 2011 09:56 PM  
Sorry it took me so long to get back. We had major storms here last week. My internet was down for nearly a week, and I have been trying to recover ever since.

I would very much like your help, and would not mind you using it as an example. As long as you explain how you did it so I know how to do it in the future.

How do I get my form to you? I have it exported and downloaded to my computer, so I can attach it and send it to you...but it seems this does not allow attachments or uploads.

I do not know what you mean by the third requirement. Do you just need to know what SQL I am using? I am using MSSQL.
Code 5
Moderator
Advanced Member
Advanced Member
Send Private Message
Posts:907


--
06 May 2011 11:45 PM  
You can send to c5.cust.service at this domain

I need the Scripts to create your table(s) and an export of the data probably in Excel, CSV or Tab format.

This may take a while for me to get to but I will I promise.
DenelW
New Member
New Member
Send Private Message
Posts:13


--
07 May 2011 02:15 AM  
I just sent you an email. I did not know your name, though. Anyway, I included a zip file. Let me know if you need anything else. I also included my phone number. Please call me. Thank you so much for your help with this.
You are not authorized to post a reply.

Active Forums 4.2
Copyright 2004-2012 Code 5 Systems, LLC.