Make sure you've backed up your database documents before you perform any software updates.

Version 5.2.5 (build 1764) Release Notes

• Section Heading fields can now be collapsed and expanded, just like on the iOS version.
• Added Use Auto-Complete function to Text fields. Tap Forms will generate an auto-complete popup list of values from other values for that field in your form. Similar to Excel and Numbers.
• Added UUID() function to the Formula Editor to generate a Universally Unique Identifier.
• Added function to let you use an Emoji character to set the form's icon.
• Added Description property to the Field so you can describe what each of your fields is for. When you hover over a field title in your form, a tooltip will display the contents of the field's Description property.
• If Cloudant sync gives a request too large error, Tap Forms will now take you to the record that caused the sync error so you can correct the issue.
• Added support for exporting Table fields to CSV files.
• Fixed crash when clicking on a Table or Link to Form field table when you had no records in it.
• Added formula Result Type to the field properties when a Calculation field is selected. Makes it possible to see the Result Type without having to edit the formula.
• The formula editor now tells you what type each function returns (e.g. Number, Text, or Date).
• Changed default delimiter to semi-colon for the formula editor.
• Added support for inserting the Date, Time, and Date & Time into a Note field. Available from the new Insert submenu on the Edit menu.
• The Print table of records function will now print the fields in the same order they are set to on the multi-column list view.
• Added Russian localization.
• Other bug fixes.

Version 5.2.4 (build 1748) Release Notes

• Added NEWDATE() function to let you specify a bunch of date components in order to get a date value back. E.g. NEWDATE(2017,11,0,5,4,0,0,0,0) will return the 4th Thursday in the month of November in 2017.
• Added EOMONTH(Date, X) which will return the end of the month for the specified date for the specified number of months ahead or behind Date as specified by the X parameter).
• Added DATEADD() function to add a specified date component to the provided date.
• Added STR2NUM(A) function to convert a string representation of a number to a real number that can be used in mathematical expressions.
• Added DATEVALUE(A,B) method which will return a real date given a string representation of a date and a date pattern to parse. For example: DATEVALUE("2017-11-23", "YYYY-MM-dd") will return the date Nov 23, 2017.
• Added AVG(X;Y;…) function to calculate the average of a set of fields. 0 and empty values are ignored in the calculation.
• Fixed bug with printing Date fields. If you had the "Print Empty Fields" print option turned OFF, date fields would not print.
• Searching with Show Group Rows enabled on the multi-column list view will now properly display all the data. The record was not being displayed if there was only one record in the result set. Or one less than the number of records meant to be displayed.
• Fixed a bug with adding different photos that have the same filename to a Photo field. Tap Forms will now add a number to the filename of the photo added so that it is uniquely named. This could happen even with different fields in the same record.
• Pasting into the multi-column list view or the Table field will now add additional records if needed to fit the content on the clipboard.
• Added support for duplicating the records in a Table field when you duplicated the parent record.
• Fixed a bug where a Note field would be cleared out on a custom layout when you clicked the Save button.
• Fixed a bug that caused record selection not to work if you searched all forms and then cleared the search field.
• Improved text highlighting on the Forms List screen when renaming a form.
• Note fields can now be cleared completely and the content won’t revert to the previous value on a custom layout.
• Added font size slider to the Formula Edit screen to let you change the size of the font.
• Added support for remembering the layout orientation on Note fields on a custom layout. Useful for vertically oriented Japanese text.

Version 5.2.3 (build 1727) Release Notes

• Fixed a Dutch translation issue.
• Fixed an SSL connection issue with High Sierra when using Nearby sync.
• Added a "Recover deleted items" function to the File menu. Use this to recover any items recently deleted from the database.
• Fixed some more High Sierra compatibility issues.
• ComboBox style Pick List now allows tabbing out and to the next field.
• Fixed bug with database being closed prematurely upon quitting so we would lose the last value entered into the current field.
• Fixed an issue with dragging and dropping text into a Note field on a custom layout. It wasn’t saving if you quit the app or switched records.
• Fixed height of Table field spreadsheet control so there's room for a horizontal scrollbar without overlapping the last row.
• Table field sub-fields can be referenced in formulas now.
• The correct field properties are now displayed when you fitler the fields.
• Fixed an issue with the Photo field getting cut off and not scrolling in High Sierra.

Version 5.2.2 (build 1716) Release Notes

