ContributionsMost RecentMost LikesSolutionsRe: API Tool In ExcelGaurav, please email me at kenfirch at yahoo.com for more help. I also updated the Excel files to work on both 32 and 64 bit, which should fix the complie error. https://www.dropbox.com/s/ebfvyd4ip2cwnup/QB_API.xls?dl=0 https://www.dropbox.com/s/4x7jt5nzx54p5cl/QBDownload.zip?dl=0 Ken jQuery Tabs On New Dashboards?On the new Quickbase dashboards, will the old jQuery Tabs still work? They've actually worked pretty well for us, having the ability to have a LOT of links without using a lot of screen space. Thanks! <div id="tabs"> <ul> <li><a href="#tabs-1">Tab 1</a></li> <li><a href="#tabs-2">Tab 2</a></li> <li><a href="#tabs-3">Tab 3</a></li> </ul> <div id="tabs-1"> <p>Table of Tab 1 links below...</p> </div> <div id="tabs-2"> <p>Table of Tab 2 links below...</p> </div> <div id="tabs-3"> <p>Table of Tab 3 links below...</p> </div> <script type="text/javascript"> $(function() { $("#tabs").tabs({collapsible: true}); }); </script> </div> Re: How to change read-only form field from code?Just a little more info on this. Field #26 is the checkbox, and #17 is a text field to hold the signature. Here's a piece of the code: // Project Manager Signature $("#_fid_26").change(function() { if($("#_fid_26").is(":checked")) { $("#_fid_17").val("Signature Text"); }else{ $("#_fid_17").val(""); } }); As long as the signature field (#17) is not set to read only, it works fine. When set to read-only it doesn't work.How to change read-only form field from code?I have a form with a lot of signature fields. Basically the user checks a box and it populates a field with their name and date/time stamp as an electronic signature. The signature field is read-only on the form, and a rule is in place for each to act when the checkbox is changed. Works, great, except I want to reduce the number of rules and use them for other purposes. So, I added the IOL technique, which works if the signature field is not set to read-only. Is there a way to change a read-only form field from the IOL Javascript? Thanks!Re: Need Help with Annual Date FormulaYou would have to use a formula text field for that: var date thisyear = Date(Year(Today()),Month([Hire Date]),Day([Hire Date])); var date nextyear = Date(Year(Today()) + 1,Month([Hire Date]),Day([Hire Date])); var number dayscount = If($thisyear >= Today(), ToDays($thisyear - Today()), ToDays($nextyear - Today())); If($dayscount <= 90, "<span style=\"color:red;\">" & ToText ($dayscount) & "</span>", "<span style=\"color:black;\">" & ToText ($dayscount) & "</span>") You lose some filtering by numeric ability using this method, but you could display the "red" records by setting a filter on this field that contains a "red" value.Re: Need Help with Annual Date FormulaFor a formula duration field: var date thisyear = Date(Year(Today()),Month([Birth Date]),Day([Birth Date])); var date nextyear = Date(Year(Today()) + 1,Month([Birth Date]),Day([Birth Date])); If($thisyear >= Today(), $thisyear - Today(), $nextyear - Today())Re: Compare two text fields.Formula could be: If(Lower(Trim([Customer - Enrollment - Meter Number] & "")) <> Lower(Trim([Customer - Meter number] & "")), "Mismatch") To display only mismatched records, create a report and set the Filter to where that formula field = Mismatch. This assumes you have entered both meter ID's. You may want to check for incomplete data also: If Trim([Customer - Enrollment - Meter Number] & "") = "" OR Trim([Customer - Meter number] & "") = "", "Missing Meter Info", If(Lower(Trim([Customer - Enrollment - Meter Number] & "")) <> Lower(Trim([Customer - Meter number] & "")), "Mismatch"))Re: % Completed buttonThe original post didn't have any fields names. The sample formula given used fictitious names since it's an example formula. In a real app you could use numeric summary fields of the related details table. Use your own field names as needed.Re: % Completed buttonIt sounds to me you are not looking for a button, but display a simple progress bar based on another numeric field. Here's a formula to create one via a html enabled formula text field: // Draw basic progress bar. PctDone must evaluate from 0 to 10. var Number pctdone = Round(If([Action Count]=0,0,([Action Count] - [Incomplete Action Count]) / [Action Count]) * 10); var Text gry = "<img src=\"https://images.quickbase.com/si/16/226-rect_gray.png\"</img>"; var Text grn = "<img src=\"https://images.quickbase.com/si/16/228-rect_green.png\"</img>"; Case($pctdone, 0, $gry & $gry & $gry & $gry & $gry & $gry & $gry & $gry & $gry & $gry, 1, $grn & $gry & $gry & $gry & $gry & $gry & $gry & $gry & $gry & $gry, 2, $grn & $grn & $gry & $gry & $gry & $gry & $gry & $gry & $gry & $gry, 3, $grn & $grn & $grn & $gry & $gry & $gry & $gry & $gry & $gry & $gry, 4, $grn & $grn & $grn & $grn & $gry & $gry & $gry & $gry & $gry & $gry, 5, $grn & $grn & $grn & $grn & $grn & $gry & $gry & $gry & $gry & $gry, 6, $grn & $grn & $grn & $grn & $grn & $grn & $gry & $gry & $gry & $gry, 7, $grn & $grn & $grn & $grn & $grn & $grn & $grn & $gry & $gry & $gry, 8, $grn & $grn & $grn & $grn & $grn & $grn & $grn & $grn & $gry & $gry, 9, $grn & $grn & $grn & $grn & $grn & $grn & $grn & $grn & $grn & $gry, 10, $grn & $grn & $grn & $grn & $grn & $grn & $grn & $grn & $grn & $grn )Re: API Tool In ExcelGaurav, I also use Office 2013 (15.0). Below lists the VBA references used, which are very common. Make sure they are available on your device. Ken