FormAssembly.com Support Forum - All Discussions

Workflow question

mllb — Fri, 20 Nov 2009 22:44:23 -0600

I have a form that we use for registering players for a baseball league.

Currently I ask for all the parent information then have "add another response" for each additional child beyond the first player registered.

The biggest problem with this for my application is when exported as a csv file all the data is on one line and is time consuming for me to break the responses apart into single entries. I do not want to have the parents fill out their information again by filling out another form for each child they are registering. It seems that the workflow is precisely the cure for this but I have been trying to figure out a way to make it work correctly for our use.

Upon completing the information needed for the first child is there a way to have them either click "submit & Pay" or "Add Another Player". If "Submit & Pay" clicked they are then redirected to PayPal with the appropriate charges for the number of players they have registered thus far in the workflow. And of course, when clicking "Add Another Player" the common information is copied to the next players registration form?

Any suggestions would be greatly appreciated.

Validate numerical range

dbuschho — Wed, 18 Nov 2009 14:52:47 -0600

Validate a field within a numerical range

use by:
Including the code content in your custom code block. Then add binding code like the one shown below into your custom code block, in order to link the validation to a given FormAssembly field. Note the order of parameters is field_id, largest_value, smallest_value.

example:
http://www.tfaforms.com/127819

code:

FormAssembly Forms / WordPress Plugin

dbuschho — Tue, 16 Dec 2008 17:09:47 -0600

There have been requests for a plug in to integrate FormAssembly forms with WordPress blogs. We have now designed a (beta version) plugin that will integrate the two. If you would like to help us out by testing it, please open a support request with the subject 'wordpress plugin'.

The usage format once installed is installed:
[[formassembly formid='NNNN']]

We'd also like to hear any ideas or suggestions on how to improve this plugin, or our integration with other CMS systems out there.

Confirm submission

Boomoirs — Wed, 13 Aug 2008 17:58:42 -0500

Hello
I'd like to use a form to enable people to create a small text advertisement. To prevent mischevious behaviour I'd like anyone submitting an ad to have to confirm the submission automatically ... much the same way as one uses double opt-in for collecting subscribers to a newsletter. Can I do this with FormAssembly?
thanks,

Email you when you get someone reply with the form.

Zach.Lundy — Mon, 16 Nov 2009 17:10:59 -0600

Like when someone on your website contacts you, you should get a email saying like you have a message waiting.

Thanks

Anyone Got A Solid Example of Using the HTTP Post Connector with PHP/MYSQL?

lifestyle — Mon, 16 Nov 2009 00:10:07 -0600

Has anyone got a solid example (step by step, assuming the user knows PHP and MYSQL) of how to use the HTTP Post Connector to send variables to a script I host so I can stick the data in my database? I don't get what I need to to have in my script and how I answer back to the Form Assembly mechanism when I have saved my data and am ready to complete the process...

Basically, I LOVE form assembly for the simple approach to complex forms but it is imperative that I capture the form data in my own DB and I just cannot seem to get all the pieces of the puzzle from the docs and this forum.

Anyone with some experience and a sample script would gain Karma by sharing with me and others with this challenge. I pledge to post a script here when/if I get to understand how this works and can get my script to work.

Speed Up Form Snippit Embedding? (Pages Laaaaaaaaaaaaaag)

lifestyle — Mon, 16 Nov 2009 00:04:06 -0600

I have a simple form that I have embedded into a php page. Since copying in the form, the page loads very slowly as it downloads all the dependent scripts etc...

Can I download all the dependent scripts to my server and run the form using those scripts... still having it point back to FormAssembly when users submit it? This would speed up my pageload.

Is this allowed? Has anyone else done this before?

Any Way To Change Error Box For Incomplete Form?

lifestyle — Mon, 16 Nov 2009 07:26:11 -0600

I am embedding a form in some i-framed sites and notice that when an incomplete form is submitted, a slick little javascript error box pops up to tell the user how many problems were found with their submission. This is great BUT can I change the dialogue that references the calling site?

Right now, it says "The page at http://www.myserver.ca says:" I would like to either remove that line or modify it with a variable or otherwise customize it?

Is this possible and if so, where do I look for the source?

Thanks.

Using wForms with php and MySQL

Nouri — Fri, 25 Apr 2008 09:22:15 -0500

Hi,

I'm looking for some code-examples, any help appreciated;

So far I have only created auth and email forms using php and mysql in my web-life, and did that working from existing examples, which went easy for me because I understand the basics of many different programming languages and their syntaxes. However, now I need to create some fairly complex webforms for some people, and I bump into a lot of issues that are not so easy to find examples for.