• Fixed some High Sierra compatibility issues.
• Group summaries on the multi-column list view are displaying now.
• Uses the spreadsheet control for Link to Form fields on custom layouts now.
• Added Sync button to the Customize Toolbar screen so you can optionally add it to your document window's toolbar.
• Added popup button at the bottom of the document window to allow you to select between displaying the sync's Last Upload and the Last Download times.
• You can now double-click on the day of the month number on the date picker to select that date.
• Summary group rows resize along with other cells on multi-column list view when the font size slider value is changed.
• Tap Forms will no longer quit when the last window is closed.
• You can now adjust the font size of the content of the Table and Link to Form views on custom layouts.
• Added new LEFT(A,X), RIGHT(A, X), and POS(A, B) functions to the Formula editor.

Version 5.2.1 (build 1697) Release Notes

• Fixed a German localization issue that caused the Sync button not to appear.
• Fixed an issue that prevented the Multi-Column List View from refreshing when you enabled or disabled fields on the Select Fields popover.
• Added a tooltip for the Select Fields popover button at the top-right of the Multi-Column List View.

Version 5.2 (build 1696) Release Notes

• Added many new functions to the formula editor. There are now functions for computing date differences, formatting date values, determing the length of text values, displaying the substring of text values, displaying the years, months, and days between two dates, and many more.
• Added a new Table field type which allows you to create fields that have multiple values displayed in a grid format. Similar to Bento's Simple List field type.
• Added an Import Contacts function to the Import menu. Tap Forms will import your contacts from the Apple Contacts database in one go into a special Contacts form. All your contacts will be imported at the same time. Any fields from the Contacts database that contain multiple values, such as Email, Phone Number, and Address fields will be imported as Table fields in Tap Forms.
• The Link to Form field values can now be edited right in place without visiting the child record details view. You can still visit the details view for any child records by double-clicking on the row number.
• Enhanced the Bento Template Import function to import Bento's Simple List field type.

Version 5.1.4 (build 1660) Release Notes

• Added support for adding an entry to your Reminders when using a Date & Time field.
• Added ability to search Time fields to the advanced search feature.
• Prints the date, time, and page count footer on custom layouts now. You can disable that on the options tab on the Print panel.
• Drag and drop of photos within field wasn’t saving.
• Double-click to QuickLook photo implemented.
• Fixed mistake in sample date formatter pattern in math functions. Should have been MMM instead of mmm.
• Calculation fields that return dates no longer show in light grey.
• Multi-column list view was losing focus when you entered a value into it and pressed the tab key.
• Number fields on a custom layout now refresh when the number formatter is changed.

Version 5.1.3 (build 1653) Release Notes

• Text inspector bar buttons weren't enabling when you selected a layout item.
• Grouping by rating field was showing “Group Header” in section heading with 0 for the rating values.
• Fixed bug with select all not enabling the text inspector bar controls.

Version 5.1.2 (build 1652) Release Notes

• Added FORMAT(X, "#.00") function to the Formula Edit screen to let you format numbers in your Calculation fields that return Text values.
• Tap Forms now remembers the last record you selected for every selected form or saved search.
• Fixed crash on El Capitan when you tried to link to a contact using a Contacts field.
• Improved the performance of the Calculation field when concatenating strings and numbers.
• Fixed crash when making a backup while you had the layout inspector panel visible.

Version 5.1.1 (build 1645) Release Notes

New Stuff

• iCloud sync and Apache CouchDB sync support was added to the Sync Settings screen in addition to IBM Cloudant and Nearby sync.
• Greatly improved VoiceOver support.
• Touch Bar support for MacBook Pros.
• Import, Export, and Print Presets allow you to save and quickly retrieve different sets of settings.
• All new formula editor screen for Calculation fields.
• Formulas can now reference fields from related parent and child linked forms.
• You can now use text fields in the IFEMPTY() and IFNOTEMPTY() functions in your formulas.
• New DATE() function allows you to specify how you want a date to be formatted in a formula's result.
• With a Saved Search selected, exporting a Tap Forms Archive will now export only the records that were displayed.
• Pressing option-Return on the multi-column list view will now put that cell into edit mode.
• The Select Fields popover on the multi-column list view can now be changed for each saved search. So you can have different fields displayed depending on the selected search.
• The Select Fields popover now allows you to rearrange the order of fields displayed on the multi-column list view independently of the order of the fields in the form.
• Added Duplicate Document function to main Database Documents window.
• Added "New Document" function to the File menu.
• Geo coordinates are now displayed below the location title on the record details view.
• Photos on the record details screen can now be sorted based upon the photos' filenames.
• The text size can now be changed on the multi-column list view.
• Bulk Font Changes: you can now change the font in a Note field across all records in the form.

