MattHardy1
Qrew Trainee
Joined 5 years ago
User Profile
User Widgets
Contributions
Mobile WebUI Help
I'm trying to build a very basic form for external users to enter some data and hitting a roadblock and hoping someone here can point me in the right direction. The people this form is intended for are not employees and don't have any experience with QB so I'm trying to keep it very simple. The plan is for them to access it through a browser on either a computer or their phone. I created a form to be used for these users which works fine on a computer but when using a phone, a few of the elements are missing. Specifically a report link and a button to add new child records. Attached are screenshots showing the same form. Saving the record on the phone returns them to the app homepage but the purpose of this form requires them to add child records, so having them return to the home page adds extra steps/complexity on their part. So, I guess my question is - how can I set this up so the user can create an Order record, then easily add child records on their phone. It functions fine on a computer but this will mostly be used on a phone.75Views0likes1CommentCallable Pipeline Return Value
When 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 ------------------------------68Views0likes1CommentMany-to-Many Help
Hello, 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: Losing Number Format in Rich Text Formula
With 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 ------------------------------69Views0likes1CommentLosing Number Format in Rich Text Formula
I 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 ------------------------------90Views0likes3Comments