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

Version 5.3.19 (build 1859) Release Notes

• Fix for unlinking records from an inverse many-to-many relationship. Tap Forms was unlinking all of the records instead of just the selected record.
• Fix for crash when URL has spaces in it when calling record.addPhotoFromUrlToField();.
• Fixed an issue with adding new records to a Link to Form field. The records were clearing when you had multiple Link to Form fields on the screen and you added a new record.
• Fixed an issue when you switched Link Types from Join to One to Many or Many to Many, the Join From field and Join To fields were still set. I clear them now.
• Fix for drag and drop not working to a Photo field on the Default Layout.
• Fix for accessory controls no longer responding to clicks on the Default Layout when you are viewing the Photo Grid view, then you search for a record, then clear the search term.
• Fix for Checkmark fields not behaving the same on custom layouts as they do on the Default Layout. The values were being generated as 0 or 1 instead of true or false.

Version 5.3.18 (build 1854) Release Notes

• Added record.addFileFromUrlToField(url, field_id) function to add a file to a File Attachment field.
• File attachment field filenames can now be searched in a Saved Search.
• Fixed a bug that caused importing records where a Number field had auto-increment enabled, the number values would be doubled upon import.
• Website accessory buttons weren’t behaving consistently between different views. I first attempt to have the OS open the URL. If it fails and it’s a file URL, Tap Forms will just select it in the Finder.
• Link to Form and Table fields now use row height setting from print panel when printing.
• Fixed an issue with the Bento importer when importing invalid data.
• Radio button and Checkbox button Pick List settings were ignoring the label position setting.
• Fixed crash on Big Sur when clicking a rating field on the multi-column list view.
• Preferences window no longer resizes because the resizing was jumping on Big Sur when you clicked the different preference panel buttons. So they’re all a fixed size for now.
• Fixes for font size settings when entering into a note field initially.

Version 5.3.17 (build 1852) Release Notes

• Fixed an issue on old macOS systems that caused the background colour of the fields list on the Default Layout to appear black instead of grey.
• The refresh records button was dark on a dark background. It now switches to dark in Light Mode and light in Dark Mode so it's more visible.

Version 5.3.16 (build 1849) Release Notes

• Fixes Preference window icons disappearing when clicked on macOS Big Sur.
• Fixed issue with wrong record being displayed when selecting a record while viewing the Calendar view records list.
• Added support for recovering deleted form scripts.
• Fixed text colour on recover deleted items screen in Dark Mode.
• Fixed crash deleting records from Photo Grid View.
• Fixed calculation field printing issue where Tap Forms wasn't formatting results properly.
• Added document.getUrl() JavaScript function to return the current document's file URL.
• Importing a CSV or XLSX file will now setup defaults when new records are created during the import process.

Version 5.3.14 (build 1842) Release Notes

• Fix for crashing note field value.
• Fixed crash printing
• Printing will now use less memory and should be a bit faster generating pages.
• Markdown editor now remembers the divider position.
• Saved Search popover now wraps the Description text.

Version 5.3.13 (build 1837) Release Notes

• Fixed crash opening Preferences window.
• Fixed issue with Markdown editor window not remembering its last size and position settings.

Version 5.3.12 (build 1835) Release Notes

• Added new Markdown field type. This is a "note" type field where you can type in markdown and Tap Forms will render it for you.
• You can now align photos left, right, centre, or middle (up/down) within the photo image bounding box on a custom layout.
• Fix crash rendering pie chart view.
• Added list of form layouts to the Layout menu. Changes dynamically depending on selected form.
• Added script functions to let you get and select custom layouts.
• You can now specify a local folder for scripts on the Preferences window, to be able to access photos when calling addPhotoFromUrl();
• Added All Scripts / Favourite Scripts control to the form scripts tab. You can mark a script as a favourite and it will be shown there. So you can now filter between all scripts and just your favourites.

Version 5.3.11 (build 1833) Release Notes

• Fixed a bug where copying a date field from the Multi-Column List View would not return the formatted date value. Instead it returned an internal format for the date.
• Added support for absolute row height for Table of records print layout instead of a row height multiplier.
• Fixed issue with changing column widths not saving on multi-column list view.
• Fixed bug with copy and paste of formatted decimal values on multi-column list view in non-English regions. If a region used anything other than the . for the decimal place, it would paste the wrong precision value into another column.
• Fixed issue with Numbers on Default Layout not showing red when negative when the Highlight Negative Numbers option was enabled for the field.
• Fixed bug with causing a Table field not to save its last entered value if you didn’t click outside the field before you edited a Note field in the parent form.
• You can now clear the contents of a Note field on the Multi-Column List View by pressing the delete key. Editing still requires opening the Note field edit window.
• Added the following APIs to the Scripting engine: Utils.addToCalendar(), Utils.addToReminders(), Utils.updateCalendarEvent(), and Utils.updateReminder().
• Exporting records to a CSV file now makes sure exported photos have a unique filename.
• Fixed issue with escaping commas and other special characters in values in a formula retrieved from a Script that returns Text.
• Added feature to enable or disable Apple Data Detectors on Note fields.
• Fixed crash exporting CSV file with photos where the photo has an invalid EXIF timestamp.
• Added the ability to call a Form Script from a tapformz URL.

