Jump to content


  • Posts

  • Joined

  • Last visited

jbullydawg's Achievements


Enthusiast (6/14)

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

Recent Badges



  1. How do I set up a script that will allow me to search for two different data values in one field? For example, I have a 'Building' field that contains building names. I want to run a script that displays a report on two, and only two, of those buildings but I can't figure out how to search the same field twice. Thoughts? Thanks!
  2. jbullydawg


    We have a Registrant table and a Program table in our non-credit database and I'm having an issue trying to filer the list of registrants in the portal that resides on the Program layout. Each registrant in the Registrant table has a status within the program; Active, Completed, or Cancelled. The Program table contains a portal displaying all those that have registered for the program. I would like to filter the portal out to only display those registrants that are listed as Active in the Registrants table and I'm not sure how to do that...if it's even possible. Thoughts? And sorry for the newbie question. Thank you.
  3. I have a database that tracks CEUs for teachers and have a question regarding how to script something. I have a Course table and a Student table. To bring them together I created a registration table for the purposes of placing students in their registered courses. I want to be able to check that a student is not registered for the same course more than once at the time the student is registered. For example, I have already been registered for Course X but a colleague of mine doesn't know that and tries to enroll me in the same course. What check can be run so that my colleague is notified of the duplication? Thanks!!
  4. As a side note, I ran Recover on the file and it deleted all those records whose data went missing. That was not the outcome I was hoping for. Any advice is greatly appreciated.
  5. We have an odd problem plaguing one of our databases. Out of the blue over 200 records have cleared themselves leaving empty fields in every field. However, if you do a search for a name whose record was cleared it finds it and takes you to the empty record. In FileMaker 8.5 all the fields are empty but in FM 9.0 they all have a question mark in them. Any ideas on what is going on here?
  6. I would love to build the database that way but the primary identifier is a problem for us: 1. We can't keep SSNs on file. 2. Alot of our registrants are good 'ole boys and they don't have email addresses. 3. some of our programs only require name and phone number for registration. It's a hodge-podge of information gathering. I've asked in the past if we could make email addresses mandatory for purposes of a primary key but I was laughed at and given the same explanation as above. Come to find out, it was true...most of our registrants for out non-credit courses are 'in the field guys' and don't worry themselves with email. That's why this report is so hard.
  7. In our non-credit database we track programs and registrants. Pretty straightforward. In our registrant table we track the date they registered and have 3 fields for payments (Payment 1, Payment 2, Payment 3) and the date of the payment (Date Rec. 1, Date Rec. 2, and Date Rec. 3). Rarely does any registrant make more than one payment but it has been known to happen. So here was the request made of me: Build a report that counts all of the registrants in each program that registered in a certain timeframe as well as provide the total payments made during that same timeframe. Now, I can search through the 3 payment dates and isolate only those records that have payments in that timeframe. My problem is that I don’t know how to get a total of only those payments made during the given timeframe. For example: Payment 1 – 8/31/2007, $200 Payment 2 – 9/1/2007, $200 Payment 3 – 9/3/2007, $200 If the user wants the report to only reflect those payments made between 9/1/2007 and 9/30/2007 this registrant’s contribution would only be $400. However, the report totals $600 for this student toward the course's total for all its students. So, here’s what I have done so far: [color:red]Show Custom Dialog (asks for gStartDate and gEndDate) Enter Find Mode Set Field [Registrant::gSearchText; Registrant::gStartDate&”...”&gEndDate] Set Field [Registrant::Date Rec 1; Registrant::gSearchText] New Record/Request Set Field [Registrant::Date Rec 2; Registrant::gSearchText] New Record/Request Set Field [Registrant::Date Rec 3; Registrant::gSearchText] Perform Find [ ] Go To Layout [“Course Contributions” (Registrants)] Sort Records (blah, blah, blah) Enter Preview Mode The report has the following fields: Course No., Course Name, CountRegistrants, SummaryTotalPayments This accurately identifies the records with payments made in the given timeframe and gives me the count of registrants for each course. However, I have no idea how to total only those payments in the given timeframe for each course. PLEASE HELP, this is driving me crazy!!!
  8. I'm not sure this is the right place for this question so if not please let me know. I'm working on a marketing system that allows the user to request a new job and view their current and old jobs. However, I don’t want the user to be able to request a job on a day that is already full with other job requests. So, what I have done is had the marketing unit assign a numerical time to the jobs that they do (ex. Brochure = 12 hours of work). When the user makes his/her request the system will check the day and if the job can be completed on that day, based on all the other jobs turned in, it will allow the request to go through. If the job can’t be completed on that day the system requests a new date for completion or suggests making an appointment. Ok, that’s the goal. Yes, we could buy a calendar system but our budget is not such that we can just purchase items whenever we want. Sad, I know. So, I have a couple issues that have been plaguing my progress on this project: 1) If a job takes more than one day to complete how can I assign those hours to multiple days. For example, a brochure might take 12 working hours to complete. If there are only 8 hours in a work day how do I go about pushing the additional 4 hours into the next day? 2) Is there a way to assign 8am to 5pm, Monday through Friday, as the only hours of the day and of the week under consideration for this system? To give a better idea of the job request function the following is a brief synopsis of how it will work: 1)User enters date they want job completed and the job type. 2) System checks that date and considers the following: a. hours already assigned to work that day (dayjobhours) b. requested hours to be added to that day (reqhours) c. totalhours = dayjobhours + requhours i. If (totalhours > 8; "Date Full") ~ user will be given an option to enter in a new date or schedule an appointment for further assistance ii. if the totalhours is less than 8 then the request is accepted and the user is notified of that fact I’ll take any help or recommendations for changes anyone can give. I feel like I have grown a great deal in the past couple of years when it comes to design and development but when it comes to dates and times I’m still a bit of a novice. Thank you!
  9. Can anyone recommend a good calendar plug-in for, essentially, events scheduling. It would actually be used to schedule and monitor graphics design 'jobs' being done by our designer. I want the user to be able to see what dates are unavailable to schedule a 'job' and for the designer to be able to tie individual 'job' records to the calendar. Thanks.
  10. Nevermind!! I got it to work. Thanks, mr_vodka.
  11. I'm having an issue with my script so if anyone can straighten it out I would be much appreciative. This is the important part of it where the issues lie: [color:red]Show Custom Dialog ["Automated Seach"; "Enter the start and end dates for your search:"; YourTable::gStart; YourTable::gEnd] If [Get(LastMessageChoice) = 2] Exit Script [ ] End If Enter Find Mode [ ] Set Field [YourTable::DateField01; YourTable::gStart& "..." & YourTable::gEnd] Perform Find When the report comes up instead of giving me a the date like this, "07/01/2007 - 07/31/2007" I just get the start date. Now I did try and set a global field after setting the actual date field but the global field only shows up on certain pages, which is just plain weird. Also, DateField01 is a date field which likely explains why it won't give me the full range on the report but how do I set the script up to search within that field and set another field to display the range?
  12. mr_vodka, One more newbie question. Can you explain a particular portion of your response? In the script you said use [YourTable::DateField01; Value: v& ".." & YourTable::gEnd] instead of the final Set Variable section. I understand that but I don't get part of this function you have provided. I've never used or seen "Value: v&". What is that and what does it do? Thanks so much for your help. It's nice to know there's people like you and everyone else that's aided me in the past that want to help and do so. It has bettered not only my base knowledge but my unit here at work as well. Thanks.
  13. [color:red]Show Custom Dialog ["Automated Seach"; "Enter the start and end dates for your search:"; YourTable::gStart; YourTable::gEnd] If [Get(LastMessageChoice) = 2] Exit Script [ ] End If Enter Find Mode [ ] Set Variable [$Criteria; Value: YourTable::gStart & ".." & YourTable::gEnd] Set Field [YourTable::DateField01; $Criteria] Am I on the right track? I'm not sure how to put it in the format I mentioned.
  14. In a database we use to record bank deposits there is a date field for when the deposit was made. I have a report to make that just gives details about deposits over a period of time. My issue is this: The user can input a date range to generate the report. I would like to display the chosen date range in the header of the report. For example, if in the date deposited field the user were to type 07/01/2007...07/31/2007 I would want the following to display in the header of the report: 07/01/2007 - 07/31/2007 I'm sure there's an easy way to do this but I can't seem to find it. Any ideas?
  15. I have a field that I want to use to record the account name of the user who modifies a refund field. The calculation looks like this: [color:red]Case ( Refund = "Yes"; RefundEnteredBy = Get ( AccountName ) ) By default the refund field is set to 'No'. Therefore, if the user changes that to 'Yes' then I want the RefundEnteredBy field to record who changed it. So far, all this does is return a zero and not the account name. I've tried altering this many different ways with the exact same result. All zeroes. Any thoughts? Thanks.
  • Create New...

Important Information

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