PerfectForms Forums: Forum: Working with Tables

PerfectForms Forums: Forum: Working with Tables - Recent Topics http://www.perfectforms.com/forums/ Forums for the PerfectForms.com Application en Wed, 08 Feb 2012 08:31:25 +0000 Winson on "Get notification properties from table columns" 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/ Hi, 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. e.g. date text #1 11 Dec 2011 text 1 #2 13 Dec 2011 text 2 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". However I encouter below problems: 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? 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"? 3. how can I send these two mails on 11 Dec 2011 and 13 Dec 2011 ? Thanks for your help. Winson on "How to assign a seq number to each table record" 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/ Hi, may i know how to assign a unique seq number to each record's 1st column in table? Thanks Winson on "loading items from database to a drop-down in table" 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/ Dear all, 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? 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. 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. If any one can tell me how to do that? Thanks in advanced. Winson srogers on "Marking mandatory table columns" 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/ Hello, 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. Is there a way to mark only the specific columns that require values when you check mandatory? 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. srogers on "Change table column state with behaviors" 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/ 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. mrordaz on "How to update table into database" 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/ 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)? cduxler@directtechnology.com on "Drop Down in a Table Populate with Connector" http://www.perfectforms.com/forums/topic/drop-down-in-a-table-populate-with-connector#post-330 Tue, 21 Apr 2009 23:09:51 +0000 cduxler@directtechnology.com 330@http://www.perfectforms.com/forums/ Hey Folks, Is it possible to populate a drop down list in a table from another form? Here is what I have done: I have created some lookup data in a form and a connector. Testing the connectors 'read' method returns the data I want. following these instructions, <a href="http://www.perfectforms.com/forums/topic/populate-listdrop-down-objects#post-53," rel="nofollow">http://www.perfectforms.com/forums/topic/populate-listdrop-down-objects#post-53,</a> I can bind the connector to a stand alone drop down list and the values appear as expected. The problem I am finding is that when I try to use those same steps to bind to the drop down in the table, in the TARGET list for the connector I do not see the table's column objects as an option to bind to, only the table itself. How do I access the drop down list in the column. I am binding on the tables 'Row Create' event at this time. Thanks, Chris mbeccaria@paulsmiths.edu on "Table Text Not Displaying" 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/ 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? Here is a quick video showing my problem: <a href="http://screencast.com/t/L3AFaKZNCJ2j" rel="nofollow">http://screencast.com/t/L3AFaKZNCJ2j</a> phillip on "Table and Scrolling Bug" 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/ 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. 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. 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. 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? The Behaviour is <pre><code>Connect: NSO Databse Set Table Rows: Select First Simple Branch: Last Command was Successful TRUE { Set Field: 'Seats Left' = '(Current Row-Capacity) - (Current Row-Seats Remaining)' Set Table Rows: Select Next } FALSE Set Table Rows: Select First</code></pre> phillip on "Ordering a Table" http://www.perfectforms.com/forums/topic/ordering-a-table#post-2046 Thu, 17 Mar 2011 16:42:23 +0000 phillip 2046@http://www.perfectforms.com/forums/ Does Perfect Forms have a way integrated to order a table from a connection? I've successfully used the behaviours to mimic a 'bubble sort' for a given table, so I'd think this would be a simple feature that could be added. epball on "All Rows in Email Content" http://www.perfectforms.com/forums/topic/all-rows-in-email-content#post-145 Tue, 20 Jan 2009 17:41:54 +0000 epball 145@http://www.perfectforms.com/forums/ I would like to include a list of URLs from a table in an email. However, in the email it generally ends up looking like this: {Proof URLs - Proof URL - All rows~} when I insert it has a field. I tried building the text string on row loses focus as suggested in another topic on this particular forum, however, there is the problem of deletions and edits. With a couple of edits, it's not surprising to have 3 or 4 copies of the same URL because it's added every time focus is lost. (An implode rows function might be handy, but does not appear to exist.) amurbach on "Reporting with data connection" http://www.perfectforms.com/forums/topic/reporting-with-data-connection#post-1841 Wed, 01 Dec 2010 01:28:09 +0000 amurbach 1841@http://www.perfectforms.com/forums/ What is the procedure for bringing data into the report when using database connections? If the answer is to use a CONNECT behavior then how do I put data into a Data List or Data Grid object as those fields are not exposed? imperial on "warning message when removing rows in a table" http://www.perfectforms.com/forums/topic/warning-message-when-removing-rows-in-a-table#post-1641 Thu, 19 Aug 2010 08:55:12 +0000 imperial 1641@http://www.perfectforms.com/forums/ Is there anyway to setup a behaviour that warns a user when they have pressed the delete row button on a table? i have tried using the show message behaviour but this still deletes the row even if the user selects no to the confirmation message! jrubadue on "Table rows active on page load" http://www.perfectforms.com/forums/topic/table-rows-active-on-page-load#post-1609 Wed, 04 Aug 2010 19:58:25 +0000 jrubadue 1609@http://www.perfectforms.com/forums/ Is there a way to make the first row of a table become active without the user needing to click the "add row" button? I am somewhat new to PF, so I apologize if this is a basic operation that I have simply overlooked. sircooljoe on "Making madatory fields in a table" http://www.perfectforms.com/forums/topic/making-madatory-fields-in-a-table#post-1602 Tue, 03 Aug 2010 17:04:03 +0000 sircooljoe 1602@http://www.perfectforms.com/forums/ Hello, I have a table in my form. In this table I have a drop down menu. What I would like to accomplish is that if a specific value is select from the drop down menu that another cell in the row become mandatory. I would like to accomplish this prior to them adding a new row. Is this possible to do? If so, how is it done? (beginner instructions please) pprokop on "Adding row numbers to tables" http://www.perfectforms.com/forums/topic/adding-row-numbers-to-tables#post-1332 Sun, 04 Apr 2010 14:55:25 +0000 pprokop 1332@http://www.perfectforms.com/forums/ I'd like the first column of my table to show the row number. This field should auto update when I add/delete a row. So first column of row 1 should Say "1", row 2 should say "2", etc. How do I do this short of manually requiring the user to type in the row number himself? smithd on "Tables using row data" http://www.perfectforms.com/forums/topic/tables-using-row-data#post-1141 Wed, 17 Feb 2010 14:59:26 +0000 smithd 1141@http://www.perfectforms.com/forums/ How do I access the field data in a table row in other places of the form or update a database with it. I have a table that has 2 fields (account number and percent). I want to let users to enter as many records as they need. Then I want to reference the account number and percent in other parts of the form and finally be able to upload it to records in a database. MABrown on "Update table values using a form connection" http://www.perfectforms.com/forums/topic/update-table-values-using-a-form-connection#post-881 Fri, 23 Oct 2009 20:38:15 +0000 MABrown 881@http://www.perfectforms.com/forums/ I have a form with a table. I want to create another form that will pull back all of the rows from the tables of multiple form instances, allow the user to update those values, and then commit those changes to the individual form instances. Is it possible to update individual values in the rows of a table using a form connection? MABrown on "numeric field in table will not preserve changes" http://www.perfectforms.com/forums/topic/numeric-field-in-table-will-not-preserve-changes#post-877 Thu, 22 Oct 2009 00:14:54 +0000 MABrown 877@http://www.perfectforms.com/forums/ I have a form with a table designed to allow users to select a date range from two date columns. When the date range is entered, a behavior automatically determines the number of work hours in that date range (number of weekdays, multiplied by eight) and populates a third column, "Hours". The "Hours" column is intended to be editable; that is, the user may make changes to the value in this column. We have found that when making changes to this value, the changes are not always committed. Sometimes the value of the "Hours" column will revert to the previous value, sometimes the value will go blank, and sometimes it will work. In our testing we cannot determine a scenario where it will always fail, or always work. That said, it seems to work most of the time when clicking in another field, and it usually fails when clicking into a blank space on the form. Having more than six rows increases the likelihood that the change will not be committed. Any ideas as to why this might be happening? There are behaviors triggered by the value in this column changing. MABrown on "Sort Rows" http://www.perfectforms.com/forums/topic/sort-rows#post-551 Thu, 02 Jul 2009 23:51:53 +0000 MABrown 551@http://www.perfectforms.com/forums/ Is there a way to sort or re-order rows in a table? MABrown on "Can I access values in specific rows?" http://www.perfectforms.com/forums/topic/can-i-access-values-in-specific-rows#post-440 Fri, 29 May 2009 21:26:16 +0000 MABrown 440@http://www.perfectforms.com/forums/ Is there a way to setup a behavior that can access a specific row in a table? For instance, can I create a behavior where a value in one row is dependent upon a value in the row immediately above it? Also, is there a way to programmatically loop through each row of a table looking for specific values? RayP on "Radio Buttons in Tables" http://www.perfectforms.com/forums/topic/radio-buttons-in-tables#post-397 Mon, 18 May 2009 16:26:59 +0000 RayP 397@http://www.perfectforms.com/forums/ I have a "select" column on a table. It needs to function like a radio button - only one selection allowed. Radio button is not an option for column type. The closest thing functionally is a "button" - but I would need to change the button image to make it look like a checkbox or radio button. I can't find where to do that. Alernatively, is there a way to make the checkbox behave like a radio button (only one selection)? I need a workaround ASAP... I was hoping 1.12 would solve it but no luck. Thanks. Ray P. wliang on "Get column info in table from Parent form" http://www.perfectforms.com/forums/topic/get-column-info-in-table-from-parent-form#post-201 Thu, 05 Mar 2009 18:02:10 +0000 wliang 201@http://www.perfectforms.com/forums/ I have a table with child form instance column, and I can't pass the row information to the child form by using the "Parent Instance ID". Please help. Thanks. RayP on "First Row in Table is Blank" http://www.perfectforms.com/forums/topic/first-row-in-table-is-blank#post-296 Mon, 13 Apr 2009 17:30:50 +0000 RayP 296@http://www.perfectforms.com/forums/ I am pulling data from a WS Connection. I set the table rows to "Add Row" at the beginning. The first row displays blank. Any ideas? Thanks. ajobling on "Counting the number of rows in a table" http://www.perfectforms.com/forums/topic/counting-the-number-of-rows-in-a-table#post-245 Wed, 25 Mar 2009 12:30:31 +0000 ajobling 245@http://www.perfectforms.com/forums/ If you want to count the number of rows in a table column that contain data, use the 'Count' function with the parameter 'Table - Column - All Rows' jkraemer on "Can drop down menus be placed inside of table cells?" http://www.perfectforms.com/forums/topic/can-drop-down-menus-be-placed-inside-of-table-cells#post-149 Mon, 26 Jan 2009 04:01:22 +0000 jkraemer 149@http://www.perfectforms.com/forums/ Is there a way to place drop down menus within the cells of the tables? ijobling on "To Notify to users email addresses collected in a table object" http://www.perfectforms.com/forums/topic/to-notify-to-users-email-addresses-collected-in-a-table-object#post-73 Fri, 28 Nov 2008 12:00:50 +0000 ijobling 73@http://www.perfectforms.com/forums/ The notify 'to email field = table field all rows' does not yet support this. but set up a (hidden) text field (set the character limit accordingly) and then on the table object 'row looses focus' run a set field script to write to this text field.. Table email field - current Row + ; + value of text field the text field will then contain all the email addresses in the format of <a href="mailto:mail1@mail.com;mail2@mail.com;mail3@mail.com">mail1@mail.com;mail2@mail.com;mail3@mail.com</a> etc .. and then setting the notify action to this text field will ensure all these email addresses are notified ijobling on "set up table object" http://www.perfectforms.com/forums/topic/set-up-table-object#post-64 Wed, 15 Oct 2008 09:05:43 +0000 ijobling 64@http://www.perfectforms.com/forums/ After creating the table, do I need to drag numeric inputs over each cell to allow users to enter data. No, as you create the table, the fields are set by default to 'Text', simply go to the properties of the table and change the columns to reflect the field type you wish to use