http://www.perfectforms.com/forums/ Forums for the PerfectForms.com Application en Wed, 08 Feb 2012 04:10:39 +0000 http://www.perfectforms.com/forums/topic/get-notification-properties-from-table-columns#post-2462 Thu, 27 Oct 2011 16:00:12 +0000 Dennis @ PerfectForms 2462@http://www.perfectforms.com/forums/ <p>As you have discovered, fields in tables cannot be used in notifications. The main reason is that notifications only send when the instance is submitted. At that point it is too late to loop through a table and populate notifications.<br /> I would either use hidden helper fields or one of the various options on the Time tab in a notification object.<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/get-notification-properties-from-table-columns#post-2454 Wed, 26 Oct 2011 05:01:34 +0000 Winson 2454@http://www.perfectforms.com/forums/ <p>Dear all , </p> <p>For question 2 , seems it is a problem when using Notification in loop.</p> <p>No matter how well the helper variable were populated in the loop, all notifications used latest value of those variables. is it by design?</p> <p>If yes, anyone knows how to amend the workflow to support sending different mail bodies in differnt dates, which body and date are in table? </p> <p>Thanks so much ~ </p> http://www.perfectforms.com/forums/topic/get-notification-properties-from-table-columns#post-2450 Tue, 25 Oct 2011 08:17:40 +0000 Winson 2450@http://www.perfectforms.com/forums/ <p>Hi, </p> <p>I have a table with 2 columns: one is date column while the other is text. Once user submmit form, I want to send mails by looping the table, data in each rows will be used in notification one by one. The date field is the specific date the mail should send out, and the text field in table should be populated as mail body.</p> <p>e.g.<br /> date text<br /> #1 11 Dec 2011 text 1<br /> #2 13 Dec 2011 text 2 </p> <p>Once submitted, I want two mails to be sent on 11 Dec 2011 and 13 Dec 2011, the first one are with body as "text 1" while the 2nd one are as "text 2".</p> <p>However I encouter below problems:<br /> 1. when I try to use {Table - TextFieldName - Current row} in body, it does not work and string "{Table - TextFieldName - Current row~}" will show in the mail . Why?<br /> 2. even I set a helper field as {Table - TextFieldName - Current row}, and loop the table to send two mails, I notice that in both mail's body are "text 2", how can I got the 1st mail's body as "text 1"?<br /> 3. how can I send these two mails on 11 Dec 2011 and 13 Dec 2011 ?</p> <p>Thanks for your help. </p> http://www.perfectforms.com/forums/topic/how-to-assign-a-seq-number-to-each-table-record#post-2433 Thu, 20 Oct 2011 16:47:08 +0000 Dennis @ PerfectForms 2433@http://www.perfectforms.com/forums/ <p>Create a behavior to loop through the table.<br /> Start with a Set Table Rows Object - Move to first row. Next use two Set Fields. Set a hidden helper field to 1. Set Field # column-current row to value in hidden helper. Set Table Rows Object - Move to next row. Simple Branch object - Was last command successful? If true use two Set Fields. Set the hidden helper field using a formula (hidden helper value + 1). Set Field # column current row to value in hidden helper. Then loop back to second Set Table Rows object (move to next row). If false go to Exit behavior object because you have reached the end of the table.<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/how-to-assign-a-seq-number-to-each-table-record#post-2429 Thu, 20 Oct 2011 01:44:59 +0000 Winson 2429@http://www.perfectforms.com/forums/ <p>Thanks Dennis for your reply. But if I want to assign seq # to column 1 in table in the same form (e.g. 1 for first row, 2 for 2nd, etc), how to do? </p> http://www.perfectforms.com/forums/topic/how-to-assign-a-seq-number-to-each-table-record#post-2420 Wed, 19 Oct 2011 16:55:39 +0000 Dennis @ PerfectForms 2420@http://www.perfectforms.com/forums/ <p>Each instance has a unique sequential number - the instance number. After the form is published the first time, the first instance starts at instance #1. You can simply use the instance #, or use a formula to build on it.<br /> Remember that an instance # is not created until the instance has been submitted the first time. You may need to create a behavior on when form opens that sets a field (call it hidden instance # helper)with Special - Instance Number. Then use a simple branch to look at at that field. If the field value is less than 1 - submit and re-open the same instance. If it is = or greater than 1 go to an Exit behavior object.<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/how-to-assign-a-seq-number-to-each-table-record#post-2418 Wed, 19 Oct 2011 10:55:27 +0000 Winson 2418@http://www.perfectforms.com/forums/ <p>Hi, may i know how to assign a unique seq number to each record's 1st column in table?</p> <p>Thanks </p> http://www.perfectforms.com/forums/topic/loading-items-to-a-drop-down-in-table#post-2416 Tue, 18 Oct 2011 20:47:27 +0000 Dennis @ PerfectForms 2416@http://www.perfectforms.com/forums/ <p>Drop-downs in tables cannot be dynamically populated.<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/loading-items-to-a-drop-down-in-table#post-2413 Tue, 18 Oct 2011 10:51:30 +0000 Winson 2413@http://www.perfectforms.com/forums/ <p>Dear all, </p> <p>May I know how to load valid values from DB to a drop-down column in table object, to allow user select a value when he adds new line? </p> <p>I need a column which type is drop-down but it has no predefined items, when form is loading I would like to load its items from database. </p> <p>I knew by using connect we can load data to a stand alone drop-down , but don't know how to do when the dropdown is in table. </p> <p>If any one can tell me how to do that? Thanks in advanced.</p> <p>Winson </p> http://www.perfectforms.com/forums/topic/marking-mandatory-table-columns#post-2405 Tue, 11 Oct 2011 19:09:23 +0000 srogers 2405@http://www.perfectforms.com/forums/ <p>Basically I replaced a Check Mandatory behavior by calling an external behavior (which does a separate Check Mandatory behavior for each table column, because I wanted the warning message to be different for each column). It didn't work because the external behavior would be called, and if any of the check mandatory behaviors failed, it would end the sub-behavior, but the one that called it would continue. </p> http://www.perfectforms.com/forums/topic/marking-mandatory-table-columns#post-2403 Tue, 11 Oct 2011 18:32:08 +0000 Dennis @ PerfectForms 2403@http://www.perfectforms.com/forums/ <p>I was able to follow you, I think. I think you are talking about the exit object in the behavior being referenced with the run behavior object. I wouldn't use Last command was successful, I would use another exit object in the behavior calling the other behavior.<br /> It sounds like you may have a problem in that the behavior being called does too many things in this case (I can't quite tell).<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/marking-mandatory-table-columns#post-2401 Tue, 11 Oct 2011 13:35:19 +0000 srogers 2401@http://www.perfectforms.com/forums/ <p>That looks like it should work - It will make the behavior screen of my submit button unworkably huge, as there are already a number of behaviors associated with it.</p> <p>I've tried to make a placeholder button on a hidden page to house large behaviors, and call them from other behaviors. Problem is, if you call a behavior from another behavior, the Exit behavior item will only exit the current behavior (If there are more items in the original behavior, they will continue). Is there a way to end all active behaviors? Or would the "last command was successful" criteria work on a run behavior command?</p> <p>Yikes. I hope that paragraph makes sense. </p> http://www.perfectforms.com/forums/topic/marking-mandatory-table-columns#post-2396 Fri, 07 Oct 2011 21:26:34 +0000 Dennis @ PerfectForms 2396@http://www.perfectforms.com/forums/ <p>You could create a behavior on submit that loops through the table and at each row uses a simple branch (is *field* - current row empty?). If true, use a Show Message behavior object. The empty field in the table will remain highlighted.<br /> Build the behavior like this:<br /> Set Table Rows - move to first row.<br /> Simple Branch - Is field empty?<br /> If true, show message. if false move on to<br /> Set Table Rows - Move to next row.<br /> Simple Branch - Last Behavior was successful?<br /> If true loop back to first Simple Branch<br /> If false go to Exit behavior object.</p> <p><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/marking-mandatory-table-columns#post-2395 Fri, 07 Oct 2011 15:50:08 +0000 srogers 2395@http://www.perfectforms.com/forums/ <p>Hello,</p> <p>I have a table with 10+ columns. About half of these columns are mandatory. When I check whether or not they have values using the check mandatory behavior, all the column headers are marked in red if any one column doesn't have data.<br /> Is there a way to mark only the specific columns that require values when you check mandatory?<br /> It's very confusing to the user, who may have an entry which legitimately doesn't have data for a column, as it appears that all columns are mandatory. </p> http://www.perfectforms.com/forums/topic/change-table-state-with-behaviors#post-2343 Tue, 06 Sep 2011 21:12:24 +0000 Dennis @ PerfectForms 2343@http://www.perfectforms.com/forums/ <p>The state of individual columns in a table cannot be changed dynamically.<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/change-table-state-with-behaviors#post-2342 Tue, 06 Sep 2011 15:50:21 +0000 srogers 2342@http://www.perfectforms.com/forums/ <p>Is it possible to change the state of a table column with behaviors? I'm hoping to create several hidden columns which can be revealed/hidden based on the selection of another dropdown in the table. </p> http://www.perfectforms.com/forums/topic/how-to-update-table-into-database#post-2247 Mon, 27 Jun 2011 01:47:13 +0000 mrordaz 2247@http://www.perfectforms.com/forums/ <p>should i be using insert? Do I have to do a loop on all the rows to check if the row is newly added (for insert) or if the row is existing already (for update) when saving? what about rows which are deleted? </p> http://www.perfectforms.com/forums/topic/how-to-update-table-into-database#post-2243 Thu, 23 Jun 2011 23:22:30 +0000 Dennis @ PerfectForms 2243@http://www.perfectforms.com/forums/ <p>Have you used "insert"?<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/how-to-update-table-into-database#post-2241 Thu, 23 Jun 2011 11:57:59 +0000 mrordaz 2241@http://www.perfectforms.com/forums/ <p>yes sir... am using "All rows" in the send parameter...</p> <p>have you tried the example given? </p> http://www.perfectforms.com/forums/topic/how-to-update-table-into-database#post-2237 Wed, 22 Jun 2011 20:53:24 +0000 Dennis @ PerfectForms 2237@http://www.perfectforms.com/forums/ <p>Are you using the column - All rows in your send parameter? </p> http://www.perfectforms.com/forums/topic/how-to-update-table-into-database#post-2232 Wed, 22 Jun 2011 01:48:05 +0000 mrordaz 2232@http://www.perfectforms.com/forums/ <p>I totally understand the use of a connection agent, in fact I have already created several actions in a connect definition (SELECT,UPDATE, INSERT). The problem is that when i retrieve data from database into a table, which action should i use? As mentioned in my previous post, I have retrieve 2 rows and placed them in a table (in a form) then I edited a column in the first row, then I added a new row (i now have 3 rows, and a row with an edited column)... If I use update, the newly added row does not get saved. </p> http://www.perfectforms.com/forums/topic/how-to-update-table-into-database#post-2231 Tue, 21 Jun 2011 16:48:01 +0000 Dennis @ PerfectForms 2231@http://www.perfectforms.com/forums/ <p>The Connection Agent is required to integrate with an outside database table. Please refer to the documentation regarding the Connection Agent: <a href="http://www.perfectforms.com/Documentation/manual/html/?lookup_agent.htm" rel="nofollow">http://www.perfectforms.com/Documentation/manual/html/?lookup_agent.htm</a> </p> http://www.perfectforms.com/forums/topic/how-to-update-table-into-database#post-2228 Tue, 21 Jun 2011 03:57:30 +0000 mrordaz 2228@http://www.perfectforms.com/forums/ <p>I was having problem updating a table. My current table has two rows, one row was edited then I added another row. How do I update the table into the database (updating the edited row and inserting the newly added row)? </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/table-text-not-displaying#post-2126 Wed, 20 Apr 2011 18:04:12 +0000 mbeccaria@paulsmiths.edu 2126@http://www.perfectforms.com/forums/ <p>Dennis,<br /> Thanks. It's interesting though because the file I clicked on was actually uploaded on another page of the form. I then used the set field properties of the table when the page opens to show that field. I am able to access the file in the table (even though you say it isn't allowed/possible) but the text isn't showing is the only glitch. I've developed a workaround for it so It's not a big deal, just thought you'd like to know.<br /> Thanks, </p> http://www.perfectforms.com/forums/topic/table-text-not-displaying#post-2125 Wed, 20 Apr 2011 16:50:26 +0000 Dennis @ PerfectForms 2125@http://www.perfectforms.com/forums/ <p>Attachments cannot be moved or copied. The only way to access or delete an attachment is in the form instance in the attachment object where it was originally attached. </p> http://www.perfectforms.com/forums/topic/table-text-not-displaying#post-2124 Wed, 20 Apr 2011 14:20:25 +0000 mbeccaria@paulsmiths.edu 2124@http://www.perfectforms.com/forums/ <p>I have a table that has a text field and an attachment field. I am using a behavior on page load that sets the value of the file attachment field equal to a file attachment that is present on another page. However, when the table is displayed, it shows the "Detach" button without text. It allows the user to hover over where the text should be and click it to open the attachment, but the attachment text isn't there. Is this a bug or is there a way to alleviate this?</p> <p>Here is a quick video showing my problem:<br /> <a href="http://screencast.com/t/L3AFaKZNCJ2j" rel="nofollow">http://screencast.com/t/L3AFaKZNCJ2j</a> </p> http://www.perfectforms.com/forums/topic/table-and-scrolling-bug#post-2054 Mon, 21 Mar 2011 15:16:01 +0000 phillip 2054@http://www.perfectforms.com/forums/ <p>Hmmm, thought I had a fix, but it didn't work, so nevermind. </p> http://www.perfectforms.com/forums/topic/table-and-scrolling-bug#post-2053 Mon, 21 Mar 2011 14:30:34 +0000 phillip 2053@http://www.perfectforms.com/forums/ <p>I am pulling a table from another form instance and I have run into a strange problem/bug. After the data is pulled via a connection, a loop runs to populate a new column 'Seats Left'. Currently I have 4 records, and when the table's height is tall enough to show all 4 records, everything is good.<br /> <br /> However, when the table is not able to show all the records (and you have to scroll through the list), the 3rd row's 'Description' column is the same as the 4th row's, and the 'Seats Left' column is not populated; however, all the other information is correct.<br /> <br /> I've put in some text boxs to reflect what is in the current row and also noticed the second row, when clicked for the first time, shows the correct 'Description' in the table but shows row 4's 'Description' in the text box, but again, all other info is correct. When you come leave and then reclick row 2, all the information is back to normal in the text boxes.<br /> <br /> I've removed the 'Seats Left' update loop and then the table works no matter the physical height of the table, but that's not a solution. Any one run into this or have any thoughts?<br /> <br /> The Behaviour is<br /> <pre><code>Connect: NSO Databse Set Table Rows: Select First Simple Branch: Last Command was Successful TRUE { Set Field: &#39;Seats Left&#39; = &#39;(Current Row-Capacity) - (Current Row-Seats Remaining)&#39; Set Table Rows: Select Next } FALSE Set Table Rows: Select First</code></pre>