Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

1 Neutral

About Wickerman

  • Rank
  • Birthday 11/21/1963

Profile Information

  • Gender
    Not Telling

FileMaker Experience

  • Skill Level
  • FM Application
    15 Advanced

Platform Environment

  • OS Platform
  • OS Version
    10.13.2 High Sierra

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Thans to all responders -- I installed the update and the Card window approach worked great-- I really appreciate the guidance!
  2. Wickerman

    Send file to iPad via Messages?

    Any help on this one? It seems crazy not to be able to deliver Filemaker files to Go via messages . . . here's a picture of what I'm seeing -- the file downloading (progress pie chart), and above it, what the file looks like when it's done downloading. The file does not trigger Filemaker Go, as it does when I send the file via Airdrop . . . and I can't even figure out where it "downloads" TO? There's nothing in my iPad 'Files' app . . . This is really putting a crimp in a project.
  3. Thanks Mr. Woods, for the productive suggestion -- I had mulled doing some sort of similar thing, but hadn't quite got there. Your suggestion will suffice as motivation enough for me to upgrade to FMP 16 -- and I''ll update my profile when I do so, Lee! This place is awesome.
  4. I have a layout in List view where each line represents a LOCATION. Picture the location being a numerical sequence of slots in a number of drawers. The Locations are related in a 1-to-1 relationship with ITEMS. Each Item occupies a single location. Over on the ITEMS layout, the user can create a new item and assign it to the next slot in the LOCATIONS sequence. All good. Occasionally an ITEM is discarded, and its record is deleted from the database. This results in an empty slot in the midst of the Locations sequence. The Location record is still there, because we don't delete that record - the slots, once created, are there for good. I need to find the simplest means of allowing the user to enter a new Item and assign it to one of the empty slots in the sequence if he or she so desires. (Sometimes you need to enter 3 new items and you want them to be in consecutive Locations, so you wouldn't opt to fill gaps with them). One way is I can put a little button on the Items called "Fill Gaps" and pop up a little window with a filtered portal showing the available gap Locations. Work, but seems a little busy. Another way I'm thinking is that back in the List view, where you can easily see the empty Locations (there's nothing in the Item Title field), I could make the Title field a 1-row portal allowing record creation. Entering the name of a new Item there would create the new Item record and you go over to the Item layout to finish entering descriptive data about it. The problem with this is I don't like the idea that the user can change or erase the Titles of existing Items from this layout -- people may get confused and not realize they're making a chance to the Item record itself. So, is there a way I can disallow data entry in the List View lines that are already connected to an item, while allowing it in those that aren't (the difference is that the foreign Key Field would be empty). Or . . . is there just some better way of managing this that I'm not considering? Thanks for any suggestions!
  5. I'm creating a simple database to keep track of a DVD collection, where the media are going to be removed from original packaging and stored in small paper sleeves. Each disc will get a record in the Media Table and the client wants to simply assign each Disc a unique sequential Location #. So: D-0001 D-0002 D-0003 etc. We would like to have an "Assign Location #" button that looks up the existing numbers and offers up the next available number in the sequence. To complicate matters a bit, we also want to plan for filling gaps that are created when obsolete DVD's are removed from the collection due to damage, obsolescence, etc. So say the highest number in the existing sequence were D-0333, but there are currently no DVD's assigned to D-0092, and D-0300, we'd want the user to be able to choose between the missing numbers or D-0334 (it's preferable for related Discs to be next to each other in the drawer). So, I'm thinking maybe rather than manipulating some kind of Serial $ field in the Media Table I should be making a related Location Number table with a one-to-one relationship so that these Location numbers are an Entity. I'm vaguely thinking I could use a filtered portal to display Location slots that currently have no value in the key field. sorted by Location #. Maybe have the Location selector be a little window that pops up when you want to assign a number? Is that the right approach? Is there a better one? One follow-up question is if I take this approach, should I just create a large enough number of Location #'s that will ensure they never reach the final number . . . or are there unfortunate consequences for that I'm not anticipating?
  6. I have created a nifty little FM Go solution for quizzing myself on backgammon problems that I think others in the backgammon community might find very useful. Since I don't really anticipate it being a big money-maker, it's not worth it to me to try to do an elaborate purchase/licensing/subscription/encryption process for "selling" the solution to players. What I'd like to do instead is just make it available for people to download onto their iPads and use for free, and include a sort of "tip jar" request that if they found the solution useful, they could go to PayPal and make a $10 or $25 or whatever they feel it was worth to me. If it were to bring in say $1000 it would be worthwhile for me to produce further quizzes. So, what would be the simplest way for me to set up that sort of 'tip jar'? I could just have a screen where I provide my email and suggest they go to PayPal themselves - - - but is there a way I could have them click a button that would say open their web browser and take them to PayPal? Or is there a reasonably simple way way to put a PayPal logo button on a Filemaker layout and set it up to fill in my email address automatically for a Donation?
  7. Oh That was simple enough I guess. :-)
  8. I'd like my FIlemakerGo solution to be non-password protected and simply open to my Home screen when the file is opened, I don't want the user to have a username or have any log-in step) and I'd like the display to be set without either of the Filemaker toolbars at the top or bottom of the screen. I've been searching and reading about the topic online, but by now my head is spinning, because I can't even remember what the different parts are. I'm seeing 3 horizontal strips on the screen other than what I designed on my layouts: 1) The iPad-standard ribbon that shows the Wifi signal, the time, and battery level. (Is this the 'status bar'?) 2) A Filemaker strip at the top of my layout with an 'Actions' arrow leading to File launch / close, etc. at left and the Search magnifying glass at right. (What is this called?) 3) A Filemaker strip at the bottom of the screen with Record navigation controls. (The Toolbar) So, I would like to hide (2) and (3) when my file opens. I'd like the Apple iPad data to remain. I have set up an opening script that uses Show/Hide Toolbars [Lock; Hide] and this succeeds in hiding the lower bard (3) . . . but it leaves the top one visible. I know I can hide that top bar by swiping up with three fingers - - and I'm fine with my use being able to do that too . . . but when they open the file, I want it to be hidden -- because I don't anticipate their needing any of those tools or settings, and it just makes the layout look busier than it needs to. (I've put a 'Close File; button on every layout). Is there some way I can make that upper toolbar (and what is it actually called?) hide itself by default thanks!
  9. I am trying to figure out a convenient way to send a Filemaker file to a friend's iPad with minimum fuss. This person does not use his iPad for email. I see I can send such a file via iMessage, just as I would a photograph. What I'm not seeing is how to get the file from the iPad Message app into FilemakerGo. When I send the file, I see it there in the iMessage window, but the only option seems to be 'Copy' -- is there a way to "paste" the file into FilemakerGo? Having received the file in Messages, is there a place where the file "lives" on the iPad -- and where I could move it over into Go? I'm hoping there's a way I can do this without asking the person too download it on a desktop machine, plug in the iPad, and use iTunes to move it over. Is there?
  10. THAT'S IT! Thanks to everyone who spent time replying here -- doughemi hit the nail on the head, exactly what I was hoping for. I think I had done this once a couple years ago but couldn't quite recall the logic of it.
  11. This is a super-simple parent-child one-to-many structure. PARENT: Topic CHILD: Question Each Child Question record is characterized in a field as Easy OR Medium OR Hard (each question has only one designation). I want to start on a layout in Topic Context and allow the user to specify which subsets of Questions they want to encounter: Easy, OR Medium OR Hard . . . or Easy AND Medium, or Easy AND Hard, or Medium AND Hard or Easy AND Hard, or Easy AND Medium AND Hard. Basically, any combination of these three options: A B C A+B A+C B+C A+B+C So, my though was I set up three checkboxes, INCLUDE A INCLUDE B INCLIUDE C . . . and then depending what the user ticks off, I craft a somewhat complicated IF or CASE sort of script or calculation that performs a FIND on the Question table, for each permutation of checkboxes - - I'm sort of muddy on the process. Do I store the various tick boxes as variables that I then use in a Find? . . . OR can I use a single checkbox field, where when the user checks off boxes, we get a single field with carriage-return entries like: Medium -or- Easy Medium -or- Medium Hard -or- Easy Medium Hard . . . I don't know how to utilize a single field with carriage-returned values to each on a table to find records that match any of the carriage-returned values. This seems like what would be ideal. With regard to the "Anatomy of a Good Topic Link, I'm afraid all I get is this:
  12. This really isn't a survey with branching lines -- it's just a single Find based on the user's desire to include 1, 2, or 3 of the available sub-sets of quiz questions. I maybe complicated the question by bringing up the 'sequence' issue, which will just be a simple sorting step in whatever script I end up with. The quiz questions will be served up one at a time, from first to last -- no branching depending on answers. ('Previous Performance' is just referring to how many times they got these questions right on a previous attempt at them). So say there are 100 question. 20 Easy, 30 Medium, and 50 hard. I just want the user to indicate which questions they want to attempt Easy = 20 Q's Easy Medium & Hard = 80 Q's Easy, Medium & Hard = 100 Q's What's the best way to allow them to specify which batches to include, and then turn that input into a found set?
  13. This seems like it should be simple, but I'm not sure of the best way to go about it . . . I have a quizzing database where each problem is tagged as Easy, Medium, or Hard. On an introductory layout, I want to give users the option of checking one or more tick boxes to determine which of the classes of problems to include in their quiz, and then I want them to be able to choose whether to order those questions in my original sequence, in a random sequence, or in a sequence based on their previous performance . The 'ordering' option I figure I'll offer by putting three buttons on the layout corresponding to the three modes -- clicking one of the three will launch the quiz. . . . but I'm less clear how I should go about presenting only the records reflected in their tick box choices. Should the tick boxes be three separate global fields (Select_easy, Select_medium, Select_hard) and then I take those field states and somehow craft a scripted Find for the 7 different possible box states? Or should it be one field with a Value List offering the 3 options . . . in which case I would perform the Find . . . how exactly? Or is there some other approach for this sort of thing?
  14. I've got the button bar set up and formatted -- looks and works great! Thanks for that suggestion! Now I have a calculation bug that's stumping me. In addition to displaying the most recent responses, I want to calculate a Mastery Score, which will be a weighted %. The most recent response is worth 5, the penultimate one worth 4, etc. down to the 5th most recent answer worth 1 point. So, to get the Mastery % I want to add up all the points and divide it by the total possible points according to how many times the user attempts the problem. I've set up a Calc that seems like it should work, but it gets the denominator wrong. The numerator appears to work okay, but the denominator is always 1+2+3+4+5 = 15 as though the user has made 5 attempts (so if he HAS made 5 attempts, it calculates properly. I have the 5 answer fields automatically set to the word 'Empty' when I create a problem record. If the user gets it right, the field changes to "Right" -- if he flunks, it is set to "Wrong". Here's the calc: And a sample result. Probably something simple I'm missing?

Important Information

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