Fixed Stuff

• A power failure could cause the document's internal SQLite database file to become corrupted.
• The wrong records were being printed when the Photo Grid View was selected.
• Multi-column list view was not displaying when you created a new form and switched to that view unless you dragged down the divider line to reveal it.
• And last but not least... fixes for other broken stuff.

Version 5.0.10 (build 1579) Release Notes

Changes

• NOTE: This update will take a little longer to open your documents the first time as Tap Forms rebuilds its indexes.
• Added support for Touch ID on the new MacBook Pro with Touch Bar. On the Security Settings Screen, click the Enable Touch ID checkbox to enable it. The document should be encrypted for Touch ID to function.
• Added support for importing file attachments along side the CSV file.
• File Creation Date now displayed on File Attachments field.
• File Attachment field now remembers which column you last sorted on.
• You can now unlink one-to-many relationships. You used to only be able to delete them.
• Calculation fields that return Dates will now display the format the same on a custom layout as they do on the Default Layout.
• Import field name/type detection is now case insensitive on the Import Records screen.
• Now remembers the current search term when switching views.
• Fixed issue with duration values not importing from a CSV file.

Version 5.0.9 (build 1567) Release Notes

Changes

• Added support for importing a folder of photos along side the CSV file being imported.
• Text links in Note field now display with blue colour.
• Fixed issue with Note field layout item not respecting a user’s font selection when typing in new data.
• Now deletes the icon attachment from a Contact record when the contact is removed.
• Fixed potential crash printing records with photos.
• Fixed bug with date field clearing out when you navigate from one field to another on a custom layout.
• Selecting a map annotation view now doesn’t reset the selection to be the form if the current selection is a saved search.
• Switching Date & Time field type to Date or Time will now strip the Time or Date appropriately.
• Fixed print alignment issues.
• Date and Time popovers now properly sets the date and the times by stripping off the date from times and stripping off the times from dates when required.
• New records on the single-column list view now update as you enter data into the fields in the form.
• New records added to a form are now put into the first section in the records list instead of above the first section if you’re sorting your records in descending order. When sorting in ascending order, the new records always go to the bottom of the records list.
• Fixed a bug with the fill down function on the multi-column list view for date fields. The first cell was being cleared after you let go of the mouse.
• Localization updates.

Version 5.0.8 (build 1558) Release Notes

Changes

• Fixed issue with losing photos when you dragged a photo from one Photo field to another.
• Sometimes the Link to Form field's header row would print at the top of the page.
• ComboBox Pick List is now case insensitive during auto-complete.
• Fixed memory related issue with bulk resizing photos.
• Improved performance of resizing photos.
• Fix for printing Link to Form fields where it wasn't printing the fields in the proper order.
• Share button now active even when document open. But tells you to close the document if you click on it when the document is open.
• Faster refreshing of the Database Documents window when you rename a document.
• Localization updates.

Version 5.0.7 (build 1552) Release Notes

New Features

• Added new Freeze Header Columns function for the multi-column list view. This works the same as in Numbers where you specify how many columns you want to freeze. Then you can scroll the content horizontally to the right of the frozen columns and the frozen columns will stay in the same position.

Bug Fixes

• Miscellaneous bug fixes.

Version 5.0.6 (build 1551) Release Notes

Bug Fixes

1. macOS Sierra compatibility fix for tabbing no longer working to navigate through the fields on the Default Layout.
2. Fixed bug with alerts when setting the Repeat option to Yearly. It was making it go daily instead.
3. Added a notice when you try to sync with a document using Nearby sync when you don't have the same Sync Password set on each device. Previously you would get a 401 error. Now it tells you it's unauthorized and directs you to make sure the Sync Password is the same on every device for the opened document.
4. Favourites now sort properly according to the form's sort settings.
5. Added back the Restore command in the File menu. It restores only if the file doesn't already exist in the Documents list.
6. Now you can duplicate multiple selected fields at once.
7. Added warning for deleting pick list values.
8. Double-clicking on a child record from the popover view now selects the child record.
9. Fixed bug with row heights not being calculated properly on favourites list.
10. Fixed bug where custom layouts for the selected record’s form weren’t being shown on the favourites list when switching records.
11. Miscellaneous crash fixes.