Version 5.3.10 (build 1832) Release Notes

• Fixed a crash on macOS Sierra when syncing with iCloud.
• Fixed an issue with the Time field not displaying the time properly.
• Fixed crash when pasting date values into the multi-column list view.
• Fixed a crash when using a Script Field that is displaying the Prompter().
• Fixed crash with Photo Grid View when section headings were not displayed.
• Added support for a custom Date formatter on the Field object. E.g. you can type something like MMMM dd, yyyy 'at' HH:mm:ss z which would produce January 01, 2020 at 19:10:00 MST.
• Fixed issue that could cause Bento template importer to fail if a file attachment was not readable.
• Fixed an issue where typing into a Text field in a custom layout, then selecting a value from a popup button would cause the Text field value not to be saved.
• Added double-click up to dot support to Script Editor.
• Fixed bug where renaming a photo on the media browser window would always select the first photo.
• Fixed bug where calculation fields and script fields weren’t being evaluated when new records were created.
• Added new functions for working with Script objects in the Script editor. For example, form.getScripts() returns a list of scripts in the form. form.addNewScriptNamed("New Script") will create a new script with the specified name in the form.
• Copy Style and Paste Style now active for the selected Layout Item(s) on the custom layout editor. You can select one layout item and press command-option-c to copy the style of that layout item and paste it to another set of selected layout items on the same or different custom layout within that form.
• Fixed issue where multi-column list view didn’t use the value colour when you had highlight negative values enabled.

Version 5.3.9 (build 1825) Release Notes

• Media browser window on Photo field now supports multi-page PDFs.
• Added indent/outdent buttons on Script Editor. Command-[ and command-] keys to outdent and indent respectively.
• Added new Progress class to Script Editor to let you display a progress indicator for long running scripts.
• Added new "Progress indicator" Snippet that writes the code for you to show a Progress indicator.
• Added document.getPickLists() and document.getPickListNamed("name") functions to the Scripting engine.
• Pick Lists have the following functions/properties: getId(), form, name, and values.
• Fixed issue with exporting and importing form templates (.tff files) that have Access Controls enabled and the Charts view settings.
• A progress bar is now displayed when refreshing records. You can cancel the refresh too.
• Scripts now run in the background when executed and should perform better.
• Added colours to the console.log() command. E.g. console.log("Hello World!", "#c90000"); Uses html web hex colours.
• Improved console logging performance. The console log now scrolls as your scripts are running.
• Fix for Switch Field Type issue where if you cancelled, the Field Type popup button wouldn’t revert back to the original. Although it was still internally set to the previous field type.
• Added support for multi-select Pick Lists to the Multi-Column List View, Table field, and Link to Form field tables.
• Fixed issue with field value disappearing if you didn’t choose a value from the Pick List popup button on the Multi-Column List view, Table, and Link to Form fields.

Version 5.3.8 (build 1821) Release Notes

• New Charts module! Plot your data using either a bar, line, or pie chart.
• New User Access Controls (Mac only for now). Set a password on a form that can be used to prevent editing of the form, adding, deleting, or updating records.
• Catalina compatibility fixes.
• Added new functions to the scripting engine. Functions for accessing the clipboard, getting forms with IDs, and for initiating the Print command from a script.

Version 5.3.7 (build 1819) Release Notes

• Just a quick fix to correct a crash when adding a new record and then clicking the Note field button on the Default Layout to add a note. The crash happens only when you have Plain Text Note enabled for your Note field.

Version 5.3.6 (build 1817) Release Notes