The intention is to make certain parts of a large MySQL database easier to add new records to, and/or change them, and for that I have to create some webforms. One important thing is that they want me to put many form actions on just one page, with one submit button (that is how I got the idea to use a conditional wForm script). For now let's assume all related fields are of the varchar(128) type to keep it simple.

(Restricting access is not an issue (I have that down) because it works outside of the form using a cms-type thing, giving access for the form only to those that are allowed to add or change records etc.)

Let me describe some of the involved structure and actions I need for one of the forms, because when I get one done (with help of some example code from you perhaps), it's easy for me to understand and create more out of it;

In an existing (and already populated) TABLE_X the user needs to add a new record to field_x
but I need to check if needed field_x already exists, if it does, it should be selected from the database and query and echo a lot of contents under that form entry,
if it does not exist it should be (as filled in a textbox by the user) added to MySQL and then continue further down the form.
Aside from this, whatever the user has picked (picking an existing one or filling in something new) ALSO needs to go into field_y which resides in TABLE_Y and in field_z residing in TABLE_Z (but this happens hidden from the user).

In the same form-page I then need to have a dropdown box showing the records in field_a from TABLE_A but show only those records in the dropdown for which field_b (from TABLE_A) has values (record) xx and yy.
The user selected item from field_a should be added as field_h which resides under TABLE_H

Then I have a couple more that are similar to this on the same page. Basically I need a complete example (including where I need to put the include for the connection to the database) so I understand how to create the user selects existing or adds new record issue in a webform, plus I'm at a total loss on doing the cross table writing and reading in one form.

If anyone could provide a simple example using the exact table and field names mentioned in my puzzle above, I'd be on my way and very thankful!

Thanks!

Nouri

Email validation

strangepl — Tue, 20 Nov 2007 16:48:08 -0600

Hi folks,
I would like to validate email addresses on a form i.e. type an address in twice and validate that they are the same constructed in a propper format. Is this possible? By the way formassembly is absolutely fabulous and has blown me away big time. I am a 4 hour old member.

Regards,

strangepl

Can I use this API to create a form with form assembly?

repairdental — Thu, 12 Nov 2009 16:53:05 -0600

I have Form Assembly pro account. I am also using a hosted ecommerce solution by bigcommerce.com
They have an API. I would like the invoice info for each customer to be sent to Form Assembly using the bigcommerce API. This invoice info would be turned into a form and emailed to the customer's email address and to a third party fulfillment company. I would like to remove some fields such as "price" so it doesnt show in the new form.

Can you let me know if this is possible and if so, how can I implement it?

Thanks in advance,
Jim

Here is a link to the
the Bigcommerce.com API PDF documentation. http://www.bigcommerce.com/pdf/Big_Commerce_API_Guide_1.0.pdf

Multiple Responses

Education@Roundabout — Thu, 12 Nov 2009 14:52:43 -0600

I am trying to enter a whole set of responses into a form I built. However, after I enter the first one I get the "this form has already been submitted" error message. I don't seem to have a "reload" button. What can I do get around this problem?

Repeatable answers

Oasis — Mon, 09 Nov 2009 23:23:45 -0600

We are developing a Loan Application form where there my be multiple borrowers.

My question is: Where applicant 2 has the same address details as Applicant 1 is there a way for populate the fields for applicant 2 with the details from applicant 1?

Non Printing Fields

Oasis — Thu, 12 Nov 2009 01:17:24 -0600

Is it possible to identify a field so that it won't print? As an example we may have a broker complete an application form for a client and in presenting that application to a funder we don't want the original brokers name on the printed form.

Move the placement of next/previous buttons

st8 — Mon, 14 Sep 2009 15:43:05 -0500

Hello, I am using a mult-page form on my own site from the source code.

How can I separate the next/previous buttons? I would like to be able to move the previous button to the top of the form.

Please help. Thanks,

Steven

Conditional Questions

Oasis — Mon, 09 Nov 2009 03:39:38 -0600

Is it possible to have an entire section appear based on a selection. For example we are developing a loan application. Because there may be multiple applications if a user clicks a button saying there is an additional borrower it would be great to have the section with all the 2nd borrowers questions appear.

Graham

Calendar related javascript

dbuschho — Mon, 09 Nov 2009 12:27:04 -0600

Two calendar related javascript functions that have been asked for:
1. Age calculation from date of birth calendar field

use by:
setting DOB calendar field to variable (example: _DOB)
in a new hidden text field add the formula: _calcAge(_DOB)
the field will be set to the age in years of the text field rounded down to the nearest year.

