{"id":2090,"date":"2018-06-11T20:27:44","date_gmt":"2018-06-11T14:57:44","guid":{"rendered":"http:\/\/www.aqbsolutions.com\/?p=1714"},"modified":"2025-04-16T13:41:48","modified_gmt":"2025-04-16T13:41:48","slug":"steps-to-set-up-a-simple-invoicing-application-in-filemaker","status":"publish","type":"post","link":"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/","title":{"rendered":"Steps to set up a Simple Invoicing Application in FileMaker"},"content":{"rendered":"

The following are the steps to set up a simple invoicing application in FilmMaker<\/p>\n

Step 1: Software installation:<\/strong><\/p>\n

We need to install a developer version of FileMaker on our computer. Multiple developer versions, such as FileMaker Pro 16, are available in the market. The latest version available is FileMaker Pro 17.<\/p>\n

Advanced versions provide much more features to develop an application.<\/p>\n

Step 2: Open and create a new solution:<\/strong><\/p>\n

We need to open the software and create a new solution located in the File menu.<\/p>\n

Step 3: Creation of database:
\n<\/strong><\/p>\n

Creation of table & Creation of field<\/p>\n

We need to create tables as per our requirements. For instance, product, purchase, client and purchase detail etc.<\/p>\n

We need to go to the File menu, click on Manage and Database.<\/p>\n

This opens up a window with three tabs i.e. Tables, Fields, and Relationships<\/p>\n

We need to create a table by clicking on Tables tab.<\/p>\n

Also as per our requirements, we would need to create the desired fields and set up a relationship between the tables.<\/p>\n

In case of invoicing application, in the product table, product id, product name and product price, product initial quantity and the current stock would be the fields for the product table.<\/p>\n

Likewise, client id, client name, client address would be fielded for client table.<\/p>\n

Order_id, Purchaser, ClientPurchase_id_fk would be fielded for purchase table.<\/p>\n

The product, qty, price, subtotal, invoice no. (Global field), client_id_fk, Purchaser would be fields of Purchase details table.<\/p>\n

Depending upon the requirement, we can create or change the field type of tables.<\/p>\n

For e.g. – date, number, text field etc. However, field changes could lead to data losses and could be avoided. For instance, in an invoicing application date field is created for purchase table.<\/p>\n

As per our requirement, we can specify a field to be unique, auto increment, creation date, etc.<\/p>\n

Invoice number needs to be created as a global field in our application.<\/p>\n

We can click on the Fields tab to create fields for respective tables.<\/p>\n

Creating relationships<\/strong><\/p>\n

On the Relationships tab in the GUI, we will get the option to create relationships between tables by just relating the primary key and foreign key between tables.<\/p>\n

\"Creating<\/p>\n

Step 4: Design a Layout:
\n<\/strong>Layouts will be created automatically based on the tables created. However, we can create multiple layouts of the same tables and pick fields and design them as per our requirement.<\/p>\n

We have an option named inspector (view-tab-inspector)<\/strong> which will allow us to design each field in the layout.C lick the field where you want some modifications to be done.<\/p>\n

For instance, in an invoicing application, a drop-down list can be created for purchase layout of purchase table for product field. The values are fetched from product table as there exists a relationship between purchase_details and product table previously.
\nPortals: <\/strong>\u00a0\u00a0For an invoicing application, we need to create portals<\/strong> to input records to a table from a layout of the different table.
\nFor instance, we need to import fields from purchase details<\/strong> table to the portal of purchase layout. Therefore the portal will contain fields such as product list, Quantity, price, subtotal. Using this portal we need to input records which will be stored in the purchase detail<\/strong>s table.<\/p>\n

\"Design<\/p>\n

In purchase layout, we also need to place purchaser field and create a drop-down list of client names from client table. Check out the snapshot below<\/p>\n

\"list<\/p>\n

Similarly, there could be a layout based on product table for displaying and storing product information such as product name, cost, quantity, in stock<\/p>\n

\"storing<\/p>\n

The following layout is designed for client table where a client can enter his details such as customer id, Name, Mobile No, Address.<\/p>\n

\"client<\/p>\n

Invoice generation<\/strong> :<\/p>\n

Invoice is a layout of purchase details table.<\/p>\n

\"Invoice<\/p>\n

There is a button for generating an invoice located in the purchase layout. A script is written (script Name: Invoice ) against this button which will contain steps to navigate to an invoice layout where an invoice is generated.<\/em><\/strong><\/p>\n

Step 5: Creation of scripts: Script is created to exclusively to execute specific instructions with the help of script steps provided by the FileMaker software.<\/p>\n

A Script needs to written to update the availability of a product after the purchase of the product.
\nBased on the product id, the script will execute an SQL query which will fetch the quantity of product purchased from the purchase layout. The script will then deduct the fetched quantity from the initial stock field of the product table.
\nThe Script Name would be Stock<\/p>\n

The script would be\u00a0 as follows :<\/p>\n

[sourcecode language=”js”]
\nSet field [Product : : IN_STOCK;Product :: Quantity \u2013 ExecuteSQL(\u201cselect qty from Purchase_details where product_id_fk=?\u201d;\u201d\u201d;\u201d\u201d; product::Product_id )[\/sourcecode]<\/p>\n

Similarly, a script for generating an invoice in the purchase layout would be\u00a0 as follows<\/p>\n

The Script Name would be Invoice<\/p>\n

[sourcecode language=”js”]
\nSet Variable [$Order_id; Value: Purchase::Order_Id]<\/p>\n

Go to layout [\u201cInvoice\u201d(Purchase_details);Animation:None ]<\/p>\n

Perform Find[Restore]<\/p>\n

Set Field [Purchase_details::invoice_number_global;$Order_id][\/sourcecode]<\/p>\n

A script also needs to be written to fetch the details of the purchaser by using the client id of purchase table (Client_id_fk).\nThe Script Name would be Purchase<\/pre>\n
[sourcecode language=”js”]
\nSet Variable [$Client_id;Value:Purchase:Purchaser]
\nSet Field [Purchase::Client_id_fk; $Client_id][\/sourcecode]<\/p>\n","protected":false},"excerpt":{"rendered":"
The following are the steps to set up a simple invoicing application in FilmMaker Step 1: Software installation: We need to install […]<\/p>\n","protected":false},"author":2,"featured_media":6091,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[83],"tags":[],"class_list":["post-2090","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-filemaker"],"yoast_head":"\nBuild a Simple Invoicing Application in FileMaker | aQb Solutions<\/title>\n<meta name=\"description\" content=\"This blog takes the reader through a step by step guide of creating an invoicing application using the claris filemaker platform.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Build a Simple Invoicing Application in FileMaker | aQb Solutions\" \/>\n<meta property=\"og:description\" content=\"This blog takes the reader through a step by step guide of creating an invoicing application using the claris filemaker platform.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-11T14:57:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-16T13:41:48+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/aqbsolutions.com\/blog\/wp-content\/uploads\/2018\/06\/How-to-Set-Up-Invoicing-Application-in-Filemaker.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"780\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"aQbSolutions\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"aQbSolutions\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/\"},\"author\":{\"name\":\"aQbSolutions\",\"@id\":\"https:\/\/aqbsolutions.com\/blog\/#\/schema\/person\/7f8c6dcba99e9b5a7c24a525f8365952\"},\"headline\":\"Steps to set up a Simple Invoicing Application in FileMaker\",\"datePublished\":\"2018-06-11T14:57:44+00:00\",\"dateModified\":\"2025-04-16T13:41:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/\"},\"wordCount\":862,\"image\":{\"@id\":\"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/aqbsolutions.com\/blog\/wp-content\/uploads\/2018\/06\/How-to-Set-Up-Invoicing-Application-in-Filemaker.png\",\"articleSection\":[\"FileMaker\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/\",\"url\":\"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/\",\"name\":\"Build a Simple Invoicing Application in FileMaker | aQb Solutions\",\"isPartOf\":{\"@id\":\"https:\/\/aqbsolutions.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/aqbsolutions.com\/blog\/wp-content\/uploads\/2018\/06\/How-to-Set-Up-Invoicing-Application-in-Filemaker.png\",\"datePublished\":\"2018-06-11T14:57:44+00:00\",\"dateModified\":\"2025-04-16T13:41:48+00:00\",\"author\":{\"@id\":\"https:\/\/aqbsolutions.com\/blog\/#\/schema\/person\/7f8c6dcba99e9b5a7c24a525f8365952\"},\"description\":\"This blog takes the reader through a step by step guide of creating an invoicing application using the claris filemaker platform.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/#primaryimage\",\"url\":\"https:\/\/aqbsolutions.com\/blog\/wp-content\/uploads\/2018\/06\/How-to-Set-Up-Invoicing-Application-in-Filemaker.png\",\"contentUrl\":\"https:\/\/aqbsolutions.com\/blog\/wp-content\/uploads\/2018\/06\/How-to-Set-Up-Invoicing-Application-in-Filemaker.png\",\"width\":1200,\"height\":780,\"caption\":\"How to Set Up Invoicing Application in Filemaker\"},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/aqbsolutions.com\/blog\/#website\",\"url\":\"https:\/\/aqbsolutions.com\/blog\/\",\"name\":\"Aqbsolutions Blog\",\"description\":\"Blogs | IT Services in USA and Canada | aQb Solutions\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/aqbsolutions.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/aqbsolutions.com\/blog\/#\/schema\/person\/7f8c6dcba99e9b5a7c24a525f8365952\",\"name\":\"aQbSolutions\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/aqbsolutions.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d37e12c5e93bdf3f02abdb5c8a89bad8841bd4743b3b2ea558914abbb60c7414?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d37e12c5e93bdf3f02abdb5c8a89bad8841bd4743b3b2ea558914abbb60c7414?s=96&d=mm&r=g\",\"caption\":\"aQbSolutions\"},\"url\":\"https:\/\/aqbsolutions.com\/blog\/author\/aqbsolutions\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Build a Simple Invoicing Application in FileMaker | aQb Solutions","description":"This blog takes the reader through a step by step guide of creating an invoicing application using the claris filemaker platform.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/","og_locale":"en_US","og_type":"article","og_title":"Build a Simple Invoicing Application in FileMaker | aQb Solutions","og_description":"This blog takes the reader through a step by step guide of creating an invoicing application using the claris filemaker platform.","og_url":"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/","og_site_name":"Blog","article_published_time":"2018-06-11T14:57:44+00:00","article_modified_time":"2025-04-16T13:41:48+00:00","og_image":[{"width":1200,"height":780,"url":"http:\/\/aqbsolutions.com\/blog\/wp-content\/uploads\/2018\/06\/How-to-Set-Up-Invoicing-Application-in-Filemaker.png","type":"image\/png"}],"author":"aQbSolutions","twitter_card":"summary_large_image","twitter_misc":{"Written by":"aQbSolutions","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/#article","isPartOf":{"@id":"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/"},"author":{"name":"aQbSolutions","@id":"https:\/\/aqbsolutions.com\/blog\/#\/schema\/person\/7f8c6dcba99e9b5a7c24a525f8365952"},"headline":"Steps to set up a Simple Invoicing Application in FileMaker","datePublished":"2018-06-11T14:57:44+00:00","dateModified":"2025-04-16T13:41:48+00:00","mainEntityOfPage":{"@id":"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/"},"wordCount":862,"image":{"@id":"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/#primaryimage"},"thumbnailUrl":"https:\/\/aqbsolutions.com\/blog\/wp-content\/uploads\/2018\/06\/How-to-Set-Up-Invoicing-Application-in-Filemaker.png","articleSection":["FileMaker"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/","url":"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/","name":"Build a Simple Invoicing Application in FileMaker | aQb Solutions","isPartOf":{"@id":"https:\/\/aqbsolutions.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/#primaryimage"},"image":{"@id":"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/#primaryimage"},"thumbnailUrl":"https:\/\/aqbsolutions.com\/blog\/wp-content\/uploads\/2018\/06\/How-to-Set-Up-Invoicing-Application-in-Filemaker.png","datePublished":"2018-06-11T14:57:44+00:00","dateModified":"2025-04-16T13:41:48+00:00","author":{"@id":"https:\/\/aqbsolutions.com\/blog\/#\/schema\/person\/7f8c6dcba99e9b5a7c24a525f8365952"},"description":"This blog takes the reader through a step by step guide of creating an invoicing application using the claris filemaker platform.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/aqbsolutions.com\/blog\/2018\/06\/11\/steps-to-set-up-a-simple-invoicing-application-in-filemaker\/#primaryimage","url":"https:\/\/aqbsolutions.com\/blog\/wp-content\/uploads\/2018\/06\/How-to-Set-Up-Invoicing-Application-in-Filemaker.png","contentUrl":"https:\/\/aqbsolutions.com\/blog\/wp-content\/uploads\/2018\/06\/How-to-Set-Up-Invoicing-Application-in-Filemaker.png","width":1200,"height":780,"caption":"How to Set Up Invoicing Application in Filemaker"},{"@type":"WebSite","@id":"https:\/\/aqbsolutions.com\/blog\/#website","url":"https:\/\/aqbsolutions.com\/blog\/","name":"Aqbsolutions Blog","description":"Blogs | IT Services in USA and Canada | aQb Solutions","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/aqbsolutions.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/aqbsolutions.com\/blog\/#\/schema\/person\/7f8c6dcba99e9b5a7c24a525f8365952","name":"aQbSolutions","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/aqbsolutions.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d37e12c5e93bdf3f02abdb5c8a89bad8841bd4743b3b2ea558914abbb60c7414?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d37e12c5e93bdf3f02abdb5c8a89bad8841bd4743b3b2ea558914abbb60c7414?s=96&d=mm&r=g","caption":"aQbSolutions"},"url":"https:\/\/aqbsolutions.com\/blog\/author\/aqbsolutions\/"}]}},"_links":{"self":[{"href":"https:\/\/aqbsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/2090","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aqbsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aqbsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aqbsolutions.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/aqbsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=2090"}],"version-history":[{"count":2,"href":"https:\/\/aqbsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/2090\/revisions"}],"predecessor-version":[{"id":6022,"href":"https:\/\/aqbsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/2090\/revisions\/6022"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aqbsolutions.com\/blog\/wp-json\/wp\/v2\/media\/6091"}],"wp:attachment":[{"href":"https:\/\/aqbsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=2090"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aqbsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=2090"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aqbsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=2090"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}