ContributionsMost RecentMost LikesSolutionsRe: Trying to Capture a dollar value in a Numeric Field (Currency) such that . . .?Mark, Thanks for the input! I don't know how to do as you have suggested. I don't see any check boxes on the Numeric (Currency Field) to "Initialize" the data to that field. I tried unchecking the snap shot to see if I could see an Initialize checkbox. Could not find. Here are some images of what I have - maybe that will help reveal what I am doing wrong. I can send other screen shots if that will help solve the mystery. Thanks for your help! Stan ------------------------------ Stanley Melling Director - Special Projects & New Frontiers ModTruss, Inc. Fond du Lac WI 844.663.8787 ext. 715 ------------------------------ Trying to Capture a dollar value in a Numeric Field (Currency) such that . . .?Hey Y'all, I am trying to capture a dollar value - from our catalog for orders and quotes such that it is a snapshot of the value when the order or quote is created the dollar value on that day an time does not change when the Quick Books (Connected data) price gets updated to a different value. The problem is that we are creating orders and quotes in our portal app with items from our catalog where the retail price is "X" on that day. All well and good - right? No, because when the price point of an item changes in QuickBooks and the sync runs - the price changes to the new price - even on historic orders and quotes. once an order or quote is created with catalog pricing (comes from Quick Books), I need the value of that quote/order to NOT change when the Quick Books sync runs and deposits the new price on everything. UGH! What have I done? I have a field that is a numeric (currency) field labeled " Time Sensitive Unit Price". For that field I have selected "Get this field's value from a lookup field and don't allow the value to change", I have set the Look-up field to point to the "Retail List Price" field. That field is connected back up to Quick Books. In the end - my new (bright idea field - "Time Sensitive Unit Price") remains un-populated with anything at all! What am I doing wrong?? I need help and I don't want to do another trouble ticket. Thanks in advance!! Stan ------------------------------ Stanley Melling Director - Special Projects & New Frontiers ModTruss, Inc. Fond du Lac WI 844.663.8787 ext. 715 ------------------------------ Conditional formatting of a date when it goes overdue.I am trying to conditionally change the text color and make it bold when a task goes past its due date. I cannot figure out how to make the date and/or background turn red when the desired "due date" is equal to "due date"+1 or in other words tomorrow. I have the field set to be a rich text - date field for the due date which is set when the task is added. Example 1: I set a tasks due date for December 25, 2019. Since we are now past December 25, 2019 - I should be able to readily see that that task is now over due by several days. In order to make it clear to the user that her/his task is now overdue I want the report display to show in BOLD and color RED in order to draw attention to the task being overdue. Example 2: I set a task with a due date of January 15, 2020. That task due date should be simple black text. As I approach the future due date it remains (text color) BLACK and not bold. When I arrive at the due date it should turn BOLD and RED. Any help would be much appreciated. Stan ------------------------------ Stanley Melling Director - Special Projects & New Frontiers ModTruss, Inc. Fond du Lac WI 844.663.8787 ext. 715 ------------------------------