example:
http://app.formassembly.com/126030

code:

--------------------------

2. Validating one calendar as older than a second
use by:
adding code into custom code block
then adding a new script block like:

where tfa_Date1 is the id of the first calendar field, and tfa_Date2 is the second which must be older.

example:
http://app.formassembly.com/126048

code:

-----------------

Forms and identifying duplicate Salesforce records

mlongshore — Tue, 03 Nov 2009 15:59:51 -0600

Hi everyone,
Is there a way for FormAssembly to identify an existing record in Salesforce and update that record (e.g., when someone fills out a web form but they're already in Salesforce as a contact)?

Thanks for your help!

I'm having problems reading my replies.

vickielane — Fri, 06 Nov 2009 12:33:21 -0600

Everytime I try to read them it keeps asking me to login. I've logged in about six times and I keep getting kicked off. Can someone please help?

Thank you !
VICKIELANE

Limiting the number of form submission?

xero.simonp — Thu, 05 Nov 2009 18:52:39 -0600

We would like to create a signup form for an event we plan to run and Form Assembly seems to tick all the right boxes functionality wise with just one exception... we need to limit the amount of attendees. Is there a way to limit the amount of respondants? Perhaps by disabling the form when a certain number of submissions have been made?

Customizing the body of email notifications

jlanceho — Mon, 02 Nov 2009 15:03:00 -0600

Hi,

I would like to customize the body of email notifications so that they take up less space. My current form prints from Outlook onto 3 pages, and that is way too many. Is there a way I can customize the HTML that is sent in the email notification?

Thanks,
Jeremy

Usernam change

thefatjeweller — Tue, 27 Oct 2009 16:26:51 -0500

Would you please change my username to thecurvyjeweller as I have had a business name change. Many thanks :)

Agregate report not reporting correctly

thefatjeweller — Mon, 26 Oct 2009 21:56:07 -0500

My agregate report shows some answers as "not answered", but the customers have answered the question. Can anyone help plse?

For Homepage quirk - can this be fixed?

martin.hawes@suntrust.com — Mon, 26 Oct 2009 07:23:11 -0500

I like the new home form page. Having a method to group the forms is real nice. I have notice each time I change my view however, all the groups I have collapsed get expanded again. This is REAL annoying. Is there any way to have the browser remember what I have collapsed and what is expanded? Otherwise, what is the point of having that functionality if it just gets reset to expand all on each page change?

Saving form error : "String could not be parsed as XML"

orsuser09 — Mon, 26 Oct 2009 05:18:06 -0500

Hi there,

While editing a form and trying to save it, I received the following error: "String could not be parsed as XML". I have changed the title of the form, some questions inside it and a picture attached to it, and I have done that before with no problems whatsoever, yet now I am incapable of saving the form.

Do you have any idea why this is happening or how can I solve the problem?

PS. I also have to mention I am in a sort of a rush, so any quick reply will surely be appreciated!

Thanks,
Andrei

Email being shown as user in forum

martin.hawes@suntrust.com — Mon, 26 Oct 2009 07:25:25 -0500

How do I change my displayed ID in the forum from my email address to something else?

PayPal

ArunMurugavel — Fri, 23 Oct 2009 10:55:20 -0500

Is it possible to associate a different paypal account with each form?

New form home page

dwilson@cchit.org — Thu, 22 Oct 2009 17:09:39 -0500

I appreciate the fact you guys are actively working on the application, but the new form home page is a loser.

The organization of the forms on the left side of the page is a regression from the previous layout. The pop-up menu is pretty much useless. The overall layout uses too much vertical space, while under-utilizing the horizontal space.

I prefer the previous layout of the form home page.

Is anyone having problems with people NOT being able to access forms when using IE 8?

AHIMA — Thu, 22 Oct 2009 15:37:40 -0500

I'm testing my form and it seems that I can view my form using just about any other browser, including from my Blackberry and iPhone, but am having problems with IE8. Any thoughts?

Duplicate text (add another" on Multiple item forms (embedded form)

artofweb — Thu, 22 Oct 2009 08:46:13 -0500

I created a simple contact form and inserted it into my CMSMS site. It worked.

Next I created a simple form with the option to add fields for multiple responses and inserted it into a new page in CMSMS. see here:

http://174.132.89.162/~artofweb/cms/index.php?page=content-questionnaire

As you can see, there were multiple "Add another response" texts shown.

Also, they were always shifted far to the right and I was unable to bring them left.

Any ideas on how/why the "add another" text is repeated and andy ideas on how to set the div width to <975px?

Cheers,
Marc