David Amm
river guide Posts:156
|
09-14-2009 04:29 AM |
|
I am trying to build a single form to allow customers to order multiple products each with a custom configuration! Each product has complex specification parameters (e.g. product type, value add options, other values). Is this possible? |
|
|
|
|
David To
river guide Posts:2719
|
09-14-2009 06:54 AM |
|
Yes, you could create a combobox/listbox to display a listing of products and depending on which option they choose, trigger question events based on those options. -- David |
|
|
|
|
David Amm
river guide Posts:156
|
09-14-2009 07:24 AM |
|
I'm using client side events to customise the configuration for each product. That part is working well.
The problem is how to add multiple such products on one form (i.e. one customer may choose to purchase 5 products at a time and each one has a different spec).
Could I use the new grid question type (i.e. allow user to add multiple product records on a signle form)?
|
|
|
|
|
David To
river guide Posts:2719
|
09-14-2009 08:03 AM |
|
HI, you could use the datagrid to continually add records but it will save the data in HTML table format and since the datagrid being a new field datatype, we don't know an easy way to use javascript to access the data for manipulation. -- David |
|
|
|
|
David Amm
river guide Posts:156
|
09-14-2009 09:26 AM |
|
An alternative might be to have 2 separate forms (customer details and product details) that post to custom tables in the database. I could add form completion events posting the results and linking the forms. Is there a way to assign a unique identifier for a form? |
|
|
|
|
David To
river guide Posts:2719
|
09-14-2009 10:00 AM |
|
Yes, use the token $(UniqueCompletionID) when writing to your tables. -- David |
|
|
|
|
David Amm
river guide Posts:156
|
09-15-2009 07:23 AM |
|
Demo 21 shows how you can combine Dynamic Forms with Indoo Grid. What are the benefits of using them together? |
|
|
|
|
David To
river guide Posts:2719
|
09-15-2009 07:46 AM |
|
Well, IndooGrid and Open Web Studio are a listing program so users or yourself can see a list of inputs. Dynamic Forms does have a "View Form Results" that you can export to excel but the view is not customizable like a listing program, etc. -- David |
|
|
|
|
David Amm
river guide Posts:156
|
09-15-2009 11:33 AM |
|
I've managed to create my first form (CustomerDetails) and pass the results plus UniqueCompletionId to a custom table. Now I need to pass this UniqueCompletionId (my CustomerId) to a second form (ProductDetails). How do I do this? |
|
|
|
|
David Amm
river guide Posts:156
|
09-16-2009 03:54 AM |
|
Now I have two forms talking to each other. The unique identifier is created in the database and retrieved in form 1 as a field value by means of sql script. The identifier is passed to form 2 as a session variable - so far so good! My challenge now is how to use this session variable in a sql query in the DNN Reports module. My grid binding is a select * where Id = session variable. How do I access the Dynamic Forms session variable from the DNN Reports module? |
|
|
|
|
David To
river guide Posts:2719
|
09-22-2009 09:43 AM |
|
HI David, I'm not sure if the DNN Reports module can accept session variables. You may need to do some research on their website forum to determine if this is possible. -- David |
|
|
|
|