MikeKlausing
Qrew Assistant Captain
Joined 6 years ago
User Profile
User Widgets
Contributions
Reference Guide/Quick Lookup
I have a raw materials table that has a "description", "$/ea", "$/ft", "markup" and "List Price" columns. What I need to do is get all of the list prices for each individual raw material to its own field so I can use that specific field ID on a form on EF+. What is the easiest way to point the form to a specific field in a list like this? Below is the word document it needs to end up on with Field ID's to reference. ------------------------------ Mike Klausing ------------------------------Form Button/ automation
I have a form that salesmen use to create quotes on. I want there to be an "order" button displayed only when the required fields are filled in, but want them to be able to save it whenever they want, so requiring the fields wont work because then they cant save it as they want. Right now I have an "order" button that I can show and hide with dynamic form rules, but I need to display text or something that lets them know what they need to complete yet, if the order button isnt there. What would be the best way to do this, a formula rich text field with all of my rules in it and then just have it display text with the fields needed? Or is this something an automation could help with? ------------------------------ Mike Klausing ------------------------------Re: Add decimals to the right of a text field
Lisa, Thank you that worked great! In case anybody needs to see the working formula I ended up using its below. I changed the variables to be if statements so they will collapse if null, also put a "$" after the break. "<span style=\"font-size:11px;\">" & "<b>" & "<span style=\"text-decoration:underline;\">" & "<p style=\"text-align: Right;\">" & var text costnote =If([Cost Notes]>0,ToText([Cost Notes])&".00",null); var text notetwo = If([Note 2 Cost]>0, ToText([Note 2 Cost])&".00", null); var text notethree =If([Note 3 Cost]>0,ToText([Note 3 Cost])&".00",null); var text notefour =If([Note 4 Cost]>0,ToText([Note 4 Cost])&".00",null); var text VerticalList = (List (" <br />$", $costnote, $notetwo, $notethree, $notefour )); If([Cost Notes]<0, null, If($VerticalList <> "", "$" & $VerticalList)) &"</p>" & "</span>" & "</b>" & "</span>" ------------------------------ Mike Klausing ------------------------------Re: Add decimals to the right of a text field
Lisa, Thank you for your response. I forgot to clarify in my original question that any or all of these fields may be blank. So if they are null then the ".00" will still show up and I need that to only show up if there is a value in that particular field. ------------------------------ Mike Klausing ------------------------------Add decimals to the right of a text field
I have a formula converting numbers to a list of text. I need it to display a list of amounts vertically. Everything is working properly including the "$" out front. The last thing I am needing to place is ".00" at the end of each of these fields to show the decimal places. "<span style=\"font-size:11px;\">" & "<b>" & "<span style=\"text-decoration:underline;\">" & "<p style=\"text-align: Right;\">" & var text VerticalList = (List (" <br />", ToText([Cost Notes]), ToText([Note 2 Cost]), ToText([Note 3 Cost]), ToText([Note 4 Cost]))); If($VerticalList <> "", "$" & $VerticalList) &"</p>" & "</span>" & "</b>" & "</span>" ------------------------------ Mike Klausing ------------------------------Re: Create Vertical List
I've been working on this but havent got it to collapse the blank lines as of yet. both of these formulas still dont pick out the blank lines and collapse them. I have tried these formulas: "<span style=\"font-size:11px;\">" & "<b>" & var text VerticalList = (List ("<br />", If(Trim([Formula show fields with data (Windows Quantity)])<>"", ToText([Formula show fields with data (Windows Quantity)])), If(Trim([Formula show fields with data (Vents Quantity)])<>"", ToText([Formula show fields with data (Vents Quantity)])), If(Trim([Formula show fields with data (Walkdoor Quantity)])<>"", ToText([Formula show fields with data (Walkdoor Quantity)])))); If($VerticalList <> "", "" & $VerticalList) & "</b>" & "</span>" And: "<span style=\"font-size:11px;\">" & "<b>" & var text VerticalList = (List ("<br />", If(Trim([Formula show fields with data (Windows Quantity)])="",ToText ([Formula show fields with data (Vents Quantity)]), ToText([Formula show fields with data (Windows Quantity)])), If(Trim([Formula show fields with data (Vents Quantity)])="", ToText([Formula show fields with data (Walkdoor Quantity)]), ToText([Formula show fields with data (Vents Quantity)])), If(Trim([Formula show fields with data (Walkdoor Quantity)])="", ToText([Formula show fields with data (Shutters Quantity)]), ToText([Formula show fields with data (Walkdoor Quantity)])))); If($VerticalList <> "", "" & $VerticalList) & "</b>" & "</span>" ------------------------------ Mike Klausing ------------------------------Re: Save and next tab button
I have put the single quote back in and the error doesn't change. As far as I can see it's exactly the same otherwise. Thank you, Mike Klausing ------Original Message------ Mike you have =") in the second line and you are missing the first single quote "') ------------------------------ jason johnson ------------------------------Re: Save and next tab button
This is what it gives me Thank you, Mike Klausing ------Original Message------ Mike, SaveAndNextTab.js is a code page. The rest of the code blurb is in a "Formula - Rich Text" field. Regarding debugging, try the following: Make sure your field is "Formula - Rich Text." In Rich Text, we're making a button using an anchor element instead of letting QuickBase do it for us through a URL field. Your original syntax looks "Formula - URL"ish. That might result in a QuickBase syntax error. Hover over the button in QuickBase and look at the bottom left corner of your browser window. This will give you a preview of the code that will execute on click This is helpful verifying what QuickBase is actually making with the formula. Make sure everything looks correct there. javascript execution in QuickBase is very strict when it comes to no spaces. Correct Syntax Result Incorrect Syntax Result (special character trimmed everything after "getScript(") Open the developer tools of your browser (F12), access the Console, and watch it when you click the button. If there is a JavaScript error or something isn't working as expected, an error will often appear in the console log. If all else fails, could you attach a screenshot of the syntax error? Is it in the QuickBase field or the JavaScript page? I'm interested to see your solution. Maybe there's an App Setting I'm missing. Thanks, ------------------------------ Evan Westbrook PRIME Developer Harder Mechanical Contractors Inc. Portland OR ------------------------------