• Added support for setting the colour of a Rating field on a custom layout. Use the colour button on the Text toolbar to set the selected Rating field’s star colour.
• Added support for setting a Note field to be a Plain Text Note. Tap Forms will then display all the content in a Note field using a single font and size.
• Fixed bug where you could still paste into an Auto-Increment field on the multi-column list view.
• Fixed bug where if you entered a value into a field on a custom layout and then clicked on a Pick List value (radio or checkbox), Tap Forms would lose the value entered into the field.
• Fixed a crash when saving (hence closing) the Location field map window on macOS Sierra.
• Fixed bug where Tap Forms was not taking into consideration the search term when setting up the calculations popup button.
• Recognize Nearby sync for display on documents list.
• Worked on label printing position issue when starting off in a different column.
• Fixed crash hiding sections on photo grid view.
• Fixed sorting issue where Tap Forms wasn’t remembering the sort direction on File Attachment fields.
• Fixed bug where duplicating a form wasn’t selecting the new form.
• Support for smaller font sizes on the multi-column list view.
• Fixed hang problem when determining if the auto-complete should appear or not in the Script Editor. It would hang when typing a quote character or when just entering in quote-space-quote.

Version 5.3.5 (build 1814) Release Notes

• Added support for Continuity Camera in macOS Mojave. With that you can right-click on the photo preview on the record and choose ‘Import from Device’. Your iOS device’s camera will activate and if you choose to use the photo taken, it will be transferred to the Photo field in Tap Forms. It’s also available from the Action menu on the media browser window.
• Photo field now supports animated GIFs.
• Field types other than Text now support the value colour property.
• Fixed bug copying and pasting layout objects. They weren’t retaining their properties from the source layout objects.
• Pick List Values edit screen now displays values with dynamic row heights. So if you have long values, they won’t get truncated.
• Added Search field to Pick List Values edit screen to help you find values that you may want to edit.
• Added new JavaScript functions to support fetching field objects, importing other scripts into a script, and other new JavaScript functions.
• Added Show in Finder function to the media browser to show you the .blob file on disk that corresponds to the photo you’re viewing.
• Added support for using a Pick List to get the values to select from in the JS Prompter. When you add a parameter to the Prompter, pass in 'picklist' for the parameter type and the Pick List name as the value.
• Bento importer now imports Calculation fields that return Text values.
• Text field layout item wasn’t respecting Capitalization function.
• Added field ID to the Script Editor window. When you select a field, the ID is displayed between the Fields list and the Snippets list. You can select the field ID too.
• Pasting in a field ID into the Search field will show you the field that matches the ID.
• Added support for auto-complete in the Script Editor.
• Added support for referencing other Script fields in the Script Editor.
• Added support for MM:SS number format. Formats seconds into minutes and seconds.
• Note fields will now trigger calculation and script field executions when saved.
• Added list of custom paper sizes to Paper Size popup button on the Layout Inspector panel. Custom paper sizes are defined on the Print window. They will appear at the bottom of the list of paper sizes.
• Improved support for displaying high DPI images in the media browser and media preview views.

Version 5.3.4 (build 1807) Release Notes

• Lines print again on custom layouts.
• Improved the way lines are drawn and sized on custom layouts.
• Value colour honoured on the Default Layout.
• The inverse of a Join relationship wasn't displaying the related parent records.
• Script editor now correctly generates the right code for inverse Join relationship field references.
• Fixed bug where record link wasn't taking you to the document and form and record anymore.
• You can now see PDF files on the media browser.
• Document names can now have a forward slash in their file names.
• Script fields are now updated if the Table or Link to Form fields they reference are updated on a custom layout.

Version 5.3.3 (build 1804) Release Notes

• Quick fix for a crash displaying some photos that have no file extension.

Version 5.3.3 (build 1801) Release Notes

• Fixed printing bug that caused static images to print only on the first record.
• Fixed crash dragging items on the Layers tab on the Layout inspector panel.
• Media browser window now support high DPI images for scaling. Previously they were rendering small. For example, an image that was scanned at 600dpi would only show at a small size and the zoom controls wouldn’t do anything because the image was smaller than the media browser window.
• Added support for auto-complete to Email and Phone fields.
• Fixed an issue where a Script field was being evaluated even if a field was edited that wasn’t referenced in the script.
• If a photo goes missing, Tap Forms will try to reconnect it if the file is still in the attachments folder witin the .tapforms document.
• Increased height of barcode renderings.
• Fixed crash creating compound searches.
• Fixed bug where custom layouts were coming up blank when printed on macOS High Sierra.
• Added form.selectRecord(record); function to select a record for the specified form. Good for when you add a new record in a script and want the new record to be selected after the script runs.
• Auto-complete menu appears properly in Dark Mode on Mojave now.
• Added support for forward delete key when deleting photos.
• Added record.getNoteFieldValue(field_id); method to get the rich text value from a Note field.
• Added record.setNoteFieldValue(field_id, value); method to set the rich text value on a Note field.
• Bolded Section Heading fields in Fields lists.
• Fixed issue with grey background appearing on long Note fields.
• Fixed issue with paste between layouts causing pasted objects to be cascaded.
• Added support for no parameters in JavaScript Prompter class.
• Added support for specifying a boolean parameter in JavaScript Prompter callback function so you can detect if the Cancel or Continue button was clicked.
• Fixed an issue where thumbnail preview images weren’t being generated properly on the Default Layout.
• Fixed some copy and paste issues on custom layouts.
• Script buttons will no longer be on the output when printing a custom layout.
• Added new Link Type icons for the Link to Form field type to help you identify what Link Type was selected for your Link to Form fields.
• Cosmetic adjustments to the category names on the left. Uses a triangle now instead of the Show / Hide button. The triangle will make it easier to determine if a category is expanded or collapsed.
• Alignment controls on a custom layout now are based on the first selected layout item. That is, other objects will align to the first select object’s position.
• Supports forward and back delete key on layout editor.
• Note and Console windows now closed when their parent document window is closed.
• Added support for customized Prompter buttons using prompter.setCancelButtonTitle() and prompter.setContinueButtonTitle().
• Script field values can now be referenced from Calculation field formulas.

