Thu, 24 Sep 2026
Login

Can we configure a form to store fields in a non-string data type?

Confluence User - 17 May, 2023

Casting strings to numbers can impact performance when there is a large amount of data in the table. So I want to can I store form (app_fd_*) in a int8 type? 

forms;datatype;store

2

Confluence User •
17 May, 2023 •
confluenceUser •
•
confluenceUser •

So far it doesn't seem possible.

Confluence User •
18 May, 2023 •
confluenceUser •
•
confluenceUser •

Hi, you can try changing the table column type directly in the database. You would need to ensure that the value type in your form is correct, for example by adding appropriate validation.

1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Retrieve image upload from form into PDF
Error storing data
How to generate unique ID using Textfield?
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print