ContributionsMost RecentMost LikesSolutionsRe: Add values of a (Text - Multiple Choice)Try something like this in the Formula-Duration field: Hours(ToTimeOfDay([Start Time]) + ToTimeOfDay([End Time]) Not tested, but might point you in the right direction at least. ------------------------------ Ryan Stanford ------------------------------ Re: BOTs are killing my contact form on my website...If I recall correctly, you should just need: If( Contains([Customer Full Name], "http://"), "Customer Names Cannot Contain Web Addresses.") This way, you can look at first name and last name fields together. Might want to simply have http, to capture if it happens to be https:// as well. ------------------------------ Ryan Stanford ------------------------------ Re: BOTs are killing my contact form on my website...Yes, if you go to the advanced settings of the table in QB... I'd imagine you have it named "Customers" or something to that effect. There's a section towards the bottom regarding Custom Data Rules. https://help.quickbase.com/user-assistance/custom_data_rules.html is the QB Documentation regarding it. I'm not sure if it'll work via API, or if it's strictly from a native QB form, but it's worth a shot. ------------------------------ Ryan Stanford ------------------------------ Re: BOTs are killing my contact form on my website...You should be able to add some data validation either to the form or to the table itself. Make sure the fields have valid data, ei: Name doesn't contain "http://" and whatever other criteria you're looking for. Is the form/webpage your own, or is it a code page within QB? ------------------------------ Ryan Stanford ------------------------------ Download report in CSV format to server directlyWe need to pull data as a csv out of QB and to a server which has an automated process that will carry on with the workflow. I know that in browser, having a report's format set to CSV will make it download a csv file, however when this same URL link is in a GET request on the server, it's the same a the API_DoQuery XML response... Anyone have any "tricks" about how I can get the csv file directly? ------------------------------ Ryan Stanford ------------------------------ Re: Color code off a date fieldYou would need, for reporting, a formula - Rich Text field which you could then have the logic based on the date and what color the back ground should be. We have used similar. var number totalDays = [Impact (0-5)]+[Likelihood (1-5)]; var text red = "<a style=\" text-decoration: none; background: #ea4335; border-radius: 5px; color: #fff; display: inline-block; width: 160px; text-align: center; padding: 8px 20px; font: normal 700 14px/1 \"Calibri\", sans-serif; text-shadow: none; \">"&$totalDays&"</a>"; var text green = "<a style=\" text-decoration: none; background: #34a853; border-radius: 5px; color: #fff; display: inline-block; width: 160px; text-align: center; padding: 8px 20px; font: normal 700 14px/1 \"Calibri\", sans-serif; text-shadow: none; \">"&$totalDays&"</a>"; var text yellow = "<a style=\" text-decoration: none; background: #fbbc05; border-radius: 5px; color: #fff; display: inline-block; width: 160px; text-align: center; padding: 8px 20px; font: normal 700 14px/1 \"Calibri\", sans-serif; text-shadow: none; \">"&$totalDays&"</a>"; var text gray = "<a style=\" text-decoration: none; background: #c2c2c2; border-radius: 5px; color: #fff; display: inline-block; width: 160px; text-align: center; padding: 8px 20px; font: normal 700 14px/1 \"Calibri\", sans-serif; text-shadow: none; \">Missing Rating</a>"; (If([Likelihood (1-5)]=0,$gray, (If(IsNull([Impact (0-5)]),$gray, (If([Impact (0-5)]+[Likelihood (1-5)]<=5,$green, (If([Impact (0-5)]+[Likelihood (1-5)]=6,$yellow, (If([Impact (0-5)]+[Likelihood (1-5)]=7,$yellow, (If([Impact (0-5)]+[Likelihood (1-5)]>=8,$red)))))))))))) ------------------------------ Ryan Stanford ------------------------------ Re: Retrieve LookUp valueIf you do a jQuery call already, you could instead just do a API_DoQuery of the parent table, with the fid_21 value being the Record ID, get the Company Name field value from there ------------------------------ Ryan Stanford ------------------------------ Re: How to check length of array and Apply Greater or Less Condition on that array In PipelineThe expression language is Jinja, Jinja2 to be more specific... if you're able to drill down in the pipeline steps to reference the JSONArray, then you should be able to do: {{ a.JSONArray | length }} This isassuming the call is in the a step of the pipeline. ------------------------------ Ryan Stanford ------------------------------ Re: creating specific formula (if, then, else?)The fields generally have a setting where null values are treated as 0, but you can probably also have it where you can set them as variables and go from there: var number inventoryHand = if([Inventory on Hand] > 0, [Inventory on Hand], 0); [Inventory Par] - $inventoryHand ----- Hope this helps ------------------------------ Ryan Stanford ------------------------------ Re: Launch URL Formula with checkboxAre the checkboxes you want to change on the same record/table as the original checkbox? If so, this might be easier to do through Dynamic form rules... or maybe have the checkboxes be formula checkboxes and have the logic in the formulas, just a thought. ------------------------------ Ryan Stanford ------------------------------