Version 5.3.2 (build 1797) Release Notes

• Just a quick fix for Tap Forms not asking for permission to access Calendars and Reminders on the Date & Time field.

Version 5.3.2 (build 1796) Release Notes

• Supports importing multiple Tap Forms Archive (.tfarc) files at once now.
• Fixed a crash when clicking the Edit Label button.
• Fixed issue with text appearing black in Dark Mode on Mojave on the Calendar view.
• Fixed a performance problem when editing records in a form that has a Photo field in it. Eventually Tap Forms would get bogged down and consume all your CPU and lots of memory.
• Thumbnails are now generated immediately when dragging a photo into the new Media Browser window.
• Adjusted the scaling of photos so that if there's only one photo in the field, it scales to fit rather than scales to fill, eliminating the images being cut off on the left and right for landscape oriented images.
• Fixed a bug that prevented the last cell at the bottom-right of the spreadsheet views from recognizing clicks.
• Fixed photo printing issue when using the Table of records print layout. Photos weren't being scaled properly.
• The content in Pick Lists that were using the Combo Box control was overlapping the button arrow on the right if the layout object was set to be right justified.
• Fixed a paste bug that caused the spreadsheet controls to not render all the columns after the paste, causing you not to be able to reach the columns to the right.

Version 5.3 (build 1789) Release Notes

• Full support for macOS Mojave Dark Mode.
• Added new Script field type which lets you create JavaScript functions which can be used to perform advanced calculations on your record data. Think of it as the Calculation field on steroids.
• Along with the new Script field type, you can now create Form level scripts to let you do all sorts of things with your data, including inserting, updating, and deleting records, all from a script!
• Brand new Photo Browser window for viewing all your photos in one large window. You can easily drag and drop new photos into that window and use drag and drop to easily reorder your photos.
• Added new Value Color property to let you colour the values displayed in the multi-column list view.
• Basic AppleScript support. Currently you can tell Tap Forms to run a Form Script and have it return the results to your AppleScript. If you're into AppleScript, let me know what else you'd like to be able to with AppleScript and Tap Forms.
• Link From Form fields that have the Join Link Type property now display properly as tables on custom layouts. They were displayed as an empty box before.
• Fixed a date field save bug that caused a date value to be lost if you entered a date value then refreshed the records.
• Fixed bug where footer popup buttons would still work even if they were hidden.
• Fixed bug in Bento template importer that was skipping all but the "other address" when importing the Bento Address Book library.
• Fixed bug that caused row height on single-column list view not to show all the displayable fields.
• Fixed crash deleting a row from a Table field if the Table field has no name.
• Fixed bug where command-right arrow wasn't working when you were editing a field. It was instead visiting a linked record.

Version 5.2.11 (build 1787) Release Notes

• If you have a Text field with boolean type values in it, e.g. 1, 0, yes, no, y, n, true, false, etc. Tap Forms will interpret those as on or off when you switch the Field Type to Checkmark.
• Fixed a bug with Calculation fields that caused any Text type fields not to be quoted in the formula if they came after any Number type field in the formula.
• Updating a formula will no longer update the modification date of all the records.
• Fixed crash rendering group summary rows after typing in a search term.
• Fixed an issue where Checkbox and Radio Button Pick Lists wouldn’t save the selection if no value was there in the first place.
• Fix for potential crash when clicking the accessory button on the multi-column list view.
• Setting the background colour of multiple records to clear doesn’t make the record background completely black anymore.
• Fixed a bug with section headings when printed can be cut off on the left.
• You can now enter in a comma, period, or colon as a delimiter within a Number field that has the HH:MM or HH:MM:SS Number Format specified and Tap Forms will convert them all to colons. For example, 01,25 and 01.25 will both be converted to 01:25.
• You can also use commas and periods or colon characters as a delimiter within Time fields.
• Fixed a losing focus issue when typing into a Date field and tabbing to the next field.
• Fixed bug importing text properly if the field names in the CSV file had spaces after them.
• Fixed bug where command-right arrow wasn't working when you were editing a field. It was instead visiting a linked record.
• Fixed crash deleting a row from a Table field if the Table field has no name.

