Jump to content

Forum Joe

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Forum Joe

  • Rank
  • Birthday 10/23/1979

Profile Information

  • Gender
    Not Telling
  1. Yes, I do think it is important, hence I've fixed it now. I'm sorry that Filemaker/Database is only a tiny part of my working life and keeping my details up to date on a website I use infrequently is not a priority. Well, all the records are generated at the beginning, but the attendance tables are just portals that can dynamically show the information based on the current found set. So when I say the "attendance tables can be generated from any subset" I mean that the user can select which people she wants in the table, and which meetings she wants in the table, and it generates
  2. Thanks LaRetta! That's awesome. You made me realise I hadn't updated my profile, I'm on 12 Advanced, so some of that stuff will be useful. I've opened up your example and will have a good thorough look when I can make some time. It's very useful stuff!
  3. Yeah, I've just realised that. So it isn't going to work, I'll go back to my repeating field method. That's ok. But the previous setup (in the screenshot) does work and is fully interactive to toggle between ticks and crosses. Saves a lot of hassle but restricts flexibility a little.
  4. No, that picture is a screenshot from Filemaker! It's currently using a portal with a repeating field, but I'm hoping to restructure the db to use a portal within a portal instead to achieve the same (but improved) effect. I don't need to know the exact number of columns and rows, but I do have to manually create a layout with the maximum number of rows and columns. Extra rows and columns just don't get shown if the data doesn't exist, so they show up as blank, which is fine. Just like if you have a portal showing 10 rows but there's only 5 related records. It's not a problem.
  5. Thanks everyone for your assistance. To try to help explain why I'm doing it with this method, let me show you the requirement. I need to be able to generate attendance tables like this: Where the peeople are down the left and the meetings are along the top. More to the point, these attendance tables can be generated from any subset of people and/or any subset of meetings. I can do this with a complex arrangement of vertical and horizontal portals, but it means I need to have a record of attendance (a tick or a cross) for each person at each meeting. If you've got a better way of
  6. Hi, I hope someone can tell me a simpler solution to the following problem. I have a table that keeps track of people, each one has a unique ID number. I have a separate table that keeps track of dates of meetings. Those two tables already exist and contain data. I also have table that tracks each person's attendance at meetings and other notes that can be made. This has zero records in it so far, but I need a script that will create a record for each person at each meeting. It will have a field that links the record to a person (via ID number) and a date. I would like a scri
  7. Yes, that is correct, and that's what I'd like to do but I need more information on how exactly to do that with "OS-level" scripting. Sounds like it might be too hard for me. Would that still work if the database is a few hundred MB in size (lots of pictures in container fields)?
  8. I'm hoping this is possible but trawling through the FMP documentation and forums here hasn't resulted in a solution to what I'd like to do. Essentially I'd like to create a script that can merge the database with another database (where the table structure is guaranteed to be the same). Now that's basically importing from another FMP database several times (since each import can only handle one table). However, I'd like the user to be able to select the file to be imported, and not have the filepath hardcoded into the script. I realise this is possible by storing the filepath as a s
  9. Hi, I need help trying to create an elegant solution to this problem. I need to do a "CountIf" type summary, counting all related records to the current one (which are also shown in a portal). I have an Assignments table (each record has a unique AsnID) and an Individual Submission table with many records (each tied to the Assignment record through the AsnID). A one:many relationship. The important field here is that each Individual Submission has a field "Rating" that only allows "A", "B" or "C" values. I'm sure you can see where this is going. Is there are way that I can have a
  10. (I'm putting it here because I classify it as "exporting" data out of filemaker, but it's not really. I didn't know where else to put it). I need to generate/export a log file of all changes made to any record in the database. IE, if a user changes anything, it gets noted in a log "At 12:05pm 01/04/2008, Username modified FieldName in record RecordName". And the log-file just racks these up. The problem, obviously, is that it could get rather large, rather fast. What is the best (most efficient) way of doing this? I've got a small-ish database at the moment, but needs to be able
  11. This might have been answered elsewhere, but I couldn't find it. If so, feel free to link to elsewhere, I'm sure there's a common (if not simple) solution. I have an employee table, with an ID number, a username and a full name. I also have a Job table, which has a Employee ID as a linking field, so where Job::Employee ID = Employee::ID. The employee can create a Job, and I want them to be able to enter their username OR their ID number into the dialog. If they enter ID number, it's easy. If they enter username, ideally I'd search the Employee table for that username, get
  12. I need some help with a text field. I've got the following set up. textField1 is a field that can only have values from a value list, and no others. textField2 is a field that is set to "Auto-Enter Calculation" and the calculation references only textField1. It's like a Case statement, but also with some other complexities. The details aren't relevant here. However, what is important is that this field IS editable. If the user doesn't like what is in there, they can change it. Now, what I want is sort of half-and-half of the "do not replace existing value of the field, if an
  13. Ok, I'm working on a simple job tracking/ticketing system. When someone creates a job, it's given a "due time". I've got another field which is "days of job. I've got a "Due time" field which is a timestamp, calculated on creation. The calculation is: =CreatedOn+(DaysOfJob*24*3600) Thus, if DaysOfJob is 1, the due date will be 24 hours after the creation date. This works fine, but I'm trying to extend it a little, which is where the problem occurs. The Problem This is for a business that is only open 9 to 5, 5 days a week. Thus, if someone creates a job of with a le
  14. I've got a few complex script that run in a few windows at once and do some tricky stuff to records. The problem is that I get a lot of "You can't edit this record because it is open in another window" errors. Is there any simple way to stop this from happening, to tell a script to stop editing the record without closing the window. Would it be easier to post the entire script to find out where the problems lie?
  • Create New...

Important Information

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