# Latest **URL:** https://www.five.org/latest.md [Latest](https://www.five.org/latest.md) · [Categories](https://www.five.org/categories.md) · [Tags](https://www.five.org/tags.md) --- ## [Welcome to the Five Community!](https://www.five.org/t/welcome-to-the-five-community/7)
**Author:** [@system](https://www.five.org/u/system)\ **Replies:** 0\ **Last updated:** [June 11, 2021, 5:14am UTC](https://www.five.org/t/welcome-to-the-five-community/7 "2021-06-11T05:14:50Z")
Hi and welcome to the Five community! :wave: It’s great to see you here! The Five Community is the place to meet fellow Five developers & builders and to learn how to build powerful applications with Five. Find out ho… --- ## [Need Clarity on Users and Roles](https://www.five.org/t/need-clarity-on-users-and-roles/724)
**Author:** [@RMittelman](https://www.five.org/u/RMittelman)\ **Replies:** 5\ **Last updated:** [September 23, 2026, 2:56am UTC](https://www.five.org/t/need-clarity-on-users-and-roles/724 "2026-09-23T02:56:07Z")
I’ve read the documentation on Users and Roles, but these seem to be related to Five users and roles, not my application’s users and roles. My aim is to have user roles in my application, which allows them to see certai… --- ## [Report Not Formatting Properly in Version 3](https://www.five.org/t/report-not-formatting-properly-in-version-3/720)
**Author:** [@RMittelman](https://www.five.org/u/RMittelman)\ **Replies:** 2\ **Last updated:** [September 20, 2026, 8:49pm UTC](https://www.five.org/t/report-not-formatting-properly-in-version-3/720 "2026-09-20T20:49:12Z")
I have a report called GroupSchedule: When I run it on client, it does this: Note the report now goes to a new page when it didn’t do this before. Otherwise, it is fine. When I run it through the emailing system, … --- ## [Need to Automate Exporting Table or Query to Excel or CSV](https://www.five.org/t/need-to-automate-exporting-table-or-query-to-excel-or-csv/635)
**Author:** [@RMittelman](https://www.five.org/u/RMittelman)\ **Replies:** 13\ **Last updated:** [September 16, 2026, 5:18am UTC](https://www.five.org/t/need-to-automate-exporting-table-or-query-to-excel-or-csv/635 "2026-09-16T05:18:21Z")
I’ve perused the documentation, looking for how to export a table or query result to Excel or CSV file. I found how to do this manually by using the Export button. Now I need to do this programatically from a menu item … --- ## [Import Data from Another Application](https://www.five.org/t/import-data-from-another-application/644)
**Author:** [@RMittelman](https://www.five.org/u/RMittelman)\ **Replies:** 22\ **Last updated:** [September 15, 2026, 1:45am UTC](https://www.five.org/t/import-data-from-another-application/644 "2026-09-15T01:45:53Z")
This is a request for advice rather than a technical question. I have a working Access application, and am in the process of developing this in Five. I already have all required tables, but when it comes time to import … --- ## [Problem Returning to Form After Adding Record](https://www.five.org/t/problem-returning-to-form-after-adding-record/561)
**Author:** [@RMittelman](https://www.five.org/u/RMittelman)\ **Replies:** 15\ **Last updated:** [September 15, 2026, 1:35am UTC](https://www.five.org/t/problem-returning-to-form-after-adding-record/561 "2026-09-15T01:35:26Z")
My StudyGroups form has a page for Members in the group, powered by a DataView. I can click the AddMember action button to add a new member to the list of members in the group. This runs the AddGroupMember function: fun… --- ## [Page type Grid : Show Deleted checkbox raises an error if Versioning is disabled](https://www.five.org/t/page-type-grid-show-deleted-checkbox-raises-an-error-if-versioning-is-disabled/723)
**Author:** [@JeanXXIV](https://www.five.org/u/JeanXXIV)\ **Replies:** 0\ **Last updated:** [September 14, 2026, 1:59pm UTC](https://www.five.org/t/page-type-grid-show-deleted-checkbox-raises-an-error-if-versioning-is-disabled/723 "2026-09-14T13:59:16Z")
In my application, I disabled the versioning. In the page type grid, there is a checkbox “Show Deleted” that displays deleted records, but in my case, enabling this triggers the following error: Failed to execute query… --- ## [Page type Grid: Dependent field doesn't seem to work](https://www.five.org/t/page-type-grid-dependent-field-doesnt-seem-to-work/722)
**Author:** [@JeanXXIV](https://www.five.org/u/JeanXXIV)\ **Replies:** 0\ **Last updated:** [September 14, 2026, 1:39pm UTC](https://www.five.org/t/page-type-grid-dependent-field-doesnt-seem-to-work/722 "2026-09-14T13:39:46Z")
Hi all, The new Grid page type is great. It works much better than the previous version. I like the date picker closing at the date selection and the checkbox display (instead of yes/no of the page type List). I think … --- ## [How to set a single record as default value on a lookup query](https://www.five.org/t/how-to-set-a-single-record-as-default-value-on-a-lookup-query/721)
**Author:** [@JeanXXIV](https://www.five.org/u/JeanXXIV)\ **Replies:** 2\ **Last updated:** [September 14, 2026, 1:56am UTC](https://www.five.org/t/how-to-set-a-single-record-as-default-value-on-a-lookup-query/721 "2026-09-14T01:56:04Z")
Hello, On a form field, when using a \_LookupQuery with a query as a datasource, I noticed that when the result of the query is a single record, this record appears as the default value in the field. This is very practic… --- ## [CSV export outputs \[object Object\] for Data View fields with "On Click" events](https://www.five.org/t/csv-export-outputs-object-object-for-data-view-fields-with-on-click-events/712)
**Author:** [@JeanXXIV](https://www.five.org/u/JeanXXIV)\ **Replies:** 3\ **Last updated:** [September 14, 2026, 1:53am UTC](https://www.five.org/t/csv-export-outputs-object-object-for-data-view-fields-with-on-click-events/712 "2026-09-14T01:53:07Z")
Hello, (Version 3.0.555) A small problem here: the CSV file created from a Data View displays \[object Object\] instead of the value of a field associated with an “On Click” event. Is it possible to fix this on a futu… --- ## [The date value (Display Type \_Date) in a form is not synchronized with the date displayed on a List page](https://www.five.org/t/the-date-value-display-type-date-in-a-form-is-not-synchronized-with-the-date-displayed-on-a-list-page/717)
**Author:** [@JeanXXIV](https://www.five.org/u/JeanXXIV)\ **Replies:** 7\ **Last updated:** [September 14, 2026, 1:29am UTC](https://www.five.org/t/the-date-value-display-type-date-in-a-form-is-not-synchronized-with-the-date-displayed-on-a-list-page/717 "2026-09-14T01:29:07Z")
Hello, I have a form with a date of Display Type \_Date. This form is used as a page of type List inside a parent form. When I enter the date in the form, there is no problem, but the date displayed in the list is off b… --- ## [PDF Report display issue on Apple devices](https://www.five.org/t/pdf-report-display-issue-on-apple-devices/553)
**Author:** [@JeanXXIV](https://www.five.org/u/JeanXXIV)\ **Replies:** 8\ **Last updated:** [September 14, 2026, 12:43am UTC](https://www.five.org/t/pdf-report-display-issue-on-apple-devices/553 "2026-09-14T00:43:14Z")
Hello Five team, I have a problem with reports on macOS (Macbook) and iOS( Ipad, Iphone). When I display the report inside my Five application, I don’t have any PDF toolbar in order to save/print etc. Also, strangely, t… --- ## [Unable to download PDF document after uploading it to the DB](https://www.five.org/t/unable-to-download-pdf-document-after-uploading-it-to-the-db/627)
**Author:** [@JeanXXIV](https://www.five.org/u/JeanXXIV)\ **Replies:** 3\ **Last updated:** [September 12, 2026, 4:41pm UTC](https://www.five.org/t/unable-to-download-pdf-document-after-uploading-it-to-the-db/627 "2026-09-12T16:41:03Z")
Hello, I created a Binary field and \_DocumentUploader component in my form. After uploading a document, I would expect the field to display “Download” as explained in https://www.youtube.com/watch?v=pImWgiprY8c but… --- ## [Cannot create a Dependent Field with a Lookup on Dependent Tables](https://www.five.org/t/cannot-create-a-dependent-field-with-a-lookup-on-dependent-tables/617)
**Author:** [@JeanXXIV](https://www.five.org/u/JeanXXIV)\ **Replies:** 21\ **Last updated:** [September 10, 2026, 9:54pm UTC](https://www.five.org/t/cannot-create-a-dependent-field-with-a-lookup-on-dependent-tables/617 "2026-09-10T21:54:41Z")
Hello everyone! I have an issue described in the title. In a simple scenario, I am able to create a dependent field with a lookup as shown in this first schema. When I create or edit a new Task, the lookup list of the … --- ## [Auto-close Date Picker on selection](https://www.five.org/t/auto-close-date-picker-on-selection/718)
**Author:** [@JeanXXIV](https://www.five.org/u/JeanXXIV)\ **Replies:** 1\ **Last updated:** [September 8, 2026, 2:37am UTC](https://www.five.org/t/auto-close-date-picker-on-selection/718 "2026-09-08T02:37:07Z")
Most of the date pickers I encounter on apps and on the web close as soon as a date is selected in the calendar. Currently, the date picker in Five requires clicking an ‘OK’ button. It would be much more practical for u… --- ## [Questions regarding creating url in my application (quite urgent, please help)](https://www.five.org/t/questions-regarding-creating-url-in-my-application-quite-urgent-please-help/715)
**Author:** [@kaila](https://www.five.org/u/kaila)\ **Replies:** 1\ **Last updated:** [September 6, 2026, 11:30pm UTC](https://www.five.org/t/questions-regarding-creating-url-in-my-application-quite-urgent-please-help/715 "2026-09-06T23:30:10Z")
As I know, in setup, there should be a button for adding url in SetUp, I tried to scroll it but there is still no button for adding url. Is it because of my account is using free trial? Is there a way for me to add ur… --- ## [No option to add URL](https://www.five.org/t/no-option-to-add-url/475)
**Author:** [@nate\_convex](https://www.five.org/u/nate_convex)\ **Replies:** 3\ **Last updated:** [September 6, 2026, 8:53pm UTC](https://www.five.org/t/no-option-to-add-url/475 "2026-09-06T20:53:40Z")
I’d like to add a URL to my application for public access to a form. But the URLs option is missing from my Setup menu. Is this a limitation of my license? --- ## [Lookup Field in DataView](https://www.five.org/t/lookup-field-in-dataview/642)
**Author:** [@RMittelman](https://www.five.org/u/RMittelman)\ **Replies:** 11\ **Last updated:** [September 2, 2026, 8:56pm UTC](https://www.five.org/t/lookup-field-in-dataview/642 "2026-09-02T20:56:42Z")
I use DataViews extensively in my forms. In the Generate Emails form, there is a page with a dataview to select members. entries look like: Adams, John Blow, Joe Mittelman, Ron ... Is it possible to have a search bar a… --- ## [Big Problem with Libraries tab](https://www.five.org/t/big-problem-with-libraries-tab/648)
**Author:** [@RMittelman](https://www.five.org/u/RMittelman)\ **Replies:** 3\ **Last updated:** [September 2, 2026, 1:48am UTC](https://www.five.org/t/big-problem-with-libraries-tab/648 "2026-09-02T01:48:05Z")
There is an issue with the Libraries tab as displayed by my function. here is a screen shot: If I enter full-screen mode, I can see one extra library name, but still not all of them. This form desperately needs a ver… --- ## [Report Names Generated on Server Issue](https://www.five.org/t/report-names-generated-on-server-issue/625)
**Author:** [@RMittelman](https://www.five.org/u/RMittelman)\ **Replies:** 5\ **Last updated:** [September 2, 2026, 1:46am UTC](https://www.five.org/t/report-names-generated-on-server-issue/625 "2026-09-02T01:46:38Z")
I’m having an issue with returning the reportResult object from server and interpreting its name. I generated 2 different reports and had them emailed to myself. The attachment names were Roster\_4145ae112a1aaa67fda89c1e7… --- ## [Trying to set a Screen Field on a Data View from an async function](https://www.five.org/t/trying-to-set-a-screen-field-on-a-data-view-from-an-async-function/654)
**Author:** [@JeanXXIV](https://www.five.org/u/JeanXXIV)\ **Replies:** 7\ **Last updated:** [September 1, 2026, 9:06pm UTC](https://www.five.org/t/trying-to-set-a-screen-field-on-a-data-view-from-an-async-function/654 "2026-09-01T21:06:50Z")
Hello! I am trying to set a Screen Field named ‘Total’ on a Data View using data returned from a server-side function, but without success. It seems that updating a Screen Field on a Data View from an asynchronous call… --- ## [Exposure issue when opening a form from a Data View](https://www.five.org/t/exposure-issue-when-opening-a-form-from-a-data-view/638)
**Author:** [@JeanXXIV](https://www.five.org/u/JeanXXIV)\ **Replies:** 6\ **Last updated:** [August 29, 2026, 3:47am UTC](https://www.five.org/t/exposure-issue-when-opening-a-form-from-a-data-view/638 "2026-08-29T03:47:55Z")
Hello. I am experiencing a data exposure issue when opening a form from a Data View. Here is my case: I have a Data View based on a query that filters records belonging to the user. The first field is a button that op… --- ## [Possible bug in five.addAttachment() with XLSX attachments](https://www.five.org/t/possible-bug-in-five-addattachment-with-xlsx-attachments/652)
**Author:** [@JeanXXIV](https://www.five.org/u/JeanXXIV)\ **Replies:** 5\ **Last updated:** [August 29, 2026, 2:53am UTC](https://www.five.org/t/possible-bug-in-five-addattachment-with-xlsx-attachments/652 "2026-08-29T02:53:56Z")
Hi Five team, I believe I may have found a bug in five.addAttachment() when attaching an XLSX file as a Base64 Data URI. Issue summary When using: five.addAttachment(fileData, fileName); with: a valid XLSX Base64 D… --- ## [Email "no-reply" address](https://www.five.org/t/email-no-reply-address/641)
**Author:** [@JeanXXIV](https://www.five.org/u/JeanXXIV)\ **Replies:** 4\ **Last updated:** [August 27, 2026, 1:51am UTC](https://www.five.org/t/email-no-reply-address/641 "2026-08-27T01:51:33Z")
Hi Five Team, In my application, users send emails (Mail Merges) using my own SMTP server. I configure the context in a JavaScript function like this: const messageContext = {}; messageContext.SMTPSubject = courrielDa… --- ## [Cannot display the field value on a button in a Data View in version 3.0](https://www.five.org/t/cannot-display-the-field-value-on-a-button-in-a-data-view-in-version-3-0/693)
**Author:** [@JeanXXIV](https://www.five.org/u/JeanXXIV)\ **Replies:** 5\ **Last updated:** [August 27, 2026, 1:09am UTC](https://www.five.org/t/cannot-display-the-field-value-on-a-button-in-a-data-view-in-version-3-0/693 "2026-08-27T01:09:21Z")
Hello! I appreciate that in version 3.0 it is now possible to sort a Data View by a column containing a button. Version 2.9 didn’t allow sorting on these columns. However, I am facing an issue. When I create a new fiel… --- ## [Dependent field missing in subform view](https://www.five.org/t/dependent-field-missing-in-subform-view/698)
**Author:** [@JeanXXIV](https://www.five.org/u/JeanXXIV)\ **Replies:** 4\ **Last updated:** [August 27, 2026, 12:21am UTC](https://www.five.org/t/dependent-field-missing-in-subform-view/698 "2026-08-27T00:21:40Z")
Hello everyone, I encountered an issue in my app that I can easily reproduce in a small sample application running on version 3.0. Everything works and renders correctly in my production environment, which is currently… --- ## [How to refresh the record list after a "soft delete"?](https://www.five.org/t/how-to-refresh-the-record-list-after-a-soft-delete/640)
**Author:** [@JeanXXIV](https://www.five.org/u/JeanXXIV)\ **Replies:** 4\ **Last updated:** [August 26, 2026, 2:28pm UTC](https://www.five.org/t/how-to-refresh-the-record-list-after-a-soft-delete/640 "2026-08-26T14:28:08Z")
Hello, I have implemented a “soft delete” functionality by adding a IsDeleted field to my table. In y form, I added a condition to the Data Filter to only show records where ‘IsDeleted = 0’. I created a custom button t… --- ## [Foreign Key creation fails with Error 1170 (Identifier type created as TEXT in MySQL)](https://www.five.org/t/foreign-key-creation-fails-with-error-1170-identifier-type-created-as-text-in-mysql/649)
**Author:** [@JeanXXIV](https://www.five.org/u/JeanXXIV)\ **Replies:** 7\ **Last updated:** [August 26, 2026, 1:35pm UTC](https://www.five.org/t/foreign-key-creation-fails-with-error-1170-identifier-type-created-as-text-in-mysql/649 "2026-08-26T13:35:33Z")
Hello, I have a table ‘Province’ with a field named ‘IsoCode’ which is the primary key of data type ‘Identifier’ (Size = 2). I have another table ‘City’ with the field ‘ProvinceIsoCode’ of data type ‘Identifier’ (Si… --- ## [Unexpected empty list when switching between filtered menus](https://www.five.org/t/unexpected-empty-list-when-switching-between-filtered-menus/645)
**Author:** [@JeanXXIV](https://www.five.org/u/JeanXXIV)\ **Replies:** 4\ **Last updated:** [August 26, 2026, 12:59pm UTC](https://www.five.org/t/unexpected-empty-list-when-switching-between-filtered-menus/645 "2026-08-26T12:59:59Z")
Hello all, I am experiencing an issue where a list appears empty when switching from one filtered menu to another. I have attached a sample FDF demonstrating the problem. I have a table ‘Plant’ with two fields: Field … --- ## [Can the horizontal scrollbar be always visible in the Query View?](https://www.five.org/t/can-the-horizontal-scrollbar-be-always-visible-in-the-query-view/614)
**Author:** [@JeanXXIV](https://www.five.org/u/JeanXXIV)\ **Replies:** 3\ **Last updated:** [August 26, 2026, 1:47am UTC](https://www.five.org/t/can-the-horizontal-scrollbar-be-always-visible-in-the-query-view/614 "2026-08-26T01:47:05Z")
Hi everyone, Looks like I am the first to post in this section :slight\_smile: In the Query View, the horizontal scrollbar only appears when you scroll all the way down to the bottom of the data. This makes it difficult… [Next page](https://www.five.org/latest.md?page=1)