{"id":1818,"date":"2018-08-16T12:27:26","date_gmt":"2018-08-16T12:27:26","guid":{"rendered":"http:\/\/www.aqbsolutions.com\/?p=1818"},"modified":"2025-04-17T04:39:41","modified_gmt":"2025-04-17T04:39:41","slug":"filmmaker-an-enhanced-version-of-invoicing-application","status":"publish","type":"post","link":"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/","title":{"rendered":"FileMaker: An Enhanced Version of Invoicing Application"},"content":{"rendered":"

\u00a0<\/strong><\/p>\n

In the last article- Steps to set up a Simple Invoicing Application in FileMaker<\/a>, you have seen how you can create a simple invoicing application in FileMaker.<\/p>\n

Our FileMaker Development<\/a> team has enhanced the invoicing application after the publishing of this blog.<\/p>\n

Therefore, in this article, you will get a clear overview of some of the enhancements that we have done in the invoicing application. You will see some of the important functionalities and how we have implemented them, the database modifications, and some important layouts.<\/p>\n

Database:<\/p>\n

\"\"<\/p>\n

In the enhanced version of the invoicing application, we have added some database tables and modified some of them.<\/p>\n

The following diagram shows the tables, fields and the relationship between them.<\/p>\n

Database Relationship:<\/p>\n

Important Functionalities<\/p>\n

In the current invoicing application, we have added a few functionalities or modified some existing functionalities. Let us see some of these functionalities and how we have incorporated them in the current application.<\/p>\n

Functionality: PDF Generation of Invoice<\/p>\n

We have generated a PDF file for the sales invoice that is generated in the application. In the following section, you will take a look at the steps that illustrate how we have generated the PDF of the sales invoice.<\/p>\n

Steps to generate a PDF file for the invoice<\/p>\n

Step 1:<\/strong>\u00a0 Place a button in the header section of the invoice layout.<\/p>\n

Step 2:\u00a0<\/strong> Double click on the button to open the button setup.<\/p>\n

Step 3:<\/strong>\u00a0 In the button setup Choose Single Step as an option in the Action section.<\/p>\n

Step 4:\u00a0<\/strong> Once you choose Single Step option, it opens up the button action window which allows you to enter the script<\/p>\n

Step 5:\u00a0<\/strong>Script: Save Records as PDF [Restore; With Dialog: On; Records being browsed]<\/p>\n

Step 6:<\/strong> Press OK to save<\/p>\n

\"Steps<\/p>\n

Now you can generate the PDF file from the sales invoice.<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

\"\"<\/p>\n

Functionality: Google Map Integration<\/p>\n

We have integrated google maps with our invoicing application to indicate the location of the client\u2019s address.<\/p>\n

In the following section, you will take a look at the steps that illustrate how we have integrated google maps in our invoicing application.<\/p>\n

Step 1:\u00a0<\/strong>Go to client details layout of the client table<\/p>\n

Step 2:\u00a0<\/strong>Drag and drop web viewer tool into the body<\/p>\n

Step 3:\u00a0<\/strong>Double click on web viewer in the body to open the web viewer setup<\/p>\n

Step 4:\u00a0<\/strong>Web viewer setup : In the Choose a website section, Choose a value such as Google Maps(US)<\/p>\n

Step 5:\u00a0<\/strong>Web viewer setup : Specify the field names for\u00a0 sections such as Address, City, State, Zip Code, Country. This will populate these sections from the values in the respective fields of client table.<\/p>\n

Step 6:\u00a0<\/strong>Web viewer setup : Check the checkboxes for Allow interaction with web viewer content and Automatically encode URL.<\/p>\n

Step 7:<\/strong> Click OK To save the Web Viewer Setup values<\/p>\n

\"How<\/p>\n

Now, once you run the application, the Location Map is automatically populated with the exact location of the client’s address in google maps.<\/p>\n

\"\"<\/p>\n

Functionality: Search<\/p>\n

In our application, we have implemented search functionalities in multiple sections. In this article, you will see the implementation of one such search functionality. This search functionality was implemented to search previously generated sales orders according to categories such as Order Id, Purchaser, Date, and Order Status using a popover button.<\/p>\n

Steps to implement the search functionality:<\/strong><\/p>\n

Step 1:<\/strong> Popover button<\/p>\n

Choose Popover button from the Insert menu<\/p>\n

\"\"<\/p>\n

Resize this popover button according to your requirements<\/p>\n

Double click on the popover button to get into the popover button setup<\/p>\n

Select the image of the button from the list of images displayed<\/p>\n

Give a title to the button<\/p>\n

Step 2 :<\/strong> Use the field picker menu to insert the search fields from the desired table (Search_Orders) in the popover button.<\/p>\n

Step 3:<\/strong> Use the field picker menu to insert the text field \u201cSearch_Orders\u201d in the popover button<\/p>\n

\"\"<\/p>\n

Step 4:<\/strong> Select \u201cSearch_Orders\u201d and click on Inspector tool.<\/p>\n

Step 5:<\/strong> In the inspector tool, select \u201cRadio Button Set\u201d in the Control Style section.<\/p>\n

Select \u201cSearch_Orders\u201d value list from the Values from the section.<\/p>\n

(Click on the edit button to edit the \u201cSearch_Orders\u201d value list, if needed.)<\/p>\n

The field Search_Orders in the Sales_Order table is a global field.<\/p>\n

\"\"<\/p>\n

Step 6<\/strong> : Right Click on \u201cSearch_Orders\u201d <\/strong>and select Set Script Triggers <\/strong>option.
\nSelect OnObjectSave <\/strong>in the specify a script to be run for an event<\/strong> section.<\/p>\n

Click on the Select <\/strong>option and select the script \u201csearch order 1<\/strong>\u201d and click OK.<\/strong><\/p>\n

Click on Browse<\/strong> in Enable in<\/strong> option.<\/p>\n

Click OK<\/strong><\/p>\n

The \u201csearch order 1<\/strong>\u201d script is described below.<\/p>\n

Script Name<\/strong>: search order 1<\/strong><\/p>\n

Description:<\/strong><\/p>\n

This script is triggered when the user selects a particular search category<\/p>\n

It is used to display the corresponding search field when the user selects the category.
\nScript :<\/strong><\/p>\n

[code lang=”js”]<br \/>If [SALES_ORDER::Search_Orders = \u201cORDER ID\u201d]<br \/>Go to Field [ SALES_ORDER::Search_Orders_id]<br \/>End if<br \/>If [SALES_ORDER::Search_Orders = \u201cPURCHASER\u201d]<br \/>Go to Field [ SALES_ORDER::Search_Orders_purchaser]<br \/>End if<br \/>If [SALES_ORDER::Search_Orders = \u201cDATE\u201d]<br \/>Go to Field [ SALES_ORDER::Search_Orders_date]<br \/>End if<br \/>If [SALES_ORDER::Search_Orders = \u201cORDER STATUS\u201d]<br \/>Go to Field [ SALES_ORDER::Search_Orders_status]<br \/>End if[\/code]<\/p>\n

\"\"<\/p>\n

\u00a0<\/strong><\/p>\n

Step 7 :\u00a0<\/strong>Double click on the search button to invoke the Button Setup.\u00a0<\/strong><\/p>\n

In the Action <\/strong>section select \u201csearch order 2<\/strong>\u201d script<\/p>\n

The search order 2 <\/strong>script is described below :<\/p>\n

Script Name: search order 2<\/strong><\/p>\n

\u00a0<\/strong>Description :<\/strong><\/p>\n

When a user selects a particular search category and clicks on the search button, in the popover button, the search order 2 script is triggered. This script is used to display the search results, based on the search category selected by the user.
\nScript :<\/strong><\/p>\n

[code lang=”js”]Set Variable [ $type ; Value : SALES_ORDER::Search_Orders ]<br \/>If [ $type = \u201cORDER ID\u201d ]<br \/>Set Variable [$x ; Value : SALES_ORDER::Search_Orders_id ]<br \/>Perform Find [ Restore ]<br \/>End If[\/code]<\/p>\n

In this case , click on the specify find request option,<\/strong> which lies\u00a0 <\/strong>just next to the script Perform Find<\/strong>.<\/p>\n

It opens the specify find request window .<\/p>\n

\"\"<\/p>\n

Click on specify<\/strong> in this window which opens the Specify Find Requests<\/strong> window<\/p>\n

\"\"<\/p>\n

Click on new <\/strong>to open the Edit Find Request<\/strong> window<\/p>\n

\"\"<\/p>\n

In the Find records when<\/strong> section, select Sales_Order table .<\/p>\n

Select Order_Id from the fields option<\/p>\n

Click on Insert Operator<\/p>\n

In the Criteria<\/strong> section, type =$x(variable name)<\/p>\n

Click on Add<\/strong><\/p>\n

Select the field and criteria<\/p>\n

\"\"<\/p>\n

Finally, Click on OK<\/strong>\u00a0to Save and continue<\/p>\n

\"\"<\/p>\n

[sourcecode language=\"plain\"]If [ $type = \u201cPURCHASER\u201d ]\nSet Variable [$x ; Value : SALES_ORDER::Search_Orders_purchaser ]\nPerform Find [ Restore ]\nEnd If[\/sourcecode]<\/pre>\n
(Repeat the steps given above for the script Perform Find [ Restore ]<\/strong>)<\/p>\n
[sourcecode language=\"plain\"]If [ $type = \u201cDATE\u201d ]\nSet Variable [$x ; Value : SALES_ORDER::Search_Orders_date ]\nPerform Find [ Restore ]\nEnd If[\/sourcecode]<\/pre>\n
(Repeat the steps given above for the script Perform Find [ Restore ]<\/strong>)<\/p>\n
[sourcecode language=\"plain\"]If [ $type = \u201cORDER STATUS\u201d ]\nSet Variable [$x ; Value : SALES_ORDER::Search_Orders_status ]\nPerform Find [ Restore ]\nEnd If[\/sourcecode]<\/pre>\n
(Repeat the steps given above for the script Perform Find [ Restore ]<\/strong>)<\/p>\n
\u00a0\"\"<\/strong><\/p>\n
Functionality : Send Mail<\/strong><\/p>\n
This functionality allows you to send an email to the client along with invoice.pdf as an attachment.
\nStep 1:<\/strong> Place a button in the header section of the invoice layout.<\/p>\n
Step 2:<\/strong> Double click on the button to open the button setup.<\/p>\n
Step 3:<\/strong> In the button setup Choose Perform Script<\/strong> as an option in the Action<\/strong> section.<\/p>\n
\"\"<\/p>\n
Step4:<\/strong> Once you choose Perform Script<\/strong> option, it opens up the Edit Script window which allows you to enter the script<\/p>\n
(First, you have to write the script , and then you can choose the script)<\/p>\n
Step 5: Enter the script as given below
\nScript<\/strong> :<\/p>\n
Save Records as PDF [Restore ; With Dialog: On ; Records being browsed]<\/p>\n
Send Mail [ Send via E-mail Client ; With dialog On ; To ; Client:: Email; Subject : \u201cSALE INVOICE DETAILS\u201d;<\/p>\n
Message: \u201cYOUR INVOICE IS ATTACHED BELOW \u201d; \u201cInvoice.pdf\u201d ]<\/p>\n
Click on the button adjoining the script : For the script, Save Records as PDF.<\/p>\n
This opens the option window as shown below .<\/p>\n
\"\"<\/p>\n
Click on specify an output file<\/strong> to open the specify output file<\/strong> window<\/p>\n
In the text box type the name of the attachment , I.e file : Invoice.pdf<\/p>\n
\"\"<\/p>\n
Click OK<\/p>\n
In the options<\/strong> window, click on specify options<\/strong> to open the Save Records as PDF options window<\/p>\n
\"\"<\/p>\n
In the save option choose Records being browsed<\/p>\n
Click OK to continue<\/p>\n
\u00a0Step 7:<\/strong> Configure the email options to send email to the client :<\/p>\n
Click on send mail options button to open the Send Mail options window<\/p>\n
Click on E-mail Client<\/strong> option in the Send Via section<\/p>\n
Specify field name in To<\/strong> section<\/p>\n
Enter your subject details in the Subject<\/strong>\u00a0 section<\/p>\n
Enter your message in the Message<\/strong> section .<\/p>\n
Click on Attach<\/strong> File to attach your invoice.pdf file to be send along with the email .<\/p>\n
Step 8:<\/strong> Click OK to save and continue .<\/p>\n
Step 9:<\/strong> Press OK to save<\/p>\n
\"\"<\/p>\n
Functionality: Inserting values in the portal row while generating a new sales order <\/strong><\/p>\n

\n<\/strong>In this section , you will see how to show related records from other tables in a portal .<\/p>\n
Creation of portal <\/strong><\/p>\n
Step 1 : Drag and drop a portal from the portal tool into the body<\/p>\n
Step 2 : Double click on the portal to open the portal setup<\/p>\n
Step 3 : Select Purchase_Details<\/strong> table in Show related records from option<\/p>\n
Step 4 : Click on Allow Vertical Scrolling<\/p>\n
Step 5 : Enter 1 in Initial Row section<\/p>\n
Step 6 : Enter Number of rows as per your requirement<\/p>\n
Step 7 : Click on Use alternate row state to highlight alternate rows<\/p>\n
Step 8 : Click on Use active row state to highlight the current row<\/p>\n
Step 9 : Click OK to save and continue<\/p>\n
\"\"<\/p>\n
Insert fields in the empty portal<\/strong><\/p>\n
Step 1 : Click on an empty portal and go to the Field picker tool<\/p>\n
Step 2 : Select the correponding fields from the respective tables and drag and drop the field in the portal<\/p>\n
The fields chosen are Product, Brand_Name, Discount %, Current_Availability, Qty, Selling_Price, Subtotal, Tax, Apply_Tax, Tax_Amount, Final_Subtotal<\/p>\n
Step 3: Drag and Drop a button and place it at the end of the portal row .<\/p>\n
Step 4 : Double Click on the button to open the button setup<\/p>\n
Step 5 : In the button setup Choose Single Step<\/strong> and Delete Portal Row<\/strong> in the Action<\/strong> section<\/p>\n
Step 6 : In the button action insert the following script<\/p>\n
Delete Portal Row [ With dialog: On ]<\/p>\n
Step 7 : Click on OK to save and continue<\/p>\n
\"\"<\/p>\n
Populate the remaining fields when you enter the product by triggering a script <\/strong><\/p>\n
Step 1 : Right click on Product field and choose Set Script Triggers <\/strong>to open the Set Script Triggers window<\/p>\n
Step 2 : In the\u00a0 Set Script Triggers window, Click on OnObjectSave in the Specify a script to be run for an event<\/strong> section<\/p>\n
Step 3 : In the Script Trigger Properties<\/strong> choose Select option in script section to open the Specify Script window .<\/p>\n
Step 4 : Select insert check script and click OK to save and continue<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
Script Name: insert check\u00a0 <\/strong><\/p>\n
[sourcecode language=\"plain\"]\nSet Variable [ $itemsqty ; Value ; Product_Details::CURRENT_AVAILABILITY ]\nSet Variable [ $max_id ; Value: ExecuteSQL ( \u201cselect max(id) from Tax_Rate\u201d ; \u201c\u201d ; \u201c\u201d ; \u201c\u201d ) ]\nSet Variable [ $tax_rate ; Value: ExecuteSQL (select Tax_percent from Tax_Rate where id=?\u201d ; \u201c\u201d ; \u201c\u201d ;&amp;amp;amp;amp;amp;amp;nbsp; $max_id )]\nSet Field [ Purchase_details::TAX ; $tax_rate ]\nIf [$itemsqty&amp;amp;amp;amp;amp;amp;amp;lt;1]\nShow Custom Dialog [\u201cREGRET!!\u201d ; \u201dPRODUCT OUT OF STOCK\u201d]\nDelete Portal Row [With dialog off]\nEnd If[\/sourcecode]<\/pre>\n
Layout: Additions and changes<\/strong><\/p>\n
In this enhanced invoicing application, we have modified existing layouts and added a few of them . In this section, you will see a few important layouts that we have used .<\/p>\n
LAYOUT : CLIENT DETAILS<\/strong><\/p>\n
\u00a0<\/strong><\/p>\n
Details: <\/strong>This layout shows the details of a particular client<\/p>\n
\"\"<\/p>\n
\u00a0<\/strong><\/p>\n
LAYOUT : SALES ORDER: <\/strong><\/p>\n
Details:<\/strong><\/p>\n
This layout is used to initiate a new order for a particular client from client details layout.<\/p>\n
\u00a0\"\"<\/strong><\/p>\n
LAYOUT : INVOICE<\/strong><\/p>\n
\u00a0<\/strong><\/p>\n
Description: <\/strong>It generates the invoice of a particular sales order.<\/p>\n
\"\"<\/p>\n
LAYOUT : SALES ORDER LIST : <\/strong><\/p>\n
\u00a0<\/strong><\/p>\n
Description: <\/strong>This layout shows the list of all the previously generated orders.<\/p>\n
When the user selects a particular sales order, he is directed to the sales order layout.<\/p>\n
\"\"<\/p>\n
LAYOUT : PRODUCT DETAILS<\/strong><\/p>\n
This layout shows the details of a particular product<\/p>\n
\"\"<\/p>\n
\"\"<\/p>\n
LAYOUT : COMPANY DETAILS<\/strong><\/p>\n
Details: <\/strong>This layout shows the details of our company.<\/p>\n
\"\"<\/p>\n
\u00a0<\/strong><\/p>\n
Hope this article has helped you in creating an enhanced invoicing application .<\/p>\n
Keep watching this section for more enhancements in the invoicing application, in future.<\/p>\n
Happy Reading!<\/p>\n","protected":false},"excerpt":{"rendered":"
\u00a0 In the last article- Steps to set up a Simple Invoicing Application in FileMaker, you have seen how you can create […]<\/p>\n","protected":false},"author":2,"featured_media":6103,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[83],"tags":[],"class_list":["post-1818","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-filemaker"],"yoast_head":"\nFileMaker: An Enhanced Version of Invoicing Application | aQb<\/title>\n<meta name=\"description\" content=\"This blog takes you through a detailed walkthrough of creating a sofisticated invoicing application using the filemaker application 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\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"FileMaker: An Enhanced Version of Invoicing Application | aQb\" \/>\n<meta property=\"og:description\" content=\"This blog takes you through a detailed walkthrough of creating a sofisticated invoicing application using the filemaker application platform.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-16T12:27:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-17T04:39:41+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/aqbsolutions.com\/blog\/wp-content\/uploads\/2018\/08\/Filemaker-an-enhanced-version-of-invoicing-application-1.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=\"15 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/\"},\"author\":{\"name\":\"aQbSolutions\",\"@id\":\"https:\/\/aqbsolutions.com\/blog\/#\/schema\/person\/7f8c6dcba99e9b5a7c24a525f8365952\"},\"headline\":\"FileMaker: An Enhanced Version of Invoicing Application\",\"datePublished\":\"2018-08-16T12:27:26+00:00\",\"dateModified\":\"2025-04-17T04:39:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/\"},\"wordCount\":1929,\"image\":{\"@id\":\"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/aqbsolutions.com\/blog\/wp-content\/uploads\/2018\/08\/Filemaker-an-enhanced-version-of-invoicing-application-1.png\",\"articleSection\":[\"FileMaker\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/\",\"url\":\"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/\",\"name\":\"FileMaker: An Enhanced Version of Invoicing Application | aQb\",\"isPartOf\":{\"@id\":\"https:\/\/aqbsolutions.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/aqbsolutions.com\/blog\/wp-content\/uploads\/2018\/08\/Filemaker-an-enhanced-version-of-invoicing-application-1.png\",\"datePublished\":\"2018-08-16T12:27:26+00:00\",\"dateModified\":\"2025-04-17T04:39:41+00:00\",\"author\":{\"@id\":\"https:\/\/aqbsolutions.com\/blog\/#\/schema\/person\/7f8c6dcba99e9b5a7c24a525f8365952\"},\"description\":\"This blog takes you through a detailed walkthrough of creating a sofisticated invoicing application using the filemaker application platform.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/#primaryimage\",\"url\":\"https:\/\/aqbsolutions.com\/blog\/wp-content\/uploads\/2018\/08\/Filemaker-an-enhanced-version-of-invoicing-application-1.png\",\"contentUrl\":\"https:\/\/aqbsolutions.com\/blog\/wp-content\/uploads\/2018\/08\/Filemaker-an-enhanced-version-of-invoicing-application-1.png\",\"width\":1200,\"height\":780,\"caption\":\"Filemaker an enhanced version of invoicing application\"},{\"@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":"FileMaker: An Enhanced Version of Invoicing Application | aQb","description":"This blog takes you through a detailed walkthrough of creating a sofisticated invoicing application using the filemaker application 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\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/","og_locale":"en_US","og_type":"article","og_title":"FileMaker: An Enhanced Version of Invoicing Application | aQb","og_description":"This blog takes you through a detailed walkthrough of creating a sofisticated invoicing application using the filemaker application platform.","og_url":"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/","og_site_name":"Blog","article_published_time":"2018-08-16T12:27:26+00:00","article_modified_time":"2025-04-17T04:39:41+00:00","og_image":[{"width":1200,"height":780,"url":"http:\/\/aqbsolutions.com\/blog\/wp-content\/uploads\/2018\/08\/Filemaker-an-enhanced-version-of-invoicing-application-1.png","type":"image\/png"}],"author":"aQbSolutions","twitter_card":"summary_large_image","twitter_misc":{"Written by":"aQbSolutions","Est. reading time":"15 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/#article","isPartOf":{"@id":"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/"},"author":{"name":"aQbSolutions","@id":"https:\/\/aqbsolutions.com\/blog\/#\/schema\/person\/7f8c6dcba99e9b5a7c24a525f8365952"},"headline":"FileMaker: An Enhanced Version of Invoicing Application","datePublished":"2018-08-16T12:27:26+00:00","dateModified":"2025-04-17T04:39:41+00:00","mainEntityOfPage":{"@id":"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/"},"wordCount":1929,"image":{"@id":"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/#primaryimage"},"thumbnailUrl":"https:\/\/aqbsolutions.com\/blog\/wp-content\/uploads\/2018\/08\/Filemaker-an-enhanced-version-of-invoicing-application-1.png","articleSection":["FileMaker"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/","url":"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/","name":"FileMaker: An Enhanced Version of Invoicing Application | aQb","isPartOf":{"@id":"https:\/\/aqbsolutions.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/#primaryimage"},"image":{"@id":"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/#primaryimage"},"thumbnailUrl":"https:\/\/aqbsolutions.com\/blog\/wp-content\/uploads\/2018\/08\/Filemaker-an-enhanced-version-of-invoicing-application-1.png","datePublished":"2018-08-16T12:27:26+00:00","dateModified":"2025-04-17T04:39:41+00:00","author":{"@id":"https:\/\/aqbsolutions.com\/blog\/#\/schema\/person\/7f8c6dcba99e9b5a7c24a525f8365952"},"description":"This blog takes you through a detailed walkthrough of creating a sofisticated invoicing application using the filemaker application platform.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/aqbsolutions.com\/blog\/2018\/08\/16\/filmmaker-an-enhanced-version-of-invoicing-application\/#primaryimage","url":"https:\/\/aqbsolutions.com\/blog\/wp-content\/uploads\/2018\/08\/Filemaker-an-enhanced-version-of-invoicing-application-1.png","contentUrl":"https:\/\/aqbsolutions.com\/blog\/wp-content\/uploads\/2018\/08\/Filemaker-an-enhanced-version-of-invoicing-application-1.png","width":1200,"height":780,"caption":"Filemaker an enhanced version of invoicing application"},{"@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\/1818","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=1818"}],"version-history":[{"count":2,"href":"https:\/\/aqbsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/1818\/revisions"}],"predecessor-version":[{"id":6107,"href":"https:\/\/aqbsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/1818\/revisions\/6107"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aqbsolutions.com\/blog\/wp-json\/wp\/v2\/media\/6103"}],"wp:attachment":[{"href":"https:\/\/aqbsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=1818"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aqbsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=1818"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aqbsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=1818"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}