Version 5.2.10 (build 1785) Release Notes

• Just a quick fix for encryption not working.

Version 5.2.9 (build 1784) Release Notes

• Added new Pick List display options. You can now choose to display a Pick List using checkboxes and radio buttons. On a per-field basis you can also change the number of columns of checkboxes and radio buttons that are displayed. Tap Forms will also show you the colour value as a ◆ character next to the Pick List value.
• Contact images now fit properly on the single-column list view.
• Contact image thumbnail size can now be changed.
• You can now display the count of the number of items within each section for Text fields on the records list view.
• You can now display the total count of the number of items within a Text field at the bottom of the records list view.
• Fixed an alignment issue with printing totals and sub-totals on the "Table of records" report.
• Added support for command-enter on the Map View screen to save the location for an individual Location field value.
• File attachment field: Added drag and drop support to create aliases when the control key is held down.
• Table headers now respect font selection on custom layouts.
• You can now change the colour of the text in a Link From Form field on a custom layout.
• Added empty colour to colour popover in order to erase the selected colour for the object being edited. Tap Forms will revert back to using the default colour for the object.
• Fixed bug that caused the record details view not to refresh sometimes when you deleted a record on the multi-column list view.
• Fixed bug that caused the categories to expand globally instead of on a per document basis.
• Table field’s row height now adjusts as you add records to it.
• Fixed issue with bottom-right cell of Table/Multi-column List View/Link to Form field view not being able to be clicked on when you add a new record.
• Displays how much memory the record uses on the record details view.
• Fixed crash issue when deleting a tab order value.
• Checkmark buttons on custom layouts can be tabbed to now.

Version 5.2.8 (build 1783) Release Notes

• Just a quick update to fix a regression bug where Calculation field results that returned Text values wouldn't display on the Default Layout.

Version 5.2.7 (build 1779) Release Notes

• Fixed issue with expanding and collapsing the Section Headers. It was only working once.
• A more detailed error message will appear if the Sign In button fails when connecting to Cloudant or Apache CouchDB.
• When you switch from record to record, Tap Forms will remember the scroll position of the Default Layout. Tap Forms will no longer jump to the first field when you switch records.
• The Default Layout also stays put when you rename fields and do other things that adjusts the form’s structure.
• Fix for setting images using the camera on a custom layout. When you added an image, then clicked the QuickLook button, Tap Forms wouldn’t show you the image if it was the 2nd image you added to the Photo field.
• Added support basic authentication when syncing with Apache CouchDB.
• An inverse to-one relationship on a custom layout will now respond to font size changes made in the layout editor.
• Website address field type can now be displayed and printed as a barcode on a custom layout.

Version 5.2.6 (build 1774) Release Notes

• Added Default Value for Rating field type.
• Added Arabic translation and right-to-left user interface support.
• You can now connect a form to a Table field and copy selected fields from that form to the Table field's definition.
• You can now select and copy records from a connected form. Tap Forms uses matching field titles to choose which values from the selected records to copy. It's like a Pick List on steroids for the Table field.
• Fixed bug that caused the date picker to dismiss when you clicked quickly on the arrow buttons to advance months. Double-clicking still works on the day numbers below that.
• Calculation fields will now pass in empty dates into the formula engine. This means if you have a formula that should only execute if the Date value is not empty, you’ll need to put in an IFEMPTY() function call to test your Date field to see if it’s empty or not. Otherwise you’ll get the wrong result for your formula.
• Fixed bug where if you deleted an object on a custom layout, the Labels and Print custom layout areas would reset to sized used for screen layouts.
• Fix for exporting Location field that was empty. It was causing a shift in the output for that record so the columns and data didn’t match.
• Fixed bug where if you edited a value in a record, then switched to a different record and then clicked on the Default Layout, the values changed from the previously selected record could be copied over to the selected record.
• Fixed a bug where the Photo field was not responding to drops when you switched between records if you had multiple Photo fields in your form.
• Added support for the PI (3.14159...) constant in the formula editor.

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.