1
0
-1

Hi

I am migrating an older application to Joget. I am extracting the data from the old application in the form of SQL statements. I can run the statements in Joget DB and recreate the database.

Is it possible to automatically create a form from a table?

I have a lot of tables in the old system and many have 50+ columns. It would be a lot of work to create forms first, let Joget create the tables/columns and then populate the tables. Many of the fields will never need to show up on a form but I need the data in the database.

If this cannot be done automatically, can I first create the table and columns in the database and then create the form, selectively adding the fields I need?

Can we have a Joget app without any forms (all CRUD done via APIs)?

    CommentAdd your comment...

    2 answers

    1.  
      1
      0
      -1

      To all looking for such a feature (e.g., when migrating to Joget from another application) this will be very helpful

      Create Form From Existing Custom Table - Knowledge Base for DX 7 - Joget | COMMUNITY

      Thank you

        CommentAdd your comment...
      1.  
        1
        0
        -1

        I do not think you can create forms automatically.

        you have 2 options. 1 is to create forms and add tables in the database using forms. Although the tables will have a prefix "app_fd_" if you create using joget forms.

        2nd option would be, if you want to use database tables that were not created using joget, you might have to use JDBC load and store binders to access those tables and then you can manually chose selective fields you want on the form. I wouldn't recommend it but maybe you could try it.


          CommentAdd your comment...