Jump to content

gilbenl

Members
  • Content Count

    25
  • Joined

  • Last visited

Community Reputation

0 Neutral

About gilbenl

  • Rank
    member
  1. I have a db with the following tables, with pertinent fields listed: Locations-pk_LocationID, Location, Bed, Service Observers- pk_ObserverID, ObserverName TimeClock- pk_ClockID, TimeIN, TimeOUT, Date Cases- pk_CaseID, Date, Start Time. Delays- pk_DelayID, DelayCode, Duration For a given record, a location can have one observer, each observer can have multiple cases, but each case has only one observer, and each case can have multiple delays (fixed list of delay codes). For the time clock, each observer can have multiple time clock entries, but each entry can have only one ob
  2. I am at the limit of my knowledge on the issue, but some examples that come to mind: -Measures to prevent editing of clock in/out time values, intentional or accidental (IE: Security) -Means of handling folks failing to clock out -Verification of time in/time out. IE: You don't want someone being able to clock in/out in the middle of the night (when they weren't authorized to work). You can check this after-the-fact, but that isn't ideal, or foolproof. I'm sure there are others in the forum who are far more knowledgeable though...
  3. So the database is used by a group of students to document surgical cases. The observers have no need to see other records; they just enter data. Each session, they download an empty DB file, enter their data, and the script sends me a copy of the now populated DB (.fmp12). I then add the new records to the main DB on my computer. Next time around, they just pull a fresh copy of dropbox and repeat. Side note: If you're using this time sheet to track your employees hours for payroll purposes, you may want to consider one of the many pre-made solutions. You can find yourself with a major
  4. I'm not 100% sure, but I know that I've had problems with InsertCurrentDate and therefore use SetField; Get(CurrentDate). Also, the way your portal is set up may have something to do with it. Not sure if this is the best way to do this, but it has worked for my purposes. See attached. Username is admin with no pass. Now, the question remains as to whether or not your want to have a portal displaying the employees past entries. This is a bit more complicated. However, if you're the only one who will see this info, I suggest creating an admin dashboard. TimeClockExample.fmp12.zip
  5. Show Custom Dialog ["Clock In"; "Are you sure you want to clock in?'] If [Get(LastMessageChoice)=2] Exit Script[] End If New Record/Request Set Field [Observers::Observer; Get (AccountName) ] Set Field [Time Clock::Date; Get (CurrentDate)] Set Field [Time Clock::TimeIN; Get (CurrentTime)] I have a timeclock in my DB and this is the script I have tied to my clock in button. I run it on FM GO on iPhone 4S, 5 and iPad Retina and don't have any issues. How is your timeclock table set up in relation to your DB as a whole?
  6. To answer #2- The purpose of the DB is to collect data on case starts. When the observer arrives in the unit, they input all their cases at once. As delays etc occur, they modify the record as needed, but when finished, they check the "complete" box. When this is checked, it throws a 1 into the complete field. The purpose of the step in question is to check only that day/users records to make sure that they hit complete for every record. If not, it throws them back to a list that shows the incomplete.
  7. This is my first, what I would call, complex script and was hoping to get some feedback on its' efficiency. It is used in a timeclock solution for a filemaker GO "app." It is intended to perform the following actions (same order as in script attached): 1) Verify all records from that date are marked as complete. (eg: Cases::Complete=1) 2) If okay, go to time clock, sort based on "time out," making sure the most recent record is empty. If not empty-->display error, unsort 3) If empty, time out as current time 4) Email copy of entire DB. It performs all of these actions wi
  8. This is my first, what I would call, complex script and was hoping to get some feedback on its' efficiency. It is used in a timeclock solution for a filemaker GO "app." It is intended to perform the following actions (same order as in script attached): 1) Verify all records from that date are marked as complete. (eg: Cases::Complete=1) 2) If okay, go to time clock, sort based on "time out," making sure the most recent record is empty. If not empty-->display error, unsort 3) If empty, time out as current time 4) Email copy of entire DB. It performs all of these actions wi
  9. I'm fairly new to this, but I am currently doing something similar so I might have a solution. I would suggest doing the following: Create a table and populate one field with your list of codes. Then, create a number field, "Relevant." Go through your list, and for each one you want to be on the "relevant" list, put a 1 in the relevant column. Relate this table to others as necessary Next, create a filter script that will filter out records without a "1" in the relevant field. In your data entry layout, tie a dropdown list to that list of codes. When prompted to chose values, select us
  10. I've made great progress in my DB thanks to the help I've received thus far, but now I've hit another wall...so, I'm back. For each record, you can have 1-5 delays, as seen here: Delays.tiff You will notice that the delay "codes" are a pair of numbers, with a text description. The field is set to number, FYI. The first digit denotes to which group that delay belongs to. For example, delay #11 is in Group 1 (patient related delays). As I described earlier, some cases have 3 delays, each from a different group, where as some have 3 delays, of which multiple belong to the same group. Wha
  11. Edit: May have figured out the root of the issues. Edit 2: Definitely figured it out...relationships click, portals are neat, mind blown...woo! Relationships1.tiff So now I have an empty database with all the same fields, but correct relationships, and a full data base with inappropriate formatting. Is there any way to transfer entire fields between tables, or will I have to create an entirely new DB and custom import the old one, or manually enter all 150 existing records?
  12. I went ahead and tested it by extending it through 100 rows. Seems to respond appropriately, but will keep an eye out going forward. Thanks to your help, I was able to make considerable progress on the DB and it's beginning to come together. Unfortunately, there are two elephants remaining: First is how to effectively quantify the delays. For each record, the observer may enter up to 5 individual delay "codes" in the fields labeled delay 1-5, with one delay per field. Delays are entered by selecting the desired "code" from a drop-down list populated by custom values. The custom values are
  13. Outstanding! Thank you, sir! The website is also a phenomenal resource as well. Just to help out the next guy who comes through looking for this, the actual function I put in is: c_WeekStart=Let ( nY = Date ( 1 ; 1 ; Year(Get(CurrentDate))) ; nY - DayOfWeek ( nY ) + 7 * WeekNumber - 5 ) c_WeekEnd=Let ( nY = Date ( 1 ; 1 ; Year(Get(CurrentDate))) ; nY - DayOfWeek ( nY ) + 7 * WeekNumber - 1 ) Where WeekNumber is a auto assign number field 1 to 52. Output is the Monday and Friday of each week, respectively. Credit for the function and additional resources can be found here: h
  14. Interesting...I thought the method for finding month boundaries seemed a bit too complex, but it made sense. The method you suggest also works and is much simpler, so it sticks. For my own education, could you explain how the calculation you suggest takes into account months with less than 31 days? Is this inherent in the Date( ) function? As for the week, I'm a bit confused. I would like to create a report similar to the months but by week. I assume that would require a table with 52 entries, just as the month required a table with 12. It follows then for each of the 52 Week numbers, I
  15. Using this tutorial (http://www.anvildataworks.com/?p=554/) I have managed to produce a series of reports by month. These include basic counts and percents, nothing too fancy. Now, I would like to do the same thing, but display this same data by week or day. The end goal is to have a tabbed dashboard which would display running data by month/week/day, but will also allow specific months/weeks/days to be selected. To achieve this for the months, I created a months table with 12 entries. Each has a DateStart and DateEnd, which are calculated by the following, respectively: DateStart=Mont
×
×
  • Create New...

Important Information

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