ContributionsMost RecentMost LikesSolutionsRe: What is EDI? Can Quickbase help?Much appreciated. That is kind of what I am hoping I can do with quickbase - create a file (csv or other) that maps to their fields. The issue I have is their EDI developer has a bad reputation with vendors, overbilling, poor communication, etc. And they will not even talk to us unless we sign a contract with them, which no way I am doing, since the top complaint on BBB is related to contracts. Thanks for the advice. ------------------------------ Ryan Haberman ------------------------------ Re: Locking a Dropdown field based on a selection in another field.Not sure if this is helpful but we control all of our status fields with automation triggers. So in your case creating a record triggers Status "pending" selecting a user as Team Member changes status to Status to Assigned and set Check Box Assigned? to True. So the next trigger would include a condition that looks at the Assigned? check box and only moves forward if it is true. Basically, you make status dependent on other factors. The danger with this is you REALLY need to know all the possible scenarios AND make good notes as to what happens when and why so that if your process changes in the future you can update according unlike me who was having users complain "it's broken" because they found a way to skip steps in the automation. Also automations are being phased out (I think, has this changed?) so doing this in pipelines may be better. ------------------------------ Ryan Haberman ------------------------------ What is EDI? Can Quickbase help?Hi there, A client is pressuring us to sign up for an EDI service with SPS Commerce. I tried doing research and just feel dumber than I already do looking at database stuff. I want to keep working with this client so I am wondering if there is a way I can be "EDI compliant" using QB? I do not need end to end integration just enough to allow me to keep working with this client <20 orders per year but avoid the middle man (the BBB reviews are not kind). Is this something a developer could help with / does anyone have experience with SPS commerce or similar integration? According to SPS DevCenter they use "Retail Standard XML (RSX)" Thanks in advance for your help, -Ryan ------------------------------ Ryan Haberman Making developers crazy since 2008 ------------------------------ Re: Rich Text Formulas Using Numeric IfsSo Rounding the whole argument totally worked!!!! Thank you. That was actually one of my early thoughts so I added a .01 round to the formula in [Final Sale Price] and made sure the PO fields were currency 2 decimal places and treated blanks as Zero, which as I type this may be the issue. Since some are blank it might have tried 0 NOT 0.00. Either way it works now so thanks! Rich Text Formulas Using Numeric IfsHi Let me first start with thanks to everyone who posts in these forums I have learned so much from you. I do NOT code but I am real good a trial and error also google. So you have been a life saver. I am trying to use a rich text field to test conditions and give TEXT response. Like are these 2 things equal if not "BAD" if yes then check the next condition and so on. I think my problem is I am mixing numbers from calculated fields and summary. I have read about needing ToText, etc. I get the same answer, TRUE even when it should be false I have tried so many permutations of this: Final Sale Price is a Numeric Formula that resolves currency rounded .01 the PO fields are manual entry Numeric Currency Fields I have tried a ton of stuff but here are just some: If([Final Sale Price]-[PO Product Total]-[PO Install Total]-[PO Shipping Total]=0,"Good","Bad") If([Final Sale Price]-[PO Product Total]-[PO Install Total]-[PO Shipping Total]<>0,"Bad","Good") If(ToNumber([Final Sale Price]-[PO Product Total]-[PO Install Total]-[PO Shipping Total])=0,"Good","Bad") If(ToText([Final Sale Price]-[PO Product Total]-[PO Install Total]-[PO Shipping Total])<>"","Bad","Good") Thanks in advance for your help. Also if there is a complete guide Rich Text that would be awesome!!! ****Also also huge shout out to Styled Text Formula Builder Created By Brian Cafferelli If you do not know how to code but want to add some color or change fonts this thing is the best! Inetegrate 3CX phone system into quickbaseHi I am looking for a new phone system. I am leaning towards 3CX but want to see if anyone has successfully integrated this into a QB system. 10 Lines with 15 users.