Version 5.0.5 (build 1546) Release Notes

Bug Fixes

1. Fixed bug dragging and dropping photos from field to field where you could lose the dragged photo.
2. Photo field no longer sucks up vertical scrolling events.
3. Fixed find and replace when selecting across section headings on the multi-column list view.
4. Added additional bounds checking to prevent a potential crash when printing the table of records.
5. Bento importer now properly warns about older template versions that it can't import.
6. Fixed bug where no content was shown in the records list view when an Audio Field was the first field in the form.
7. Backup on Quit function no longer creates 2 backup files, one being invalid.
8. Fixed website accessory icon so it's no longer sized too big for the button.
9. Fixed various crashers.

New Things

1. Added Fill Up/Down function to Edit menu for the multi-column list view.
2. The last selected sync service tab is remembered between launches.
3. Photo field now highlights background when photo is dropped onto it so you know where the drop zone is.
4. Disabled Link From Form field from Field Types popup so you can’t select it. Use the Show Inverse Relationship function instead.

Version 5.0.4 (build 1545) Release Notes

Bug Fixes

1. Fixed divide by zero error when evaluating formulas. Was preventing records from saving.
2. Fixed issue with duplicating layouts where the order of items wasn’t maintained properly.
3. Fixed unlink bug where it was unlinking all records for the selected link.
4. Fixed duplicate form bug where it wasn’t properly setting the new duplicated fields on the custom layout items.
5. Fixed bug with Refresh button where the record on the record details view was reverting to the first record in the form when you clicked the Default Layout or on a custom layout, but the selected record still showed the previously selected row.
6. Fixed bug deleting audio files. They weren't being deleted. They are now.
7. Fixed duplicate layout issue where the layout's background colour wasn’t being set and any rectangles on the layout were moving to the top of the layers list. It made fields beneath the rectangles not appear on the layout until you moved the rectangle further down the layers list.
8. Improved performance of generating thumbnails on multi-column list view.
9. Miscellaneous fixes that caused some crashing.

New Things

1. Added Ruler menu commands to add a ruler to the Note field editor windows.
2. Implemented paste for images on custom layouts.
3. Added delete confirmation to the swipe to delete function.
4. Tap Forms should now remember if you've collapsed the record details view to show just the spreadsheet view the next time you visit that form.

Version 5.0.3 (build 1521) Release Notes

Bug Fixes

1. File attachment field aliases now show on custom layouts.
2. Single-file File Attachment field's view file button now works on a custom layout.
3. File attachment field won't cause a crash now when you delete an attachment and then add another one.
4. Fixed bug that could cause crash when receiving a document from another device when the Database Documents window is not showing.
5. Cloudant passwords can now have symbols and be longer than 17 characters. It was an encoding issue in Tap Forms causing this bug.
6. Tap Forms will now remember the last opened documents when you quit the app without relying on the General System Preferences setting for that.
7. Search All function now works properly again.
8. Logging into an encrypted document after the auto-lock timer kicks in no longer displays an empty window.
9. Auto-lock timer value is now being saved.
10. Pasting into the multi-column list view works properly again, especially for date values.
11. Deleting records should now perform much better than before, especially when deleting a lot of records in one shot.
12. The sort triangle at the top of the multi-column list view works now when a saved search is selected.
13. Improved performance of thumbnail icon generation on Single Column List View.
14. Single Column List View now generates different row sizes in order to better fit the content.

I apologize for the bugs that were present in the previous versions. I am working very hard to fix all the issues that have been reported. Thanks to all the kind people who have reported these issues to me.

Version 5.0.2 (build 1518) Release Notes

Bug Fixes

1. Fixes a bunch of crashes that were reported.

Version 5.0.1 (build 1514) Release Notes

Bug Fixes

1. Tap Forms was not requesting access to your Contacts database when you clicked on a Contact field.
2. Scrollbars were not showing on custom layouts.
3. Backup on Quit now works again when closing a window.
4. Fixed issue with migration not always migrating everything.
5. Fixed issue with encryption causing possible corruption of a document.
6. Miscellaneous bug fixes.