Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Tap Forms Template Exchange › Invoice Tracking Template
April 28, 2018 at 11:59 AM #28422
Hello lovely Tap Formers,
Please can you very kindly share a simple Invoice Tracking template, if you’ve created one? We need them! Huge grateful thanks in advance. XxMay 17, 2018 at 12:44 PM #28680
I just built a sample one which you can download here. It’s a full database document with 3 forms in it for Tap Forms 5.
The Customers form is linked to the Orders form with a One to Many Link to Form field.
The Orders form has a Table field within it called Order Items. It’s hooked up to the Products form with matching field names. You can select from the Products form which will copy the record into the Order Items table field matching the field names. You can then type in a Quantity value.
The Orders form also has 2 custom layouts for Invoices. One is in Letter size format and the other is in A4 print size format. Other than that, the two layouts are identical with some minor adjustments to the positions of the objects.
Hope you get some good use from it.
BrendanJune 7, 2018 at 10:02 AM #28989
Super helpful. Saved me days of work to have the basics predetermined so I can just focus on the customizing. Thanks so much!!August 1, 2018 at 10:35 AM #30170
I really want to see this but it just doesn’t open in Tapforms 5?August 4, 2018 at 12:45 AM #30182
You need to download it, then unzip the file. Then you can just double-click on the .tapforms document file. It’s designed for Tap Forms 5.
BrendanSeptember 25, 2018 at 2:20 PM #30758
Thanks for this. I learned more by copying your examples for my template.
KimberleyDecember 17, 2018 at 11:09 PM #32764
Hey, thank you very much for this template! With a few modifications, I can make this work very well for me!
To other readers, on the off-chance you want to open this template on the iOS version of TapForms, you’ll need to unzip it with some kind of unzipping app. Documents by Readdle will let you do it for free (totally unaffiliated with the developers).
They also have a paid app called GoodReader that lets you unzip files, but on that app, the file will appear as a folder. Long-press the unzipped folder and open in TapNotes.December 18, 2018 at 2:39 PM #32786
@Kay, you can also copy it to Tap Forms and then it should appear in the Backup & Restore screen in the Tools area. You can then tap on it and then tap on the Restore button. That’ll unzip it within Tap Forms too.April 9, 2019 at 8:59 AM #34363
Hi Brendan- The invoice tracking template is a great start. I was just wondering how I could turn it into like a shopping cart/estimate/invoice function to tweak it so that when we go into Order Items that we can have either a button or (autofill feature) to choose from the products table any product to auto populate the form with the correct corresponding product info, i.e., product name, description and price, whether taxable, (and able to order the same product if needed, essentially another line item of the same product with perhaps different quantities entered) which then updates totals- essentially I wanted to turn your invoice template into a shopping cart/Invoice/Estimate functionality. Is Tapforms capable of this? Thanks.April 9, 2019 at 10:34 AM #34365
The way the Order Items work is that it’s a Table field. There’s a Checkmark button beneath it that lets you select from the Products form. Tap Forms will insert a record a copy the values from the Product form into the Order Items record. So in this way, you can get what you want with the same product listed multiple times but with different quantities. It’s already designed to work that way. Now if it were a Link to Form field it wouldn’t work that way because a Link to Form field would have a reference to the Product so you couldn’t have different quantities for the same Product.
Give it a try and see if it works the way I described.
BrendanApril 9, 2019 at 6:43 PM #34368
Hey Brendan, my friend- Thank so much for your fast reply- and that’s how I thought you had originally described the “invoices.tapform.zip” file to work so I downloaded the file- except one thing- the copy I downloaded (several times) from the link you provided has no “check mark” at or near the Order Items table field to allow me to insert the product values like you say it functions. Am I missing something? I am using Tapforms Version 5.2.5 (Build 881).
I have attached a pic of how the orders item looks to me when I open Tapforms. Thanks.April 9, 2019 at 10:29 PM #34370
Ah I see. Any particular reason for using an older version? Tap Forms 5.3.6 is the latest version. You’ll need that one to make it work right.
BrendanApril 10, 2019 at 7:04 AM #34382
Got it! Didn’t realize there was an update- works great bro. I Love Tapforms by the way! Thanks!November 29, 2020 at 10:09 AM #42752
Can I import this into the iOS version? Thank you
I figured it out, nevermindDecember 1, 2020 at 12:27 PM #42769
I love your invoice template. Since I’m paid for the time I spend with clients, how can TapForms track that?
Johnny VanderlipDecember 1, 2020 at 11:07 PM #42770
I’d create a new form and in that form create two date time fields: one for start time and one for end time. For the start time set it with default value set to “set current date”. If you link that from your client form with a link to form field, you can add a new record and it’ll record the start time when the record was created. You can then go back to that record and if you tap on “end time” on iOS you should be able to hit save to set it to the current date/time and on the desktop there is a “now” button in the calendar popover. You could add a location field as well and on iOS setting that is generally a matter of tapping in, waiting for the fix and hit save.
Once you’ve pulled up your client record, it’s a couple of taps to create the record and then two taps to set the end time (and two more for setting location if you do that as well). This might also work with a table field as well but I personally prefer having a full form most of the time as it gives you options to link to other forms in if it makes sense (e.g. linking in client visits to particular invoices for example).
Other fields that might be interesting would be a calculation field for duration, a field for block size (15 minute increments for example) and maybe even a rate field (phone call different rate to on site different to special location appearance).December 1, 2020 at 11:31 PM #42771
I’d also put in a notes field, maybe a subject field and a photo field depending on your use case.December 2, 2020 at 1:38 AM #42772
Since the Invoice Tracking app is based on orders and products and order items, you could modify that to rename the Products form to Services. The Order Items Table field could be renamed to Services Performed.
And you could do, as Sam suggests, add a start and end time fields to the Services Performed Table field, along with the calculation field to compute the duration, which could then be used to compute the total amount. The Services Performed table would be linked as it is now to the Products form (that you rename to Services), and when you click on the checkmark button to select a service, you find a record for the service and then Tap Forms will copy the service into the Services Performed Table field. Then you set the start and end times and the duration and total amount would be computed.
Please note that if you use Time fields, the times entered should be within the same day. If you think a service might span days, then use Date & Time fields instead as that will track the day change also.
Hope that gives you an idea of how it could be used to charge based on time rather than physical products.
BrendanDecember 10, 2020 at 2:09 PM #42827
I love Tap Forms 5. What would I have to do to use these templates to track total sales of each product over a selected time period?
Brue DusterhoftDecember 10, 2020 at 10:47 PM #42828
A quick way would be to use the advanced search to filter between dates and then use the multicolumn list view to pull stuff out. If you set it to “show group summaries”, you can group by a field (product) and use that to grab the details. Numeric fields will let you set an aggregation function like total that should do what you’re after. Make sure you set up your form settings with an appropriate group by field (product again being my guess) to get the summaries otherwise it’ll use the first sort field and likely not do exactly what you want.December 15, 2020 at 9:27 AM #42862
Thanks! This is a big help.January 24, 2021 at 6:59 AM #43282
I’m trying out Tap Forms to see if it will do what I need.
I’m looking to track orders I have taken from customers – and generate the orders I need to place with my suppliers.
I’m hoping to add the customer orders – then process these somehow into purchase orders for my suppliers – adding up the quantities required and scaling up to the minimum order quantities set by the manufacturer.
I’d then like a PDF purchase Order I can send to the supplier.
Is this possible?
I have downloaded the sample here but have not yet worked out how I ‘add’ a record from one area (order item) to another – in this case it would be a purchase order.
Many Thanks.January 25, 2021 at 1:55 AM #43288
This Invoice template can do this. I’m not sure what you mean by add a record from one area to another. In this template you create an order, then to create an order item, you click the + button to add an order item. Or you can click the checkmark button to select from a product to copy into the order item. Then you can adjust things like quantity and price.January 25, 2021 at 9:50 PM #43295
There was a similar request on consulting billing that sounds very similar that might provide some insight.April 7, 2021 at 2:05 AM #44063
Is there an easy way to email the order to a client? By way of a button?April 10, 2021 at 12:23 AM #44109
If you use the Print command in the File menu, there’s a PDF button on that screen. Click on it and then select Mail PDF.
BrendanMay 26, 2021 at 7:25 AM #44461
Any way to make a table field a reference to a record in other form indicating the “render” fields that will be visible on the field?May 27, 2021 at 2:29 AM #44471
If you want a reference to fields from another form, use a Link to Form field instead of a Table field. This invoice tracking sample you’re replying to has both Link to Form and Table field examples in it.
BrendanOctober 21, 2021 at 11:53 AM #45517
Just wanted to point out that the products section doesn’t show any products when saving as a PDF.
Using Tap Forms Version 5.3.19 (Build 1859) on Mac OS 11.6. This PDF is made by going to File > Print > Save as PDF.
- This reply was modified 3 days, 14 hours ago by timzu.
You must be logged in to reply to this topic.