Jump to content

rgnelson

Members
  • Posts

    16
  • Joined

  • Last visited

rgnelson's Achievements

Apprentice

Apprentice (3/14)

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

Recent Badges

0

Reputation

  1. Good call! I think you've been doing this a while and I'll bet you've been down this road. My original post was about and open and closed status. I have built a layout that will open and close the job ticket. If the ticket is past due then it should be finished. Then the admin should close the ticket. That is not allways the case. some jobs just hang on forever. They just don't ever die. lol Any ideas off the top of you head that I could run with would be much appreciated. I am new to FileMaker. This is my first solution. I'm sure you noticed. ;- ) Thanks again for working with me!
  2. So here is the final. :- ) If you can think of any thing else that would totally send it over the top, I'll add it! Thanks for hanging with me on this one. I learned a lot! Evaluate("TextColor(JT_Due_Date & " & Let(T = JT_Due_Date - Get(CurrentDate); Case( T < 1; "" - Due Today"; RGB ( 175 ; 65 ; 65 ))"; T < 2; "" - Due Within 2 Days"; RGB ( 180 ; 140 ; 53 ))"; T < 14; "" - Due Within 2 Weeks"; RGB ( 8 ; 99 ; 87 ))"; T > 14; "" - You Have All The Time In The World"; 0)") ) ) Thanks, RGNelson [edit] I added a spot for past due jobs. Evaluate("TextColor(JT_Due_Date & " & Let(T = JT_Due_Date - Get(CurrentDate); Case( T < 1; "" - Your In Big Trouble - This Job Is Past Due"; RGB ( 175 ; 65 ; 65 ))"; T = 1; "" - Due Today"; RGB ( 175 ; 65 ; 65 ))"; T < 2; "" - Due Within 2 Days"; RGB ( 180 ; 140 ; 53 ))"; T < 14; "" - Due Within 2 Weeks"; RGB ( 8 ; 99 ; 87 ))"; T > 14; "" - You Have All The Time In The World"; 0)") ) )
  3. You had to switch the let and the TextColor? Just for kicks? : -) Let(T = JT_Due_Date - Get(CurrentDate); TextColor(JT_Due_Date & If(T < 7; " - HOT") & If(T > 7 < 14; " - GETTING HOT") & If(T > 14 < 21; " - NOT SO HOT"); Case(T < 7; RGB ( 175 ; 65 ; 65 ); T < 14; RGB ( 180 ; 140 ; 53 ); T < 21; RGB ( 8 ; 99 ; 87 )) ) )
  4. Thanks, Again it worked great! I'm having a little too much fun using TextColor. I want to add another twist. This is what I have now that works great: TextColor(JT_Due_Date; Let(T = JT_Due_Date - Get(CurrentDate); Case(T < 7; RGB ( 175 ; 65 ; 65 ); T < 14; RGB ( 180 ; 140 ; 53 ); T < 21; RGB ( 8 ; 99 ; 87 )) ) ) I want to add some text to the date output. If the job is due < 7 days, not only do I want it to show in this color - RGB ( 175 ; 65 ; 65 ), I want to add the word HOT next to the date. So, the output would look like this: 7-14-2005 - HOT I have tried: TextColor(JT_Due_Date; Let(T = JT_Due_Date - Get(CurrentDate); Case(T & "HOT" < 7; RGB ( 175 ; 65 ; 65 ); T < 14; RGB ( 180 ; 140 ; 53 ); T < 21; RGB ( 8 ; 99 ; 87 )) ) ) And This: TextColor(JT_Due_Date; Let(T = JT_Due_Date - Get(CurrentDate); Let(H = "HOT"); Case(T & H < 7; RGB ( 175 ; 65 ; 65 ); T < 14; RGB ( 180 ; 140 ; 53 ); T < 21; RGB ( 8 ; 99 ; 87 )) ) ) But those are not working. Could you point me in the right direction? Thanks
  5. I will give it a go! Thank you for your insight! RGNelson
  6. Thank you for your help. That works exactly how I needed it to! If I have a date of an upcoming deadline; for instance, if a job is due 3 weeks from now the date would be "07-21-05" with the color 0,0,255. If it were due this week the date would change to a color of 0,255,0. If it were due tomorrow the date would change to a color of 255,0,0. How would I go about doing that? Thanks
  7. I have a field, RP_Status, that is a radio button set with a custom value list. There are two options, "Open " and "Closed". I am attempting to bring those into a calculation field, RP_Status_In_Color, with this calculation: If ( "Open" ; TextColor ( RP_Status ; RGB ( 0 ; 255 ; 0 ) ) ; TextColor ( RP_Status ; RGB ( 255 ; 0 ; 0 ) ) ) This is not working. Can someone tell me why this is not working? And could someone point me in the right direction? Thanks!
  8. Thanks for your reply! I haven't gotten this YET. lol So, I have a field JT_ID_And_Name_If_Active set as a calculation with this code in the calculation: If(JT_Status = "Active"; Job_Number & " - " & JT_Name) On my layout, I have the field AM_JT_Project_Name set as a popup menu. The popup menu is set as Display Values From: JT_ID_And_Name_If_Active What I get on my layout is <no values defined> I'm stumped. Thanks for any suggestions.
  9. I am trying to create a job ticket solution. I have a Job_Ticket table and I have an Archive_Manager table. The way I have it set up is after the job is done, the user goes to the Archive Manager to close the ticket and archive the job. In the Job_Ticket table I have: A serial number field. (Job_Number) I have a text field. (JT_Name) In the Archive_Manager table I have: A popup menu to show all jobs from (JT_Name) that inserts into a field (AM_JT_Project_Name). A radio button field (JT_Status) where the user selects Active or Closed. In another layout I want to have two popup menus: 1) That shows all jobs with their job number. I got this working like I want it using this claculation: Job_Number &" - " & JT_Name 2) That shows only Active jobs: How do I use the JT_Status field to show only Active jobs? Is it and if statement or something else? if (JT_Status = Active) & Job_Number &" - " & JT_Name This is not working, could someone show me the correct calculation to do this? Thanks for any help.
  10. Thanks. Just what I needed. I appreciate the point in the right direction.
  11. Thanks for the reply! I will have a look.
  12. I've created a new layout. I copied and pasted some items from a provided template. If I close the database and reopen it, I get this error: "This action cannot be performed because the required table is missing" Everything seems to work fine - inserting records, serching, printing... It's like it is trying to run a script when it opens. Is there any way to "show all scripts used"? Or something like that? Any ideas on how I can troubleshoot this error? : / Thanks in advance
  13. Thanks for your reply! I will go back to the book.
  14. Thanks for the reply. What I want to do, and there may be an easier or better way, is use the canned Purchase Order, Task managment, and Asset management databases that come with Filemaker along with another database that I created. I would like for there to be relationships between the four. Do I need these in one db as 4 tables or can they be in seperate dbs? Can I relate some of the tables in one file's db to othe tables in anothers db?
  15. Thanks for the reply! Filemaker is very user friendly and slick. I look forward to working with it. This is my first snag. I am a MySQL user and I am doing this project for someone that likes Filemaker. It's hard to believe that in a free open source software you can dump, move, import and export data at will, but an application like Filemaker that cost hundreds of dollars won't let you copy from one database to the other. I must be missing something. Again I am new to filemaker. Thanks!
×
×
  • Create New...

Important Information

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