Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About OptimusPrime

  • Rank
  1. Yes it does! Thanks! From the example which was posted by consultant, I found my mistake - the checkbox was fine, i.e. it was in the same format/definition as the one in the uploaded file. The issue was that I had field B defined not as a calculation, but as a numeric field which I had validated by calculation (which, oddly, worked for other fields, which were numeric. I.e. the calculation of (field c) x 2 worked perfectly. But valueCount did not.) Thanks - it works now! OP
  2. That didn't work... any other ideas? Maybe it's impossible with FM?
  3. Dear All, I'm trying to track changes in a particular part of a database. Table: TableBooks Fields: - BookID - BookStatus (In/Out only) - BookName I need to create a table which records when each book is taken out and returned. I had some success in creating a table BookStatus: - BookStatusID - BookID - BookChange (timestamp, new on creation) I've linked the tables: BookID -- BookStatusID I've created a little script, which is triggered on BookStatus change: Go to Layout ["BookStatus"] New Record/Request This creates a new record, and the
  4. Google docs does it! Solved. Now I just need to set up import from google docs and win!
  5. Brief question: Got an object. One field (field A) is a checkbox set. Another field (field B ) is a calculation. What I need, and can't seem to figure out, is this: In the calculation in field B, for filemaker to count the amount of checkboxes. I.e. if three boxes are checked, return value 3, if four are checked, return value 4, etc. any idea how this is possible? Thanks! OP
  6. Right! Now I just have to figure that out without looking like an idiot...
  7. I have the same issue. There must be a work around out there. I havent got the foggiest idea what it would look like, but we can't be the only ones or the first ones with this issue. Let me know if you find something, I'll do likewise. OP
  8. Thanks a ton for this - I'll try and get my head around how the calculation field works. I'll be expanding on that for other tables/attributes. This is really helpful. Hmm. Maybe I'm not using find correctly. The way I use it, I get either (in form view) records which I can click through one after the other - not a list. Or in List view, just like form view but scrolling instead of clicking, and table view, which is a list - what I'm looking for - but the list is too detailed (I just need the book names, not every other detail) and it goes away from the pretty layout which the use
  9. OK - so I incorporated this into the database fairly easily, I figured out how it worked (first time I used global fields... still dont quite get how/what they do. But it works ) Now, I have created a second attribute which objects are connected to - features. Hence there's an ObjectsFeatures table. (attached) Is it possible that the results for BOTH searches are displayed in the same portal? I thought maybe by inserting a table objects on the one hand and objectAttributes and ObjectsFeatures on the other. However this would probably confuse the primary keys and moreover violate nor
  10. Yes - I don't want to leave form view really to work the database. It's not just made for me, but for others who aren't computer literate. Awesome! This is pretty much exactly what I was looking for. Thanks a million!! I now need to reverse engineer what you've done there and apply it to my database... May need some help with that, so I might be back. Thanks again! OP
  11. Hey, Thanks for the response I know how 'find' works, I've used it. What find gives me (at least the way I use it) in a layout is the first record of the set of records which the find function has returned. I can then browse through the records by using the 'next record' button top left (or through a button which I've put in to have that function). What I was looking for -sorry, I didn't make that properly clear- is within the layout of the books table, a field where I can type or (probably easier) select from a dropdown/popup menu the specific topic. There should then be withi
  12. Hello all, I have a question regarding a database which I have built on a friend's computer. Part of this database is a number of many-to-many relationships. Example: Table_Books includes the following fields Book_ID (primary key) Book_title Book_author Book_topic Table_Topics has only two fields: Topic_ID Topic_Name Finally there is Table_Book_Topic, which includes: Join_ID (auto generated) Book_ID (from table_Book) Topic_ID (from table_Topic) Hence, one topic is covered in more than one book, and one book can touch on more than one topic. So fa
  • Create New...

Important Information

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