DanMcLaughlin
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Quickbase to google calendar pipeline issue
I have a pipe line set that manages my calendar installs to a google calendar. It has 3 pipelines New install are added changes in installs are updated deleted install are deleted. The path flow work great but the dates are not correct. Here is the quickbase calendar Here is the Google Calendar: Start Date and End dates are date/time fields built with the following: Does anyone have any ideas why these dates are distorting by a day?QUICKBOOKS BILL PAYMENTS PARSING
I have have app that my team can monitor Quickbooks activity without letting the entire user team into our accounting. I have a connected table to Bill payments. When I try to set up a report link In by Bills table I have to mine a record in the Quickbooks table that has the Bill ref # and applied amount. Once Record looks like this: [(null,null,null,'978.00',{('162021','Bill',null)},null)] 978 is the applied amount 162021 is the Quickbooks bill ID Multiple records look like this: [(null,null,null,'97199.28',{('163251','Bill',null)},null), (null,null,null,'37784.30',{('163351','Bill',null)},null), (null,null,null,'8100.00',{('163364','Bill',null)},null), (null,null,null,'12658.44',{('163352','Bill',null)},null), (null,null,null,'1092.00',{('163432','Bill',null)},null), (null,null,null,'1103.00',{('163433','Bill',null)},null), (null,null,null,'130.00',{('163439','Bill',null)},null)] How do I parse this into a Useable Form? I need [DATE],[Bill ID],[And Applied amount]. in a table that I can plug into my Bill View.Print Rich text field
I having issues trying to get my rich text filed to print as they appear: This is what I want This is what I get: Code Below: var text Bcolor= Case( [Blg ##],1,"#FF00FF",2,"Green",3,"F87A17",4,"#0000FF");//#4E9258 var text tcolor= Case( [Blg ##],1,"#FFFF00",2,"#FFFF00",3,"FFFFFF",4,"#000000"); var text STYLE = List(";", "background:"& $Bcolor, //button color "color:"& $tcolor, //text color "text-align:center", //text alignment //"text-decoration:bold", //none, underline, line-through "font: 36px Calibri", //text size, font, style //"border: 2px solid #0000FF", //border width, style, & color //"border-radius: 80px", //roundness of button corners "width: 275px", //button width "padding: 60px 60px") //space between text & button ; "<div style='" & $style & "'>BOX# "&[BOX ID#]&" <br /> TB-"& [Blg ##]&"</div>" Any Ideas? ------------------------------ Dan McLaughlin ------------------------------Barcoding and key fields
I have 3 tables objects >pallets >and containers When the employee add a new object they need 2 populate 2 fields first field is a picture of the object second field is a barcode (number) selected randomly from a stack of preprinted labels This entry goes pretty well until... Palletizing Now I go to the pallet table and I have 2 problems I cannot lookup the barcode from the object as it is not a key field. In other systems I would set up a foreign key . I need the pallet record to stay open and allow me to point an click at all off the objects with the barcode scanner without additional screen commands. ( I need something akin to add new record and go to control on update) looking for ideas. Similarly I need to associate pallets that have assigned QR codes to respective containers for shipment. Any suggestions here are greatly appreciated ------------------------------ Dan McLaughlin ------------------------------Mobile button save and add
I have an add record form for a barcoding application. I have one receipt to many objects. Users would enter a receipt then add object records to take a picture of each object and assign a barcode. The button works great in desk top but the record id from the parent doesn't go to the child in the mobile app. any ideas here? code for the button: var text STYLE = "background: green;" & //button color "color: white;" & //text color "text-align: center;" & //text alignment "text-decoration: none;" & //none, underline, line-through "font: 18px Calibri, sans-serif;" & //text size, font, & style "border: 3px solid #505050;" & //border width, style, & color "border-radius: 5px;" & //roundness of button corners "width:100px;"& //button width "padding: 5px 50px;"; //space between text & button var text RID = If(IsNull([Record ID#]),"%%rid%%",ToText([Record ID#])); var text URL = URLRoot() & "db/" & [_DBID_OBJECT_PICS]& "?a=API_GenAddRecordForm" & "&_fid_9='"& $RID & "'&z=" & Rurl(); ------------------------------ Dan McLaughlin ------------------------------
