http://www.perfectforms.com/forums/ Forums for the PerfectForms.com Application en Fri, 12 Mar 2010 22:41:08 +0000 http://www.perfectforms.com/forums/topic/wrap-text-in-table#post-1274 Fri, 12 Mar 2010 17:17:02 +0000 capson 1274@http://www.perfectforms.com/forums/ <p>I have a table, the first column is set to text input. They are filled with a set table behavior and a set field behavior. The text is to long for the table, can you wrap the text? Thanks </p> http://www.perfectforms.com/forums/topic/ip-address-from-browser#post-1273 Thu, 11 Mar 2010 10:45:20 +0000 ajobling 1273@http://www.perfectforms.com/forums/ <p>The example form is now available to download from here.</p> <p><a href="http://www.perfectforms.com/Documentation/manual/html/?fg_calling_javascript_from_a_form.htm" rel="nofollow">http://www.perfectforms.com/Documentation/manual/html/?fg_calling_javascript_from_a_form.htm</a> </p> http://www.perfectforms.com/forums/topic/check-mandatory-not-working-in-read-only-and-previously-hidden-fields#post-1272 Wed, 10 Mar 2010 16:48:42 +0000 tmrhymer 1272@http://www.perfectforms.com/forums/ <p>I agree with keeping things simple, but I also want to take away as much possibility of error as I can, and if theres a way to screw something up the users will find it. </p> <p>Following with the set field command will work. I didn't know you could use it like that with a dropdown. Just had to turn off errors for a connect command but thats great!</p> <p>I still think it would be a nice feature to be able to set a property for a field as its "default" value and if check mandatory is run on that field it would test if its equal to that default value. If it is than the user would be notified and have to fix it. </p> http://www.perfectforms.com/forums/topic/check-mandatory-not-working-in-read-only-and-previously-hidden-fields#post-1271 Wed, 10 Mar 2010 16:07:56 +0000 ijobling 1271@http://www.perfectforms.com/forums/ <p>I would work on the premise of K.I.S.S myself and probably wouldn't look to over complicate things by changing properties of the object although I can see that may have some benefits.</p> <p>Adding a red * is a very effective way of highlighting to users visually that a field HAS to be answered (in this case the dropdown and not the fields that are populated from the selection of the dropdown that may be hidden/read only), supplement that with a conditional script based on the 'selection made' and/or even use the 'mandatory answer' setting where you can define the specific message to present referring to the object they have to complete (you will need to publish to see how this works, it won't show in 'preview' but check that out on a simple test form to see how it works </p> <p>as to the drop down itself, that you are populating from a connect action. Have you looked at following the 'connect' action with a 'Set Field' action to the drop down where you set the value to &lt;nothing&gt; </p> <p>I'd suggest setting up a simple test form where you can populate the dropdown similar to you have here already but then add on a button and under that button add a 'set field' to set the 'caption' of the dropdown and then in the value section.. select 'text or number' and add in a SPACE to the entry field, and then preview the form, get the drop down to populate (ie as you see at the moment) but then run the script under the other button to see how it sets the drop down to 'not selected' and then your 'check mandatory' will do what you want </p> <p>Also though in terms of finding the most appropriate methods and seeing things like this, use the same 'simple test form' premise to check out other options. It can be easier to see how things work but also if you then have something that you think isn't correct a lot easier to send over to us with details of what you see, what you want so we can see more clearly as well. And if there is something we can see that isn't correct, getting that 'example' to the developers to check out is also then a lot easier </p> http://www.perfectforms.com/forums/topic/check-mandatory-not-working-in-read-only-and-previously-hidden-fields#post-1270 Wed, 10 Mar 2010 14:55:28 +0000 tmrhymer 1270@http://www.perfectforms.com/forums/ <p>Sorry, I didn't explain the relationship of the drop down field to my read only fields very well. The dropdown field is not read only. It's given a list of options from a database connect command and the user will select one of those options. When the selected index of the dropdown changes, that calls a behavior to "load" values into the read only fields. So they are editable in an indirect way. However, I couldn't use a check mandatory on my dropdown because when they are populated by a connect command the system doesn't prepend a blank option the same way a dropdown would that had manually entered options or if it was tied to a predefined list. In another case, my forms have a "customer select page" and after they select a customer a bunch of read only fields are given values through a connect command. I need to make sure the user has selected a customer. The way they select the customer is through a table that displays results from a query to the user, the user will then click a select button for the row of the customer they want and that will fill the read only fields. You describe using a "condition based on the selection made" and then running either a check mandatory or a show message. I can see how I would get a show message to work although I would like to avoid that because then I would have to manually change the border color of the fields to signify to the user that action needs to be taken on those fields. I don't see a way to do it with a check mandatory since by default the dropdowns will be set to a value if i fill them with data from a connect command. I'm not trying to be difficult, but right now I'm going through the system before the rest of our form builders to establish some standards and I'd like to find the most straight forward method for these things as possible. </p> http://www.perfectforms.com/forums/topic/check-mandatory-not-working-in-read-only-and-previously-hidden-fields#post-1269 Wed, 10 Mar 2010 13:09:14 +0000 ijobling 1269@http://www.perfectforms.com/forums/ <p>This is 'expected' in that Read only fields will not be checked from the Check Mandatory Command just as Disabled and Hidden fields won't either. But I can see how this isn't clear from the user guide and will refer this to be reviewed and updated for the future </p> http://www.perfectforms.com/forums/topic/check-mandatory-not-working-in-read-only-and-previously-hidden-fields#post-1268 Wed, 10 Mar 2010 10:29:29 +0000 ijobling 1268@http://www.perfectforms.com/forums/ <p>Still can't grasp why you want to run a check mandatory on a read only field and especially on a drop down ? even if it was 'not answered' and this 'check mandatory' ran , the fact that it is read only will mean they can't do anything and won't be able to submit the data.</p> <p>its like setting 'check mandatory' on a hidden field... if it fails the user will just see the 'mandatory field isn't answered' message but wont be able to do anything about it</p> <p>and then where you are populating this drop down from a connect action I can't see why you want it to be read only there either ? you'd normally use a drop down for users to then make a selection from that list, but if you have it 'read only' they can't</p> <p>I wonder though, are your fields here initially set to be 'normal' (ie editable) and then you are setting them to read only later in other actions and before the submit ? You would normally not do this, but handle how the form field states are defined from the form 'stage' and 'role'<br /> see here: <a href="http://www.perfectforms.com/Documentation/manual/html/field_access_and_field_states.htm" rel="nofollow">http://www.perfectforms.com/Documentation/manual/html/field_access_and_field_states.htm</a></p> <p>it is a lot easier/cleaner to manage field access this way than by 'scripts' </p> <p>but having looked at how a drop down object handles this with/without 'read only' there is different response from the check mandatory and I would see this as 'expected'. You wouldn't for instance set a field to read only if there was no data that could be entered</p> <p>regarding your 'Or it would be nice if you could set what value should be considered as unanswered' you can do this using a condition based on the selection made and then either run a 'check mandatory' or present your own 'show message' based on what was either 'checked or not checked' </p> http://www.perfectforms.com/forums/topic/email-servermsaccount#post-1267 Wed, 10 Mar 2010 10:02:51 +0000 ijobling 1267@http://www.perfectforms.com/forums/ <p>We have seen situations recently where a loss of 'connection' between SQL and the application causes some unexpected problems. this could be the cause here. Check your server log files and sql log files to see if there is any information given there, but also I'll send you email with a possible solution as well (it includes an attachment that can't be done here) </p> http://www.perfectforms.com/forums/topic/email-servermsaccount#post-1266 Wed, 10 Mar 2010 08:13:53 +0000 rooman 1266@http://www.perfectforms.com/forums/ <p>hi,<br /> As earlier,i faced the same problem.Emails were not going to users.It just stopped of what reason,i have no idea.<br /> So i just followed the steps mentioned earlier and it worked.But may i know the reason for this happening again and again and a permenent solution for it.</p> <p>Thnx. </p> http://www.perfectforms.com/forums/topic/check-mandatory-not-working-in-read-only-and-previously-hidden-fields#post-1265 Tue, 09 Mar 2010 17:31:17 +0000 tmrhymer 1265@http://www.perfectforms.com/forums/ <p>Ahh nevermind...i set all of the borders for my textboxes and radio button lists to none... I guess I am going to have to set them to the same as the background color so they'll display the red border when the check mandatory command is executed. However I am still needing a solution for my read only fields. Either changing the check mandatory to include read only fields or by modifying dropdowns as I suggested in my previous post. </p> http://www.perfectforms.com/forums/topic/check-mandatory-not-working-in-read-only-and-previously-hidden-fields#post-1264 Tue, 09 Mar 2010 17:01:29 +0000 tmrhymer 1264@http://www.perfectforms.com/forums/ <p>Well the read only fields are filled by results from connect commands, they need to have specific values for integration with other systems later on, and are not things we want to leave up to the user to mess up. The dropdown that controls what is displayed in this particular read only field is filled with a connect command, and since connect commands don't prepend an empty selection when results are added to a dropdown, I can't use that for my check mandatory because it has a value set by default. Although I see when you use a predefined list with a dropdown it gets the blank first selection. It would be nice if that were the case when adding items to a dropdown through a connect command. Or it would be nice if you could set what value should be considered as unanswered. Like if you had "select" as your first option in the dropdown check mandatory would see that as not having a value.<br /> You asked what fields were involved. They are all text inputs, dropdowns, and radiobutton lists. Some of the radio button lists I've just given them a default, but for others a default isn't really appropriate and the user needs to make their own selection. One thing thats strange is that I have 2 radio button lists. Neither one is special in any way but both are required and do not have a default option selected. Both are in the same check mandatory command but only one of them shows the red border. So that doesnt make sense to me.<br /> You say, "not all of them WILL show with a red border initially", what are the exceptions for this? </p> http://www.perfectforms.com/forums/topic/check-mandatory-not-working-in-read-only-and-previously-hidden-fields#post-1263 Tue, 09 Mar 2010 16:33:59 +0000 ijobling 1263@http://www.perfectforms.com/forums/ <p>Sorry, but where you said 'the first check mandatory is working' that implies there are more than one. but from what you are saying now what sort of fields are involved ? not all of them WILL show with a red border initially so it may be better to look at handling this differently.. either setting up a check mandatory script for each field one after the other, where you could define seperate messages in each, even present some visual tips to users what fields are required (a red * for instance can be useful in this regard as its considered a common way to show 'this field is required)</p> <p>and if these fields are on different pages of your form run the check mandatory action on a page by page basis rather than all on a final 'submit' button where your users can be sent back to earlier pages </p> <p>but also.. READ ONLY fields - your users can't enter any data into these fields in this state so even if they were to be 'not answered' how are your users then going to enter in data to them where they are 'read only' ? </p> http://www.perfectforms.com/forums/topic/iso-certified#post-1262 Tue, 09 Mar 2010 16:26:41 +0000 Tom 1262@http://www.perfectforms.com/forums/ <p>Hi Rooman,<br /> PerfectForms is not ISO Certified. This has not been a requirement from any of our customers to date. As a result we have not spent the time or expense to go through the full process to obtain the certification. I think you may be the first person to inquire. </p> http://www.perfectforms.com/forums/topic/check-mandatory-not-working-in-read-only-and-previously-hidden-fields#post-1261 Tue, 09 Mar 2010 16:24:42 +0000 tmrhymer 1261@http://www.perfectforms.com/forums/ <p>Well like i said I've moved everything to a single check mandatory command, completely by passing the logic I had with the others. When that single Check mandatory gets called in the submit behavior (verified with debugging) not all of the fields are showing as mandatory (i mean do not have a red border). If I hover over the fields, the "tool tip" shows with the mandatory message, but thats kind of a problem if a user doesnt see the red border. On top of that, fields that I included in check mandatory that are read only are not showing the red border or the tool tip that displays when you hover over the fields. </p> http://www.perfectforms.com/forums/topic/connection-to-text-file-error#post-1260 Tue, 09 Mar 2010 16:00:39 +0000 ijobling 1260@http://www.perfectforms.com/forums/ <p>You could, but probably better to leave that as it is so you have an 'example' to refer to, and set up a new 'datasource' for the database/table you import your csv into and then set up a new connection to this </p> http://www.perfectforms.com/forums/topic/connection-to-text-file-error#post-1259 Tue, 09 Mar 2010 15:52:26 +0000 schaferdg@yahoo.com 1259@http://www.perfectforms.com/forums/ <p>Ok thanks. We have SQL on our perfect forms server can I exchange the northwind connection and database example for my csv file? </p> http://www.perfectforms.com/forums/topic/connection-to-text-file-error#post-1258 Tue, 09 Mar 2010 15:41:31 +0000 ijobling 1258@http://www.perfectforms.com/forums/ <p>SQL server used to have a 'import wizard' type of function, but different versions do it differently I believe... Best thing to do would be to 'google' = 'import CSV into SQL Server XXXXX' (XXXX being the version of SQL server you are using)</p> <p>or of course if your organisation has a DBA, have a word with them, they will know how to do it for sure, and also as you get into setting up your database connection will be able to help you with the 'permissions' etc </p> http://www.perfectforms.com/forums/topic/check-mandatory-not-working-in-read-only-and-previously-hidden-fields#post-1257 Tue, 09 Mar 2010 15:38:18 +0000 ijobling 1257@http://www.perfectforms.com/forums/ <p>First check Mandatory ? you have more than one I assume then. Do you not see the others being called? if you are not, have you some conditions in the script that are causing them to be skipped depending on specific entries on the form </p> <p>try adding in some 'show message' scripts in your script (with different messages)and then 'debug' so you will see what path your scripts are taking and why then these other 'check mandatory' actions are not being invoked..<br /> and even will help you see if the script is running but the field in that check mandatory is being recognised as 'answered'</p> <p>If you still can't find it, send over the form with your 'show messages' as the break points explaining what fields you expect to see as 'flagged' and which ones you don't and we can have a look </p> http://www.perfectforms.com/forums/topic/ip-address-from-browser#post-1256 Tue, 09 Mar 2010 15:31:59 +0000 ijobling 1256@http://www.perfectforms.com/forums/ <p>No. Call Javascript will just support javascript </p> http://www.perfectforms.com/forums/topic/ip-address-from-browser#post-1255 Tue, 09 Mar 2010 15:28:12 +0000 simond 1255@http://www.perfectforms.com/forums/ <p>is it possible to use VBscript instead of javascript? </p> http://www.perfectforms.com/forums/topic/check-mandatory-not-working-in-read-only-and-previously-hidden-fields#post-1254 Tue, 09 Mar 2010 15:21:55 +0000 tmrhymer 1254@http://www.perfectforms.com/forums/ <p>Yup, I've checked in debug and the first check mandatory is working. To simplify what I am doing I moved all of my check mandatory's into one check mandatory command and tried to submit with basically an empty form. Some of the fields are being "flagged" as mandatory indicated by the red border and others are not even though they should be. I could send the form in through a ticket. </p> http://www.perfectforms.com/forums/topic/connection-to-text-file-error#post-1253 Tue, 09 Mar 2010 15:15:44 +0000 schaferdg@yahoo.com 1253@http://www.perfectforms.com/forums/ <p>I am new to data bases. Would I have to create tables in SQL server to get the csv file into a database? </p> http://www.perfectforms.com/forums/topic/formreport-receives-external-call#post-1252 Tue, 09 Mar 2010 14:52:36 +0000 ijobling 1252@http://www.perfectforms.com/forums/ <p>nzgz you see in the screen shot would relate to your form when it is published. look at a form you have deployed and under the LINK button to see how it relates to the other methods of linking - in the 'embed' and 'preload' links seeing the similar reference to the form.<br /> the 'params' of course will relate to the parameter index you have defined within the Get External Call Parameter for the fields you wish to populate</p> <p>Util.js is part of the actual application and not relevant in the External Call. The only time you'd refer to this file is in the OnPremise version where you would be 'customising' in terms of the standard Perfectforms logo's </p> http://www.perfectforms.com/forums/topic/formreport-receives-external-call#post-1251 Tue, 09 Mar 2010 14:20:38 +0000 pvidal 1251@http://www.perfectforms.com/forums/ <p>ok.. i think i see what i'm looking for: pf_call. could you explain that js function a little more. i'm assuming the 'nzgz' isn't a constant but is.. the name of the form?</p> <p>is the javascript utils.js documented anywhere?</p> <p>thanks. </p> http://www.perfectforms.com/forums/topic/ip-address-from-browser#post-1250 Tue, 09 Mar 2010 12:11:04 +0000 ijobling 1250@http://www.perfectforms.com/forums/ <p>Sorry, but the form is not available to download at the current time.<br /> what is it though that you are struggling with? based on your initial 'how to return IP address, look at the second 'example' where the javascript function is:<br /> function myFunction()<br /> //This function will return the string "Hello World!" back to the form<br /> {<br /> return ("Hello world!");</p> <p>and then in your CallJavascript you enter in the name of the function (myFunction) and set the return target to the field you want "Hello world!" returned to </p> http://www.perfectforms.com/forums/topic/ip-address-from-browser#post-1249 Tue, 09 Mar 2010 11:48:03 +0000 simond 1249@http://www.perfectforms.com/forums/ <p>I only ask as you show a mechanic how to strip an engine down, you don't just give him a haynes manual and go there you are you're a mechanic! </p> http://www.perfectforms.com/forums/topic/ip-address-from-browser#post-1248 Tue, 09 Mar 2010 10:48:39 +0000 simond 1248@http://www.perfectforms.com/forums/ <p>Yeah,I've read this. I would like to have seen the form design so I can see the behavior and associated fields in use. </p> http://www.perfectforms.com/forums/topic/ip-address-from-browser#post-1247 Tue, 09 Mar 2010 10:30:05 +0000 ijobling 1247@http://www.perfectforms.com/forums/ <p>sorry its not, but all there is to it is under the butttons is the Call Javascript action realating to the name of the javascript function defined in the code that would be embedded on your webpage.<br /> see here for the other parameters available <a href="http://www.perfectforms.com/Documentation/manual/html/fg_call_javascript_properties.htm" rel="nofollow">http://www.perfectforms.com/Documentation/manual/html/fg_call_javascript_properties.htm</a> </p> http://www.perfectforms.com/forums/topic/ip-address-from-browser#post-1246 Tue, 09 Mar 2010 10:24:50 +0000 simond 1246@http://www.perfectforms.com/forums/ <p>Sorry, I mean the form design. </p> http://www.perfectforms.com/forums/topic/ip-address-from-browser#post-1245 Tue, 09 Mar 2010 10:20:49 +0000 ijobling 1245@http://www.perfectforms.com/forums/ <p>click the 'html example' button on the example form in the user guide and you will see the code used </p> http://www.perfectforms.com/forums/topic/ip-address-from-browser#post-1244 Tue, 09 Mar 2010 10:18:14 +0000 simond 1244@http://www.perfectforms.com/forums/ <p>Id the form code from the Call JavaScript Example available? </p> http://www.perfectforms.com/forums/topic/formreport-receives-external-call#post-1243 Tue, 09 Mar 2010 09:38:01 +0000 ijobling 1243@http://www.perfectforms.com/forums/ <p>use the 'search' tab in the user guide and search for 'external call'<br /> you will see this<br /> <a href="http://www.perfectforms.com/Documentation/manual/html/admin_new_topic.htm" rel="nofollow">http://www.perfectforms.com/Documentation/manual/html/admin_new_topic.htm</a></p> <p>but also in relation to 'outside action' this as well<br /> <a href="http://www.perfectforms.com/Documentation/manual/html/fg_calling_javascript_from_a_form.htm" rel="nofollow">http://www.perfectforms.com/Documentation/manual/html/fg_calling_javascript_from_a_form.htm</a><br /> with more detail on this here:<br /> <a href="http://www.perfectforms.com/Documentation/manual/html/fg_call_javascript_properties.htm" rel="nofollow">http://www.perfectforms.com/Documentation/manual/html/fg_call_javascript_properties.htm</a> </p> http://www.perfectforms.com/forums/topic/connection-to-text-file-error#post-1242 Tue, 09 Mar 2010 09:33:52 +0000 ijobling 1242@http://www.perfectforms.com/forums/ <p>It is possible that this may be the case if you are seeing other connections working OK. but check to see if anything changes if you restart the Apache Tomcat service and re test.<br /> but also do you have a database you can use for this large file though ? they are more efficient in handling larger data sets </p> http://www.perfectforms.com/forums/topic/check-mandatory-not-working-in-read-only-and-previously-hidden-fields#post-1241 Tue, 09 Mar 2010 09:29:45 +0000 ijobling 1241@http://www.perfectforms.com/forums/ <p>very hard to say, depends on how you are handling this in the script actions.<br /> rather than 'preview' look at using the DEBUG and you will see the scripts run as you run these actions to help you see if all your 'check mandatory' scripts are being called as you want </p> http://www.perfectforms.com/forums/topic/formreport-receives-external-call#post-1240 Mon, 08 Mar 2010 20:34:43 +0000 pvidal 1240@http://www.perfectforms.com/forums/ <p>i was looking for some documentation on the "report/form receives external call" and couldn't find anything. i'll apologize ahead of time if i'm just not looking in the right places.</p> <p>i'm hoping, though, this means there's a way to push data to the forms based on an outside action, eg: a javascript function acting on the form/report.</p> <p>either way, thanks ahead of time. </p>