Jump to content

Crafty Coyote

Members
  • Posts

    16
  • Joined

  • Last visited

Crafty Coyote's Achievements

Apprentice

Apprentice (3/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges

0

Reputation

  1. Thank you I was able to make it work using the left, middle and right functions.
  2. I have a field that I would like to add dashes in-between certen text. The layout will always be the same, example 52-526T-A-652. This way I would not need to store the dashes.
  3. I have a problem reducing my fraction to there lowest denominator. the calculation I found returns 2/64 instead of 1/32. I found this cal from earlier postings and I am a novice. the user are setting up equipment with the script and results should be in 64th,32nd,16th,8th,1/4th, and 1/2th,I need the fractions to break down to their simplest forms. Case( GetAsNumber(Cut 1Adecimal)<.015625; ""; Mod(Cut 1Adecimal*2;1)<.015625; "1/2"; Mod(Cut 1Adecimal*4;1)<.015625; Round(Cut 1Adecimal*4;0) & "/4"; Mod(Cut 1Adecimal*8;1)<.015625; Round(Cut 1Adecimal*8;0) & "/8"; Mod(Cut 1Adecimal*16;1)<.015625; Round(Cut 1Adecimal*16;0) & "/16"; Mod(Cut 1Adecimal*32;1)<.015625; Round(Cut 1Adecimal*32;0) & "/32"; Round(Cut 1Adecimal*64;0) & "/64")
  4. I am new to fileMaker and need some help with a problem. I would like to use a calculation to validate field B and if it fails display a message. My calculation is: not(IsEmpty(field A)and IsEmpty(Field so if they forget to place data in field B and Field A has data the message comes up. I can't get this to work, help.
  5. Here is the code: ALLOW USER ABORT [OFF] SET ERROR CAPTURE [ON] GO TO RECORD/REQUEST/PAGE [FIRST] LOOP IF[(FLEXO LOG::DATE 1 >= FLEXO LOG::START DATE AND FLEXO LOG: DATE1 <= FLEXO LOG END DATE) AND FLEXO LOG::PRESS NUMBER = PRESS#] GO TO RECORD [NEXT;EXIT AFTER LAST] ELSE OMIT RECORD GOTO RECORD [FIRST] END IF END LOOP Thanks Vich for helping again, my escape will not stop the scrip, I have to hit the X. I hope you have a nice weeking. Leroy
  6. When I excute the script it stays in the loop, I have to close FileMaker to end the script.
  7. Thank you both for the help, I started with RalphL find first and it works great. I am very new to file maker and will also try Vich's method. I also will need to remove records that have invalid date in some fields. Here is the code so far I would appreciate if you both help me again. Let me know if you need to see my code.
  8. Thanks for helping me, If possable search for a certain customer between the date range, or a press between the date range.
  9. Help Please! I am trying to create series of reports to show production waste from a two printing presses sharing the same database log. I would like to provide a menu with buttons for the user to choice from. All searches would need to search between certain date ranges along with other criteria. I have two global fields for start date and end date then would need to search for a certain press number, press and customer ect.
  10. Hi I am new to scripts and filemaker. I am trying to create a scrip that would create a duplicate record but only copy certain fields from that current record.
  11. Thanks you for your patients, I am very new to this and you are correct in what I am looking for. someway to trigger a script in a field calculation. I will try these and let you know how they work. Thanks
  12. I am very new to File Maker Pro, I am trying to initiate a script automatically from a field
  13. Thanks you for the help I still need some guidance so let me give you a better example. I have 6 fields, Perpetual Start Perpetual Stop Total Footage Footage Used Field Validation Error Message (Footage Used) is a calculation [Prep Stop - Perp Start]. If (Total Footage) is greater than (Footage Used) I would like some type of error message. I created a script that works, If Field Validation = 0 Beep Show Message
×
×
  • Create New...

Important Information

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