Jump to content

pc302

Newbies
  • Content count

    7
  • Joined

  • Last visited

Community Reputation

0 Neutral

About pc302

  • Rank
    newbie
  • Birthday 01/01/1964

Profile Information

  • Gender
    Not Telling
  • Location
    Delaware
  1. I am seeing if this can be done via a script / global fields . I have gotten blood from a stone, by using my head. I have two issues when the category is empty yet set to print lower left, i get duplicate output, second extra return at the top line of the last category
  2. Thanks for the help both of you. Both answers were very creative. Take Care
  3. Good Day to all Creating a web store data management input screen. to select product categories on the export the result is a calculated field with commas in them the field categoryids equals the fields CatagoryID1 CatagoryID2 CatagoryID3 the first attempt: CatagoryID1 & "," & CatagoryID2 & "," & CatagoryID3 gives me 21,, I need the verbiage for if it is empty don't add the commas.
  4. you were check thank you pam the final code looks like this: Case (Customers::Cust_AppDate1Start ≤ Oe_PlacementDate and Customers::Cust_AppDate1End ≥ Oe_PlacementDate;Customers::Cust_AppRate1; Customers::Cust_AppDate2Start ≤ Oe_PlacementDate and Customers::Cust_AppDate2End ≥ Oe_PlacementDate; Customers::Cust_AppRate2; Customers::Cust_AppDate3Start ≤ Oe_PlacementDate and Customers::Cust_AppDate3End ≥ Oe_PlacementDate; Customers::Cust_AppRate3; Customers::Cust_AppDate4Start ≤ Oe_PlacementDate and Customers::Cust_AppDate4End ≥ Oe_PlacementDate; Customers::Cust_AppRate4) Thanks once again
  5. I hope the this is posted to the right forum I would like to look at the customer master and select a rate based on a date I have four start and stop dates and four application rates defined. I setup a calc. for the new record as follows. Case (Customers::Cust_AppDate1Start ≥ Oe_PlacementDate and Customers::Cust_AppDate1End ≤ Oe_PlacementDate;1 ; Customers::Cust_AppRate1; Customers::Cust_AppDate2Start ≥ Oe_PlacementDate and Customers::Cust_AppDate2End ≤ Oe_PlacementDate;1 ; Customers::Cust_AppRate2; Customers::Cust_AppDate3Start ≥ Oe_PlacementDate and Customers::Cust_AppDate3End ≤ Oe_PlacementDate;1 ; Customers::Cust_AppRate3; Customers::Cust_AppDate4Start ≥ Oe_PlacementDate and Customers::Cust_AppDate4End ≤ Oe_PlacementDate;1; Customers::Cust_AppRate4 ) when I have only the first test it works. Maybe Choose is the answer or revising the case statement or a script with get related record to look at the customer master for that customers application rate. any advice would be appreciated.
×

Important Information

By using this site, you agree to our Terms of Use.