Share My Creation EasyCode - Form/B4XTable Generator with no writting code [B4A] [B4J]

Well, I ve decided to create a Form-View Generator (B4J - B4A)... that creates Forms with B4XTable + with no writing code at all...
The Designer is in B4J (like FormBuilder), the produced code/files working at B4A too !!!

Well.. after one month of programming...
I want to share / sell my Form-View Generator...

Donation at least...
Pre purchase price: 19€ (for 2 weeks only - until 10th March 2022 - you will receive email/pm at 11 March 2022)
Normal Price: 39€



Thanks in advance for supporting !
ps: 20% of any purchase will go to B4X... (every Friday.. will make transfer - donate B4X)


- It uses SQLite, easily can change at any SQL Database (mysql, mssql... etc)
- You can select table... columns/fields.. change them order... delete from view (not from sql table)
- When columns/fields automatically inserted at the listview for ordering - automatically changes type (when double -> 0.00, when int just 0/number, date->text center..)
- You can change width, columns captions, type/formatting fast...
- First column is always the key for "SELECT .. from table where ..."
- With Saving View - automatically generate the view and also creates .json file editable with Erel's FormBuilder (adding extra key for formatting numbers too)
- When opening first time select the database and working folder... creates ini for not asking everytime the same (if you are using it for projects is useful)
- Also includes a way creating html files (when selecting print button at the result-form-view)... that are printable... and beautiful viewing too..
- All the buttons at the result-form-view are working search, show all, edit, delete, print, add new.. using b4xdialog, preferencesdialog with auto generated files...
- For the result-form using SwiftButtons - XUI Views... and B4X Controls... so will be very easy to run at B4A...
- Tip: if a Column in Database is required... then automatically at the generated .json (Formbuilder) readable from preferencesdialog - required too...

What do you think ?

Check here - how Form View Generator works...

Test App in Android:


What you will get ?

• Form-View Generator (source code for B4J)
• Form-View Generator (executable)
• EasyViewTable.bas (that works at B4J, B4A.. didn’t tried at B4I)
• Various Open Source CMD Line utilities, including mine PrintHtml (a simple source code in VB6) + executable…
• Full B4XPages Example for including EasyViewTable Generated Forms, .json, html printing (B4J, B4A)
• Documentation, etc

What I except from you?

• Check for bugs (and inform me in B4X forum, caution! without posting the whole code-but small parts) – Post with this form at B4A Questions or B4J Questions sample title of thread ex: Problem reading .view file [B4X/EasyCode], so it will possible check it as soon as possible or other users could answer it.
• If you found something will make it faster, better and you write some code – will be good to be shared with me.
  Credits + Donation will come from all ! Be sure !
• If you have any idea for EasyCode – that will help all the community – share it…
  Will make it better !
• Post Screenshots of you apps and your layouts (you can share them too).
• Do not change the code and re-sell it. Be nice guy! Caution !

What’s my target-scope ?

Make the life of B4X Developer easier… and create many tools that will automate the creation of code, business apps like CRUD, POS etc… more coming…

 

[Magma]

...You can check here a Tutorial made + you can download an apk example to check how it works !

 

[Magma]

A new update that works at B4A too.. PicturePath

Check here..

 

[JakeBullet70]

Is this code still active? Being worked on?

 

[Magma]

Is this code still active? Being worked on?

Yes.. ofcourse... how can I help you?

..last weeks, had many custom works to do... so not posting ?

 

[Magma]

Is this code still active? Being worked on?

Here you can find new features..

EasyCode - Form/B4XTable Generator with no writting code [B4J] [B4A]

Well, I ve decided to create a Form-View Generator (B4J - B4A)... that creates Forms with B4XTable + with no writing code at all... The Designer is in B4J code, the produced code/files working at B4A too !!! - It uses SQLite, easily can change at any SQL Database (mysql, mssql... etc) - You...

www.b4x.com

 

[JakeBullet70]

Sorry, my interbne

Yes.. ofcourse... how can I help you?

Sorry, my internet access is limited at the moment, if not non existent. I cannot watch ANY video at all.

Is there support for primary - foreign key lookups.

So say I have a table - Users
Fields (user_id, name, address, phone, users_type_id)

Another related table - UserTypes
Fields (user_type_id, user_type_description, user_access_rights)

Will the generated form show the related information ? PK -> FK?
So the User table shows --- not Users.users_type_id BUT UserTypes.user_type_description

Hope I asked the question right.
Thinking of a very large project in a few months I hope this can help with it.

 

[Magma]

Sorry, my interbne


Sorry, my internet access is limited at the moment, if not non existent. I cannot watch ANY video at all.

Is there support for primary - foreign key lookups.

So say I have a table - Users
Fields (user_id, name, address, phone, users_type_id)

Another related table - UserTypes
Fields (user_type_id, user_type_description, user_access_rights)

Will the generated form show the related information ? PK -> FK?
So the User table shows --- not Users.users_type_id BUT UserTypes.user_type_description

Hope I asked the question right.
Thinking of a very large project in a few months I hope this can help with it.

That is a "good" question... well... my App it isn't a db creator... but is a "helper" to use with DBs... for example SQLite DB's (created for them... easily can change at mariadb,mssql ..etc)...

So if you have sometime good internet-connection - i will suggest you to see Tutorial at ~3:12 (mm:SS)... in this point I give the option to create combo and load all the possible values of combo from a different table (but caution... getting one column)...

As I know SQLite isn;t good for nothing more than "storaging"... but yes... is doing the job for big apps too...

Your question is more DataBase or ACCESS like... it could be a future feature for the APP... but is something will need time... from the other hand do not forget that you will get the full source and if you have knowledge at DBs and b4x will be easy (except the time need) to upgrade it... and SHARE it with us

 

[Mashiane]

(but caution... getting one column)...

Aha! Remember I also noted this. You really need to relook at this, its a very crucial thing. In most cases when loading combos, one uses a key value pair.

All the best!

 

[Mashiane]

one uses a key value pair.

The limitation it seems is in the code of the preference dialog as it accepts a list for preferences and not a map.

Perhaps a solution would be an extra map being created as a cross reference even outside of the lib itself.

For example assuming that the ShortOptions / Options are Array("B4x", "is", "Cool") then the map will store CreateMap("B4x":"1", "is":"2","Cool":"3"), so that when a person has chosen "B4x", you read "1" and assign it back and when reading, read from the related map to assign "B4x".

 

[Magma]

The limitation it seems is in the code of the preference dialog as it accepts a list for preferences and not a map.

Perhaps a solution would be an extra map being created as a cross reference even outside of the lib itself.

For example assuming that the ShortOptions / Options are Array("B4x", "is", "Cool") then the map will store CreateMap("B4x":"1", "is":"2","Cool":"3"), so that when a person has chosen "B4x", you read "1" and assign it back and when reading, read from the related map to assign "B4x".

It can handled differently... already thought it.. but at the moment had something different to end.

 

[73Challenger]

Is this code still active? Being worked on?

Hey @JakeBullet70 - When you start working on this..... if you'd like a "helper" let me know. I have a feeling I might learn some good stuff from you I've also got a raspberry pi that we could run a "host" on if needed.