Steps to create an App

  • Resolved HKCCCC IT

    (@hkcccc)


    3 months, 1 week ago

    I am studying the App Builder, it seems cannot create database tables. In the Explorer it can only create table design, not the actual table. Is this the proper steps to create an app?

    1. In Explorer [Create table design]
    2. goto [Designer], select the design and create a table.
    3. Goto App builder, select [data administration] and the newly created table

    But in the data designer it said “This tool will be replaced by the new App Builder. Please migrate before summer 2025.” What should I do?

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    Hi @hkcccc,

    Thanks for the post!

    You did everything correctly! For the note about Data Designer being replaced, I’ll have to check on Peter when he’ll add that function to the App Builder. I’ll let you know once I receive a response. ??

    For now, the legacy tools are still good to use. ??

    Let us know if you have other questions!

    Thread Starter HKCCCC IT

    (@hkcccc)

    Thank you.

    In [Data Designer] when I add new design, the column type can choose varchar. But after save it all changes to text and there is no varchar options. Please advice.

    Plugin Contributor Kim L

    (@kimmyx)

    Hi @hkcccc,

    Thanks for the response.

    Could you send us a screenshot of the Data Designer page? We just tested creating a new table and it all went OK for us.

    You can also send us a message via Contact | WP Data Access if you want to send us more information about the issue you’re seeing privately.

    We’ll wait for your email! ??

    Thread Starter HKCCCC IT

    (@hkcccc)

    There is no varchar in column type.

    Plugin Contributor Kim L

    (@kimmyx)

    Hi @hkcccc,

    Are you on the latest version of WP Data Access?

    Varchar should be available on the list of column types.

    See here: https://share.zight.com/JruZzdW2

    Can you try re-installing and let us know if that helps?

    Thread Starter HKCCCC IT

    (@hkcccc)

    I am using 5.5.11 Premium lifetime edition.

    I deleted the table, re-created a new design and it worked!

    Thanks a lot.

    Thread Starter HKCCCC IT

    (@hkcccc)

    I am building up an app to join 2 tables in a many to many relationship:

    1. Contact – Master table of personnel (ID, Name, Tel, etc.)
    2. Position – Master table of company position (ID, Position, Department, Rank, etc.)
    3. Duty – relation table with start/end date to join Contact.ID and Position.ID

    After I created Contact and Positon, how to set up the Duty table?

    Plugin Contributor Kim L

    (@kimmyx)

    Hi @hkcccc,

    I deleted the table, re-created a new design and it worked!

    We’re glad that’s fixed! ??

    I am building up an app to join 2 tables in a many to many relationship: After I created Contact and Positon, how to set up the Duty table?

    You have to create the Duty table too, either via Designer or run the query via SQL Query Builder.

    You can find more information about setting up Relationships in the App Builder here: Relationships | WP Data Access

    Hope that helps! Let us know if you have other questions.

Viewing 8 replies - 1 through 8 (of 8 total)
  • You must be logged in to reply to this topic.