4 Replies Latest reply on Jun 20, 2016 6:25 AM by siplus

    FM newbie needs advice



      I'm new to Filemaker  and databases in general, but I'm attempting to build my first solution.

      My Wife sells greeting cards to shops and wants a simple ordering system on her iPad/iphone,

      where she just clicks on a picture (icon) of each card and inputs the amount the shop wants,

      and this info goes straight into an invoice that she can email to the shop.


      So far I've made 3 databases, clients, invoice, and products,

      but I'm struggling with working out the next step, making an iPad/iphone layout and getting it to work in the way she wants


      any advice?            

        • 1. Re: FM newbie needs advice

          The filemaker go development guide is a good place to start:



          I'd also recommend using some of the starting solutions and default filemaker "touch" themes. These are things designed to work already for iOS that will give you a good idea for some of the usability things.


          Outside of that, the normal course of action is to adapt your existing layouts for use on iOS by making a copy of them, and having a script that redirects iOS users to that "interface"

          • 2. Re: FM newbie needs advice

            Do you mean three files??


            First step might be to get the three tables in one file. Will be easier to transfer to the ipad then, and the logic will all be in one place.

            I also suggest just creating some new files from the starter solutions to see how they have created layouts in the right size and orientation for iPad


            FileMaker Training series Basic is also free and a good way to start if you are really new.


            In principle, you want to create a new order, populate that with the details of a chosen customer, then see the cards available in a portal, to add a number for each one, and then transfer that detial to a line items table, linked to the invoice record by its ID

            • 3. Re: FM newbie needs advice

              I have the 3 tables in one file

              • 4. Re: FM newbie needs advice

                Form follows function:


                You get a phone call / email / letter from a Client




                Go to that client's record


                Create a new order: go to a ordering layout based on clients, showing client and order data in header.


                ==> cartesian portal showing all cards with filter, empty portal showing order lineItems


                Click on cards to add them as lineItems, move to the quantity field after adding and select the value within (autoenter with minimum order quantity)


                once you got the flow approuwife'ed you can start layouting