# \#how-to **URL:** https://www.five.org/tag/how-to/6.md [Latest](https://www.five.org/latest.md) · [Categories](https://www.five.org/categories.md) · [Tags](https://www.five.org/tags.md) --- ## [QuickBooks Integrations from Five?](https://www.five.org/t/quickbooks-integrations-from-five/400)
**Author:** [@RMittelman](https://www.five.org/u/RMittelman)\ **Replies:** 6\ **Last updated:** [July 28, 2025, 3:46am UTC](https://www.five.org/t/quickbooks-integrations-from-five/400 "2025-07-28T03:46:21Z")
Do you have any examples of using Five to post entries to QuickBooks Web version using their API’s? Thanks… --- ## [Need OpenAI key so JavaScript can be analyzed](https://www.five.org/t/need-openai-key-so-javascript-can-be-analyzed/363)
**Author:** [@RMittelman](https://www.five.org/u/RMittelman)\ **Replies:** 7\ **Last updated:** [March 25, 2025, 4:32am UTC](https://www.five.org/t/need-openai-key-so-javascript-can-be-analyzed/363 "2025-03-25T04:32:44Z")
Hi, New Five user. I’m building an app which has some JavaScript code. In the code window, when I click the “Check for Errors” button it says “OPENAI-KEY missing from your configuration”. I am using the free version … --- ## [Can I create a visual divider in forms? & Pre-question text (non-field) & Others](https://www.five.org/t/can-i-create-a-visual-divider-in-forms-pre-question-text-non-field-others/507)
**Author:** [@chef](https://www.five.org/u/chef)\ **Replies:** 5\ **Last updated:** [February 26, 2025, 1:59am UTC](https://www.five.org/t/can-i-create-a-visual-divider-in-forms-pre-question-text-non-field-others/507 "2025-02-26T01:59:49Z")
Hey, I want to enter some visual dividers in my form. For example, if one section asks about personal life, and the second part asks about work, I’d like to have some sort of horizontal line, to indicate to the user th… --- ## [Filter by user to account to table](https://www.five.org/t/filter-by-user-to-account-to-table/466)
**Author:** [@z3ror00](https://www.five.org/u/z3ror00)\ **Replies:** 5\ **Last updated:** [December 9, 2024, 9:24pm UTC](https://www.five.org/t/filter-by-user-to-account-to-table/466 "2024-12-09T21:24:59Z")
I have a list with an account table lookup. The account is related to a logged in user through a bridge table, IUserAccount. How do I filter a table for an account field they are connected to and hide the others? --- ## [New Record Doesn't Appear In the List When Created](https://www.five.org/t/new-record-doesnt-appear-in-the-list-when-created/468)
**Author:** [@vladt](https://www.five.org/u/vladt)\ **Replies:** 4\ **Last updated:** [November 12, 2024, 6:25am UTC](https://www.five.org/t/new-record-doesnt-appear-in-the-list-when-created/468 "2024-11-12T06:25:54Z")
Hello Five Support Team, In my application, I’m experiencing the following glitch: When I create a new Payment record, it is created fine, but the Payment Name does not appear in the list on the left (it shows up blank… --- ## [How to Make a Landing Page Responsive?](https://www.five.org/t/how-to-make-a-landing-page-responsive/464)
**Author:** [@vladt](https://www.five.org/u/vladt)\ **Replies:** 6\ **Last updated:** [September 24, 2024, 5:05am UTC](https://www.five.org/t/how-to-make-a-landing-page-responsive/464 "2024-09-24T05:05:36Z")
Hello Five Support Team, I made a landing page that consists only of one image. Please tell me how to make the landing page responsive. Currently, when the application window is not in full-screen mode, the image only … --- ## [My Application STOPPED Working After Setting It to Multi-user!](https://www.five.org/t/my-application-stopped-working-after-setting-it-to-multi-user/457)
**Author:** [@vladt](https://www.five.org/u/vladt)\ **Replies:** 2\ **Last updated:** [September 11, 2024, 5:56pm UTC](https://www.five.org/t/my-application-stopped-working-after-setting-it-to-multi-user/457 "2024-09-11T17:56:37Z")
Hello Five Support Team, After setting a perfectly functioning application to multi-user, two crucial application Forms stopped working! They now return the error (see screenshot below) once you click any list item on … --- ## [REPORTS - Creation and Formatting Questions](https://www.five.org/t/reports-creation-and-formatting-questions/455)
**Author:** [@vladt](https://www.five.org/u/vladt)\ **Replies:** 3\ **Last updated:** [September 9, 2024, 12:07am UTC](https://www.five.org/t/reports-creation-and-formatting-questions/455 "2024-09-09T00:07:13Z")
Hello Support Team, While working on reports, I’ve got the following questions: Is it possible to create a report based on a parameter query? For example, I’m building a Sales Rep Performance Report, which shows the … --- ## [How to Create a User Portal?](https://www.five.org/t/how-to-create-a-user-portal/456)
**Author:** [@vladt](https://www.five.org/u/vladt)\ **Replies:** 4\ **Last updated:** [September 5, 2024, 11:21pm UTC](https://www.five.org/t/how-to-create-a-user-portal/456 "2024-09-05T23:21:55Z")
Hello Five Support Team, I’m building a sales commission tracking application. The application is almost complete on the Standalone (locally installed) version of the Five platform. The application’s logic is as follow… --- ## [Create Data View from a query with a parameter](https://www.five.org/t/create-data-view-from-a-query-with-a-parameter/440)
**Author:** [@vladt](https://www.five.org/u/vladt)\ **Replies:** 14\ **Last updated:** [September 3, 2024, 10:12pm UTC](https://www.five.org/t/create-data-view-from-a-query-with-a-parameter/440 "2024-09-03T22:12:02Z")
Hello FIVE team, Please explain how to create a Data View that is sourced from a query with a parameter that has to be selected in a drop-down list on this Data View. My query (DealsAndCommissionsPerUserQuery): SELECT … --- ## [Attaching database to backend code](https://www.five.org/t/attaching-database-to-backend-code/449)
**Author:** [@rainbowkrampus](https://www.five.org/u/rainbowkrampus)\ **Replies:** 1\ **Last updated:** [August 18, 2024, 10:02pm UTC](https://www.five.org/t/attaching-database-to-backend-code/449 "2024-08-18T22:02:49Z")
I’m working on a project and I’m trying to connect it to my database on Five.co. I’m a bit stuck and could use some help on how to connect it. --- ## [Is There a Way to Add Space Between Dashboard Elements?](https://www.five.org/t/is-there-a-way-to-add-space-between-dashboard-elements/447)
**Author:** [@vladt](https://www.five.org/u/vladt)\ **Replies:** 4\ **Last updated:** [August 15, 2024, 1:13am UTC](https://www.five.org/t/is-there-a-way-to-add-space-between-dashboard-elements/447 "2024-08-15T01:13:47Z")
Hello Support, I’ve been working on dashboards, and I came to the strong belief that all applications built on Five would greatly benefit if there were the ability to add space (padding or margins) between the elements … --- ## [How on a Form to Do Calculations Involving Fields from Multiple Related Tables?](https://www.five.org/t/how-on-a-form-to-do-calculations-involving-fields-from-multiple-related-tables/435)
**Author:** [@vladt](https://www.five.org/u/vladt)\ **Replies:** 6\ **Last updated:** [August 1, 2024, 3:52am UTC](https://www.five.org/t/how-on-a-form-to-do-calculations-involving-fields-from-multiple-related-tables/435 "2024-08-01T03:52:16Z")
Hello Support, I have two related tables – Table A and Table B. Table A has two fields – Field 1 and Field 2. Table B also has two fields – Field 10 and Field 20. I have a Form sourced from Table A. The Field 2 field… --- ## [Unable to Create / Update Concatenated Field in Table through Form!](https://www.five.org/t/unable-to-create-update-concatenated-field-in-table-through-form/433)
**Author:** [@vladt](https://www.five.org/u/vladt)\ **Replies:** 1\ **Last updated:** [July 28, 2024, 10:56pm UTC](https://www.five.org/t/unable-to-create-update-concatenated-field-in-table-through-form/433 "2024-07-28T22:56:28Z")
Hello Support, I’ve been struggling to create / update a concatenated field (named “DealName”) in the table of my database from the form (named “Deals”) based on selections on other fields on the same form. (Database ta… --- ## [Display Map on Form using Google Map API](https://www.five.org/t/display-map-on-form-using-google-map-api/384)
**Author:** [@RMittelman](https://www.five.org/u/RMittelman)\ **Replies:** 23\ **Last updated:** [April 4, 2024, 1:48am UTC](https://www.five.org/t/display-map-on-form-using-google-map-api/384 "2024-04-04T01:48:16Z")
Is there a way, given a street address, to generate a map. I have a license key for Google Maps API. I’m using this in my MS Access application to display a map on my Members form by making a REST call to Google Maps. … --- ## [Add Choice To Form Field](https://www.five.org/t/add-choice-to-form-field/399)
**Author:** [@RMittelman](https://www.five.org/u/RMittelman)\ **Replies:** 3\ **Last updated:** [March 30, 2024, 3:50am UTC](https://www.five.org/t/add-choice-to-form-field/399 "2024-03-30T03:50:37Z")
I have a table for BoardPositions in my application. Our organization has 2 co-presidents. Positions are overseen by one co-president or the other (or none). My table and form have an “OverseenBy” field. I made the f… --- ## [Adding Form Page for Join Table](https://www.five.org/t/adding-form-page-for-join-table/372)
**Author:** [@RMittelman](https://www.five.org/u/RMittelman)\ **Replies:** 15\ **Last updated:** [March 17, 2024, 10:37pm UTC](https://www.five.org/t/adding-form-page-for-join-table/372 "2024-03-17T22:37:01Z")
My membership application has tables for Members, StudyGroups and a GroupMembers join table containing MembersKey and StudyGroupsKey, plus some other fields. I read an article on adding form pages, and was happy to see … --- ## [Default Date Value Not working](https://www.five.org/t/default-date-value-not-working/373)
**Author:** [@RMittelman](https://www.five.org/u/RMittelman)\ **Replies:** 1\ **Last updated:** [March 6, 2024, 11:12pm UTC](https://www.five.org/t/default-date-value-not-working/373 "2024-03-06T23:12:24Z")
I’m trying to populate a DateAdded field to my Members table. Firstly, it’s confusing that there is a default value in the table and on the form. Not clear if I need to put the default value in both places or not. Sec… --- ## [Trouble with Entering Data into Table](https://www.five.org/t/trouble-with-entering-data-into-table/367)
**Author:** [@RMittelman](https://www.five.org/u/RMittelman)\ **Replies:** 9\ **Last updated:** [March 6, 2024, 5:48am UTC](https://www.five.org/t/trouble-with-entering-data-into-table/367 "2024-03-06T05:48:20Z")
I’m having trouble entering data into my StudyGroups table. The fields where I have defined custom display types seem to work fine. I click the drop-down next to the field name, and it shows a list of items to choose f… --- ## [Field Types in Table](https://www.five.org/t/field-types-in-table/362)
**Author:** [@RMittelman](https://www.five.org/u/RMittelman)\ **Replies:** 4\ **Last updated:** [March 6, 2024, 5:38am UTC](https://www.five.org/t/field-types-in-table/362 "2024-03-06T05:38:54Z")
Hi, brand new to Five. Trying to create my first application. For this question, I’m creating a Members table. Sometimes I need a short list of choices for a field. For example, Gender. Only “m” and “f” are pertinent… --- ## [Adding Records into Database](https://www.five.org/t/adding-records-into-database/368)
**Author:** [@RMittelman](https://www.five.org/u/RMittelman)\ **Replies:** 9\ **Last updated:** [March 6, 2024, 5:29am UTC](https://www.five.org/t/adding-records-into-database/368 "2024-03-06T05:29:11Z")
Noob questions about defining forms and adding records. I have 2 phone number fields, PrimaryPhone and SecondaryPhone. I would like to store them as raw numbers: 8052317500, rather than with parentheses and dashes. I … --- ## [New User Design Questions](https://www.five.org/t/new-user-design-questions/364)
**Author:** [@RMittelman](https://www.five.org/u/RMittelman)\ **Replies:** 3\ **Last updated:** [March 3, 2024, 8:14pm UTC](https://www.five.org/t/new-user-design-questions/364 "2024-03-03T20:14:41Z")
I’m a new user who is trying to learn Five by converting a Microsoft Access application to Five. I have several questions, and am not sure if I should combine them in a single post or have a separate post for each quest… --- ## [Failed to initialize server when Installing](https://www.five.org/t/failed-to-initialize-server-when-installing/236)
**Author:** [@Steven\_schultz](https://www.five.org/u/Steven_schultz)\ **Replies:** 1\ **Last updated:** [June 9, 2023, 6:42pm UTC](https://www.five.org/t/failed-to-initialize-server-when-installing/236 "2023-06-09T18:42:31Z")
2023/06/09 01:06:32 \[2632\]\[WRN\]\[Jun 9 01:06:32\]\[-\]\[1\] Starting as desktop session, single user mode 2023/06/09 01:06:32 astikit: starting worker… 2023/06/09 01:06:32 Resources folder doesn’t exist, restoring resource… --- ## [I can't seems to run two statements](https://www.five.org/t/i-cant-seems-to-run-two-statements/219)
**Author:** [@temitope](https://www.five.org/u/temitope)\ **Replies:** 2\ **Last updated:** [June 7, 2023, 10:44am UTC](https://www.five.org/t/i-cant-seems-to-run-two-statements/219 "2023-06-07T10:44:08Z")
Hi everyone! I am trying to combine the SELECT and UPDATE query but it’s not working. I want to use the SELECT query to retrieve the result and execute the UPDATE query using the retrieved values. When I tried to save i… --- ## [How to create a display type of Markdown?](https://www.five.org/t/how-to-create-a-display-type-of-markdown/200)
**Author:** [@pratik](https://www.five.org/u/pratik)\ **Replies:** 2\ **Last updated:** [June 7, 2023, 5:40am UTC](https://www.five.org/t/how-to-create-a-display-type-of-markdown/200 "2023-06-07T05:40:29Z")
I want to store my blog data in markdown and show it on page in a Markdown Display. How can i do that? --- ## [Can I make API calls to an External API and return results](https://www.five.org/t/can-i-make-api-calls-to-an-external-api-and-return-results/223)
**Author:** [@ayushjain](https://www.five.org/u/ayushjain)\ **Replies:** 1\ **Last updated:** [June 6, 2023, 10:25pm UTC](https://www.five.org/t/can-i-make-api-calls-to-an-external-api-and-return-results/223 "2023-06-06T22:25:55Z")
I want to call an external API and return list of an image/video generated --- ## [How do I let users register/sign up and choose their user role?](https://www.five.org/t/how-do-i-let-users-register-sign-up-and-choose-their-user-role/216)
**Author:** [@Abu\_Bakr\_Siddique](https://www.five.org/u/Abu_Bakr_Siddique)\ **Replies:** 1\ **Last updated:** [June 6, 2023, 9:03am UTC](https://www.five.org/t/how-do-i-let-users-register-sign-up-and-choose-their-user-role/216 "2023-06-06T09:03:44Z")
Hi, I am using the Book Club Application for reference. In the example, the Administrator role is the one who logs in new users into the application. So there is only a Member Role or an Administrator role it seems. I a… --- ## [Authentication Failed](https://www.five.org/t/authentication-failed/199)
**Author:** [@femi](https://www.five.org/u/femi)\ **Replies:** 4\ **Last updated:** [June 3, 2023, 4:00am UTC](https://www.five.org/t/authentication-failed/199 "2023-06-03T04:00:27Z")
Please I keep getting Authentication failures in my Music Club application following the Book Club example. This is happening when I tried to run the MultiUser Application --- ## [Unable to create a Table](https://www.five.org/t/unable-to-create-a-table/184)
**Author:** [@femi](https://www.five.org/u/femi)\ **Replies:** 1\ **Last updated:** [May 28, 2023, 8:20pm UTC](https://www.five.org/t/unable-to-create-a-table/184 "2023-05-28T20:20:31Z")
Each time I tried to create a Table, I ge t this error Failed to execute SQL : Error 1060: Duplicate column name ‘Tableonekey’ System Error : Error 1060: Duplicate column name ‘Tableonekey’ --- ## [Unable to Install Package](https://www.five.org/t/unable-to-install-package/181)
**Author:** [@femi](https://www.five.org/u/femi)\ **Replies:** 1\ **Last updated:** [May 24, 2023, 8:16pm UTC](https://www.five.org/t/unable-to-install-package/181 "2023-05-24T20:16:15Z")
I got the error below when trying to install the pkg but got the error below “FiveDesktop-x86-2.1.pkg” can’t be opened because Apple cannot check it for malicious software. [Next page](https://www.five.org/tag/how-to/6.md?match_all_tags=true&page=1&tags%5B%5D=how-to)