http://www.perfectforms.com/forums/ Forums for the PerfectForms.com Application en Wed, 08 Feb 2012 02:53:54 +0000 http://www.perfectforms.com/forums/topic/wrap-text-in-table#post-2240 Wed, 22 Jun 2011 22:51:17 +0000 Dennis @ PerfectForms 2240@http://www.perfectforms.com/forums/ <p>Yes it is still not available. One solution I employed was to show a message with the contents of the field when the field is clicked.<br /> <a href="http://www.perfectforms.com/">Workflow software, </a><a href="http://www.perfectforms.com/">Process software, </a><a href="http://www.perfectforms.com/">Procedure software</a> </p> http://www.perfectforms.com/forums/topic/wrap-text-in-table#post-2239 Wed, 22 Jun 2011 21:17:08 +0000 kmiyahira 2239@http://www.perfectforms.com/forums/ <p>Is word wrapping still unavailable for tables? </p> http://www.perfectforms.com/forums/topic/drop-down-in-a-table-populate-with-connector#post-2160 Mon, 09 May 2011 17:08:43 +0000 Dennis @ PerfectForms 2160@http://www.perfectforms.com/forums/ <p>It is not possible to populate a drop-down in a table using a connection. </p> http://www.perfectforms.com/forums/topic/drop-down-in-a-table-populate-with-connector#post-2159 Mon, 09 May 2011 04:35:01 +0000 mrordaz 2159@http://www.perfectforms.com/forums/ <p>anyone has example for this? I am also having problem with this. Please send me also the example. thanks. </p> http://www.perfectforms.com/forums/topic/on-submit-form-send-link-to-child-form#post-1525 Mon, 21 Jun 2010 13:35:25 +0000 capson 1525@http://www.perfectforms.com/forums/ <p>Hello Steph, </p> <pre><code>I went with a slightly different approach. I made a &quot;sub-form&quot; (3 hidden pages on the main form) and with a copy fields behavior pulled the data into this compact rendering of the survey and used a work flow to a next stage called reporting and set the form to open to the sub-form (i.e page 15) when the form opens when the stage is reporting and sent a email out with a notification behavior to the consultant with a link to the form, now when the consultant clicks on the link they will only see the &quot;sub-form&quot;.</code></pre> <p>Hope this helps. </p> http://www.perfectforms.com/forums/topic/on-submit-form-send-link-to-child-form#post-1524 Mon, 21 Jun 2010 07:55:19 +0000 Steph 1524@http://www.perfectforms.com/forums/ <p>Capson, did you work this out successfully? It sounds like what I need to do.</p> <p>Thanks. </p> http://www.perfectforms.com/forums/topic/connect-and-search#post-1482 Mon, 07 Jun 2010 08:24:02 +0000 ajobling 1482@http://www.perfectforms.com/forums/ <p>If you use a Connect command rather than a Connect &#38; Search command, the lookup will run in the background and can populate form(2). </p> http://www.perfectforms.com/forums/topic/connect-and-search#post-1481 Sun, 06 Jun 2010 13:44:39 +0000 capson 1481@http://www.perfectforms.com/forums/ <p>I have a Survey form(1) and a lookup Table form(2) that I want to use to auto populate form's(1)census data when a email address on form(1) matches a email address in form(2)(form(2)has only unique entries). To this end I made a connect and search command this works but I need to suppress the popup window and just go directly to populating form(1) fields with the returned data.<br /> Is this possible I have looked for a way to do this but can not find how.<br /> Thank you<br /> Tim </p> http://www.perfectforms.com/forums/topic/closed-stage#post-1473 Tue, 01 Jun 2010 14:00:11 +0000 capson 1473@http://www.perfectforms.com/forums/ <p>Thank you for the response, I got the above to work but only if I submit the form again, so I added a behavior to the form open event that checked for the closed stage, this all seems to work, am I miss understanding what you wrote though given I have to resubmit the form to get it to show up in the closed Instance folder of my form? </p> http://www.perfectforms.com/forums/topic/closed-stage#post-1470 Fri, 28 May 2010 21:37:54 +0000 CJ Hines 1470@http://www.perfectforms.com/forums/ <p>Thats fine, but now you must have a trigger on form1 in the text field: when "Stage name" changes field data(&lt;- behavior) and = Closed out (&lt;-text) then 'set next stage' is closed stage.</p> <p>Lets recap:<br /> If textbox on form1 = "Closed out" then 'set next stage' dropdown to closed stage.</p> <p>PF Support </p> http://www.perfectforms.com/forums/topic/closed-stage#post-1469 Fri, 28 May 2010 17:00:01 +0000 capson 1469@http://www.perfectforms.com/forums/ <p>I have a form(1) and a table form(2) form which I add data to the open instances of the first form(1), I would like to close out the first form(1) from the table form(2).<br /> To this end I have tried a "set field in other instance" behavior like so:<br /> Form = form(1)<br /> Form Field = "StageName"<br /> Form Instance Id = myinstancefield<br /> "Text or Number" = Closed Out (closed stage setting name.</p> <p>Not working<br /> Thanks </p> http://www.perfectforms.com/forums/topic/table-button-behavior#post-1451 Thu, 20 May 2010 08:54:59 +0000 ijobling 1451@http://www.perfectforms.com/forums/ <p>Look at the Set Table Rows function, where you can 'iterate' through all the rows in the table to do this </p> http://www.perfectforms.com/forums/topic/table-button-behavior#post-1449 Wed, 19 May 2010 17:10:48 +0000 capson 1449@http://www.perfectforms.com/forums/ <p>I have a table in P.F that trough a connection gathers information on finished and submitted surveys, then I need to send values back to the forms depending on this data.<br /> To this end each row of the table has a button with "set field in other instance" behaviors beneath it.<br /> Is there a way to run the button "is clicked behavior" for the entire column through a single button at the bottom of the table.<br /> I have tried but can find no way to execute the table buttons programmatically.<br /> Thanks </p> http://www.perfectforms.com/forums/topic/form-instance-number#post-1440 Tue, 18 May 2010 19:12:09 +0000 capson 1440@http://www.perfectforms.com/forums/ <p>Thanks tmrhymer, was not quite as convoluted in the doing as in the reading, again thanks for taking the time to write out the explanation works very well!!!!<br /> Tim </p> http://www.perfectforms.com/forums/topic/form-instance-number#post-1439 Tue, 18 May 2010 18:25:00 +0000 capson 1439@http://www.perfectforms.com/forums/ <p>Thanks, this is my situation and it dose sound kind of convoluted, but I will work my way through your explanation.<br /> I got part way there using Ian explanation above but was not able to get all the parts and from your description probably would not have gotten there on my own.<br /> Thank you<br /> Tim </p> http://www.perfectforms.com/forums/topic/form-instance-number#post-1438 Tue, 18 May 2010 16:27:46 +0000 tmrhymer 1438@http://www.perfectforms.com/forums/ <p>If your forms go to a closed stage immediately after the first submission (which some of mine did) you will need to handle it with something like this. This was a solution given to me by one of the pf techs.</p> <p>This will require one "hidden helper" text input field (txtFormSubmitted) to work correctly, with a default value of 0. In the form is opened event, at the beginning, you will add a simple branch that checks if txtFormSubmitted is equal to 1. If that is false, than just connect that to the normal behaviors you would want to run when the form is opened. If that is true than connect the branch to a run behavior command. This run behavior command should be set to run the behavior of your submit button.<br /> Next you will need to modify the behavior of your submit button. For this, your submit button must be a regular button with a submit behavior so that you can add these extra behaviors. In your submit button is clicked event you will need a simple branch. That simple branch will check if txtFormSubmitted is equal to 0. If that is false, you will connect it to a set field command that sets txtFormSubmitted = 2. If that is true, you will connect the branch to a set field command that sets txtFormSubmitted = 1. After setting it to 1, you will want a set next stage command and set it to your first (default) stage. After that, add a Submit Data command with "Re-open Same Instance" checked.</p> <p>So what you will end up with is the form first opens, and txtFormSubmitted will be set to 0, and your normal "form is opened" behaviors will execute. Then when the user submits the form the branch will see that txtFormSubmitted is set to 0 and will then set it to 1, set next stage to the default stage, and submit the form and re-open the instance. You will see the form open after it submits, but it happens very quickly. When the form re-opens, the branch you set up in the form is opened behavior will re-run the submit button is clicked event. This time the branch will see txtFormSubmitted is not equal to zero and will set it to 2. It has to set it to something other than 0 or 1, or the next time you open the form it will not work properly. After you set txtFormSubmitted to 2, you can add a set field to capture your form's instance name.</p> <p>This will allow you to capture it at the first stage. I hope that makes sense, it's kind of hard to describe. It may sound kind of convoluted, but I've built that into all my forms and it works very well. </p> http://www.perfectforms.com/forums/topic/form-instance-number#post-1437 Tue, 18 May 2010 12:49:59 +0000 ijobling 1437@http://www.perfectforms.com/forums/ <p>Run your 'set field' script when the form loads in the next stage. The instance number is created when the form is submitted, so if you are running this BEFORE the submit (as you seem to be) it will do what you are seeing </p> http://www.perfectforms.com/forums/topic/form-instance-number#post-1436 Tue, 18 May 2010 10:54:40 +0000 capson 1436@http://www.perfectforms.com/forums/ <p>Say I just read another post from a month ago were you explained that the Instance Name and Number are generated at the first submit.<br /> I changed my behavior to run on the forms submit and close(form has only one submit), but still only get 0 as a form instance number. </p> http://www.perfectforms.com/forums/topic/form-instance-number#post-1435 Tue, 18 May 2010 10:41:10 +0000 capson 1435@http://www.perfectforms.com/forums/ <p>Hello, I have a form, on the form a input box, on a form open event a set field behavior &gt; special &gt; form instance number.<br /> All I ever get in the input box is 0, no matter how many instances I make.<br /> Clearly not doing something right.<br /> Thanks </p> http://www.perfectforms.com/forums/topic/set-field-in-other-instance#post-1429 Mon, 17 May 2010 15:12:47 +0000 capson 1429@http://www.perfectforms.com/forums/ <p>Please ignore, its it working, my problem was that I thought the actual field in the form would have data in it but I see that the report has the "set field" data and the export file has the data as well. </p> http://www.perfectforms.com/forums/topic/set-field-in-other-instance#post-1427 Mon, 17 May 2010 12:28:56 +0000 capson 1427@http://www.perfectforms.com/forums/ <p>I have a on going form, it has two hidden field, after the form has been submitted by the client staff go into the form and set the hidden fields to certin values depending on the client who took the survey. Can I make a simple form with two field and a "Set Field in Other Instance" behavior attached to them. I want the filds set remotly so no one has to open the submitted forms to set the values. This seems like a sright forword thing to do but I have not been able to get the "Set Field in Other Instance" to work(nothing happens).<br /> Thanks </p> http://www.perfectforms.com/forums/topic/parent-child-form#post-1397 Tue, 04 May 2010 11:51:18 +0000 capson 1397@http://www.perfectforms.com/forums/ <p>Thanks! </p> http://www.perfectforms.com/forums/topic/parent-child-form#post-1396 Tue, 04 May 2010 11:21:14 +0000 ijobling 1396@http://www.perfectforms.com/forums/ <p>Its not possible to 'get' file attachments from one form into another, but present an option to open the 'survey form' so you can then view the actual form instance and access the uploaded file </p> http://www.perfectforms.com/forums/topic/parent-child-form#post-1395 Fri, 30 Apr 2010 19:33:38 +0000 capson 1395@http://www.perfectforms.com/forums/ <p>Hello, I have a survey form and a table in a separate form from the survey form.<br /> By a connection the table form collects info on the progress of the instances of the survey forms.<br /> An excel sheet is uploaded by the clients in to there survey forms.<br /> Can you think of away to down load the excel sheet from the survey form by an action in the table form?<br /> I have tried but no luck.<br /> Thanks </p> http://www.perfectforms.com/forums/topic/create-new-list#post-1378 Thu, 22 Apr 2010 09:20:56 +0000 ijobling 1378@http://www.perfectforms.com/forums/ <p>Refer here: <a href="http://www.perfectforms.com/Documentation/manual/html/fg_adding_a_list.htm" rel="nofollow">http://www.perfectforms.com/Documentation/manual/html/fg_adding_a_list.htm</a> to understand the function of the Account Resource&gt;List.</p> <p>When you have created your dropdown/list object from your Account Resource&gt;List then you can use them for such functions </p> http://www.perfectforms.com/forums/topic/create-new-list#post-1377 Wed, 21 Apr 2010 18:54:27 +0000 capson 1377@http://www.perfectforms.com/forums/ <p>Hello, if I create a list is there a way to use it in an if statement, if xyz in list1 do pdq, I looked but did not see anything'<br /> Thanks Tim </p> http://www.perfectforms.com/forums/topic/child-form-first-open#post-1330 Thu, 01 Apr 2010 13:26:27 +0000 ijobling 1330@http://www.perfectforms.com/forums/ <p>Very hard to understand what you are trying to say but if you are trying to pass data from a parent form to the child form, first check that this works as you expect.</p> <p>It could be that your logic isn't correct if you are referring to a check box object where the users could be selecting one, two, three , four or all five selections and not related to the 'page is opened' event and so then work on the child form in isolation where you initially replace the 'populated from the parent' with a manual action to populate the field you are trying to run the behaviours on and place your behaviour under a button to invoke them. Then run the form in 'debug' mode so you can then see how your behaviours are running. </p> http://www.perfectforms.com/forums/topic/child-form-first-open#post-1329 Thu, 01 Apr 2010 12:11:18 +0000 capson 1329@http://www.perfectforms.com/forums/ <p>I have a multi page form, on the first page there are 5 check boxes that run behaviors one may chose from 0 to 5 choices.<br /> I am tiring to make this a child form, were from the parent form one may make there check box selection, on the first page open event of the first page of the child form the check boxes are checked and the behavior are executed.<br /> I thought this would be easy to do as I have made other parent child forms, but I an stuck, I can not get the behaviors to execute properly from the page open event, either they wont execute or they execute twice,<br /> I have tried on click, on show, on change data, I have tried all the combination I can think of, the combination of "on open event" and running behaviors has confounded me.<br /> I would appreciate any ideas you have.<br /> Thanks </p> http://www.perfectforms.com/forums/topic/of-fields-allowed-in-a-report#post-1328 Thu, 01 Apr 2010 11:51:22 +0000 capson 1328@http://www.perfectforms.com/forums/ <p>Thanks for the reply, I gather from what you wrote the report has a maximum amount of data it can export, so if I have more rows I will need to eliminate some columns to stay under the maximum.<br /> All my data gos into SPSS,I tried using the csv from the migrate option and this worked very well, I hope I will never have to write another report again.<br /> At some point it seems I will need to get the connection agent as this looks like the best option for exporting data. </p> http://www.perfectforms.com/forums/topic/of-fields-allowed-in-a-report#post-1321 Tue, 30 Mar 2010 13:51:10 +0000 ijobling 1321@http://www.perfectforms.com/forums/ <p>Very hard to say. Consider first what else could have changed since the report was last allowing you to 'export' to then read into Excel? if you are using the ondemand version then it is Mid Jan since there was an update so could that be involved here? if not, then it could be that the size of the data you are trying to download is now too large for what your PC can cope with for some reason and you should consider looking at a different method to work with your data. For instance do you need to export ALL the data (assuming that your 182 fields refer to fields on the form collecting data) all the time? Have you looked at how in a report you can filter to show specific sub sets of the data or how you can set up multiple report fields to present the data in different ways and then instead of exporting one huge file, export out the specific information you need in more manageable quantities. And over all this if you use the connection agent module, how you can use an 'insert' action to write the data out directly to a database table as your users submit the data where they are more capable of working with large data sets </p>