InfoPath Dev

so rather than filter the formulas which I cant seem to do, I've create a calculated column that takes the status and returns a yes/no for cancelled. then i added a button on the form to query for status, put rules on the button to set the query field value to "active" and a query rule. so cancelled shows up in the counts and ...

Hi Hilary, I'm trying to apply a filter to some formulas that I have inside my repeating table, but I'm coming up empty-handed. I've tried filtering inside the formula, outside of it, rules on the table and using query fields, but nothing I've tried works. In the table that returns from the Call-up list I would like to not include ...

I'd guess the main data source is returned sorted on the ID or created date. I don't think there is any way for you to modify this default behavior. You can add formatting rules to most controls, so if you wanted to format a table row or repeating section instance you can.

thanks! So from what I can tell this returned data in a repeating section/table can't be sorted by me. Is the current sort looking at ID number? or does this come from the current view (sort) on the list? but I'm thinking I could highlight items in the returned data if I use a formatting rule?

So - I don't really have an answer to your question directly, but do have something you might try as a work around.... Is the data type of the field in InfoPath a number? If so, just promote the number, and add a calculated column that formats it as currency, then use that in your SharePoint Designer workflow?

Just the layout and behavior of the controls in the form. Do a quick experiment with a customized list form - set it up to manage multiple items, drag the repeating data group onto the form, select Repeating Section (with or without controls) for the control type. Then do it again and select repeating table. Repeating sections give you more layout ...

This feels like a noob question so I'll ask it here. What is the difference between a repeating section and table? Specifically when used to display information from a SharePoint list on an InfoPath form. Thanks

I have a SharePoint library with an InfoPath form that is submitted when completed and then closed then returns the user to the library I would like to redirect them to the homepage.  I have not been able to get the Source change to work but my fix is working.  I created another view called SubmitNew which has a ...

I’m having problems with a dollar field from an InfoPath form, displaying properly in the SharePoint Designer generated e-mail. Everything is fine, unless the dollar amount ends in “.00”, then all I get is a single decimal place (for example, I have numbers that display as “$1,1200.0”; $450.0; and $7000.0”). My original field to capture the ...

Oh, perfect, glad you found a way to get it to work the way you needed. Sometimes it just takes some experimentation! :-)