ContributionsMost RecentMost LikesSolutionsCallable Pipeline Return ValueWhen using a callable pipeline, does it return any data to the calling pipeline? If so, how do I access it? Later in the calling pipeline, I need RID for a record created in the called pipeline. I think I can store the new RID in another known record from within the called pipeline, and then grab it from there in the calling pipeline but that seems like an unnecessary hack. ------------------------------ Matt Hardy ------------------------------ Re: Many-to-Many HelpThanks Mark. I'll probably take you up on the consulting offer as soon as I can find the time for it. Too busy the next few weeks. ------------------------------ Matt Hardy ------------------------------ Many-to-Many HelpHello, I need to use a many-to-many relationship between a PO table and Invoice table. I have the relationship setup but I'm hoping to find a way to simplify the data entry. For the most part, these relationships are 1-to-1 but we have rare occasions where it can be 1-to-many in either direction, hence my reason for many-to-many. Is it possible to have a button on the PO form to create a new invoice and link everything through the intermediate table without the user needing to select the PO and Invoice? ------------------------------ Matt Hardy ------------------------------ Re: Find Highest Field ValueSo simple. I was over complicating this. Thank you ------------------------------ Matt Hardy ------------------------------ Find Highest Field ValueI have a table with an Invoice # field (numeric) - how can I find the highest Invoice # using a formula? Thanks ------------------------------ Matt Hardy ------------------------------ Re: Losing Number Format in Rich Text FormulaWith some slight modification, that worked perfect. Thank you so much for the quick reply Mark. Here's the mod I made: var text txtRounded = ToFormattedText(Round([yourvalue],0.01),"comma_dot"); ------------------------------ Matt Hardy ------------------------------ Losing Number Format in Rich Text FormulaI found a few references to my issue in old posts but the links all seem to be dead. I'm trying to display the value of a currency field [PO Subtotal] in a rich text formula field. The number displays but drops the number formatting I have setup on the [PO Subtotal] field, leaving me with either 1 or no decimal points depending on the situation. How can I force two decimal points in a rich text formula field? [PO Subtotal] displays with 2 decimal points outside this rich text field. I feel like I'm missing something simple but after checking the display options for every field involved in this, I'm out of ideas and above all frustrated when all the (seemingly) relevant QB Community links are broken. Below is the entire code from the rich text formula field. " <table align=\"right\" border=\"0\" cellpadding=\"1\" cellspacing=\"1\" style=\"width:820px;\"> <tbody> <tr> <td style=\"width: 70%;\"> </td> <td style=\"text-align: right;\"> <p>Subtotal</p> <p>HST (13%)</p> <p>Invoice Total</p> <p>Total Payments</p> <p>Balance Due</p></td> <td> <p style=\"text-align: right;\">" & [PO Subtotal] & "</p> <p style=\"text-align: right;\">" & [Tax] & "</p> <p style=\"text-align: right;\">" & [Total] & "</p> <p style=\"text-align: right;\">" & [Total Payments] & "</p> <p style=\"text-align: right;\">" & [Balance] & "</p> </td> </tr> </tbody> </table> " ------------------------------ Matt Hardy ------------------------------ Re: Form Preview Acts Different than Live FormThat was the problem. So simple. Thank you so much! ------------------------------ Matt Hardy ------------------------------ Form Preview Acts Different than Live FormHello, I have a form that has multiple lookup fields from other apps, all of which work fine when using the form preview. When I save the form and try to use it, most of the lookup fields no longer work. Where should I start looking for the problem? Attached are screenshots showing the difference in the form preview and the actual form. Here's a breakdown of what I'm doing: - We work under multiple contracts, each of these has it's own app. - I created an invoicing app with relationships to each of the contract specific apps, with the invoicing table being the child in each because each job under the contract app can have multiple invoices. - The invoicing app needs to lookup a reference number from the contract app and store it in "Job" field. I might be complicating matters here, but I'm using a single job field to simplify the reports. I can display this one field, rather than each of the 9 lookup fields. Thanks in advance for any guidance. ------------------------------ Matt Hardy ------------------------------