Hi
I am newbi and want a form to enter data directly in table view.
becouse i need to enter data speedly an massly but the defult data entry section is one by one.
is there any soloution?
sorry for my bad english skills!
data entry in table view
Re: data entry in table view
This is a feature already requested by many users in another thread and we plan to implement it in the next release. Stay tuned
AppGini plugins to add more power to your apps:
- DataTalk is an innovative AppGini plugin based on ChatGPT that allows you to interact with your AppGini database using natural language questions, without writing any SQL. Check the demo video
- Mass Update plugin: Update multiple records at once and improve your workflow efficiency.
- Check our other plugins and get a generous discount of up to 30% when buying 2 or more plugins.
-
- Veteran Member
- Posts: 30
- Joined: 2015-05-12 13:05
Re: data entry in table view
That sounds realy good - I miss this feature too ...
Re: data entry in table view
One way to do what you want. (Well more than one)
While not a free or upgrade solution I have been using Navicat for MySql for quite a while now and it allows me to create a bunch of records quickly. Copy and paste then make changes. It also allows me to access the database tables and made corrections or change one field very quickly. It has a lot of juice. You can do a bunch of this in PhpMyAdmin but I find Navicat easier and more powerful. Just one more tool in the tool chest.
Or you can also, if you have the records in a csv file format, import them that way.
I used the CSV format to import just under 1000 records and then used the admin section to assign owner(s) in no time. Total process for 972 records was under 5 minutes as the data existed already - just not in the online app.
Or take your base record, export it into CSV format, open in excel, copy the record and paste into another row and make changes as needed. Then using the csv import feature of AppGini bring them back in and then assign owners. It is fast, easy and this allows you to have someone else create records for you in Excel without having to touch the database. Just make sure the columns in Excel are in the same order as your fields in your AppGini application.
If you have data in other databases etc then just export it out, import into Excel, put the columns in the right order to import into your AppGini application and away you go.
Whatever you do, always backup your database first using PhpMyadmin or something else which allows you to make a backup copy. Do this before importing etc.
Hope this helps.
Alan
While not a free or upgrade solution I have been using Navicat for MySql for quite a while now and it allows me to create a bunch of records quickly. Copy and paste then make changes. It also allows me to access the database tables and made corrections or change one field very quickly. It has a lot of juice. You can do a bunch of this in PhpMyAdmin but I find Navicat easier and more powerful. Just one more tool in the tool chest.
Or you can also, if you have the records in a csv file format, import them that way.
I used the CSV format to import just under 1000 records and then used the admin section to assign owner(s) in no time. Total process for 972 records was under 5 minutes as the data existed already - just not in the online app.
Or take your base record, export it into CSV format, open in excel, copy the record and paste into another row and make changes as needed. Then using the csv import feature of AppGini bring them back in and then assign owners. It is fast, easy and this allows you to have someone else create records for you in Excel without having to touch the database. Just make sure the columns in Excel are in the same order as your fields in your AppGini application.
If you have data in other databases etc then just export it out, import into Excel, put the columns in the right order to import into your AppGini application and away you go.
Whatever you do, always backup your database first using PhpMyadmin or something else which allows you to make a backup copy. Do this before importing etc.
Hope this helps.
Alan
Calgary, Alberta, Canada - Using Appgini 5.50 -
-
- Posts: 5
- Joined: 2015-07-22 07:29
Re: data entry in table view
Thank you for ask this question data entry in table view because I also Known about it. Several days I tried to learn about it and didn't get any answers.
Re: data entry in table view
This is 2019, Is there hope for the function being actualized in appgini? Am worried we need this feature like decade ago. Admin any hopes of this feature soon?
Re: data entry in table view
This is my personal opinion only
Although I can understand your request for editable tables and really would like to have this option myself, I guess there is a very good reason why noone has ever posted a good hook-only solution:
It is very complicated
Whoever makes up his/her mind about this will soon see that there are many hurdles to take in PHP and Javascript:
Best,
Jan
Although I can understand your request for editable tables and really would like to have this option myself, I guess there is a very good reason why noone has ever posted a good hook-only solution:
It is very complicated
Whoever makes up his/her mind about this will soon see that there are many hurdles to take in PHP and Javascript:
- Doing this for inputs like varchar is not too complicated. This can be done with "contenteditable" attribute and some AJAX + some serverside PHP script.
- Datatypes like date or datetime is a bit more complicated because you need to find out and apply user's locales for date-formatting, for example yyyy-mm-dd or dd.mm.yyyy or ...
- It is the same for numeric datatypes. You need to get and format according to the locales, for example 1,234.000 vs. 1.234,99 vs 1'234.99...
- And it is even much more complicated for lookups because you need much more logic and permission-checking server side before you can offer a dropdown inside the datatable. You have to consider inherited permission etc.
- what about images? upload directly to table?
- what about multi-select options?
- what about richtext?
- what about validation of input before storing to db?
- you need to consider readonly fields
- ...
Best,
Jan
Kind regards,
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
AppGini 24.10 Revision 1579 + all AppGini Helper tools
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
[code]...[/code]
blocks for better readabilityAppGini 24.10 Revision 1579 + all AppGini Helper tools
- cwesthuizen
- Posts: 17
- Joined: 2019-03-26 11:01
- Location: Bloemfontein, South Africa
- Contact:
Re: data entry in table view
I agree with you. But maybe if there was one that could do only the basics I will keep on hoping.
Blessings, Chris
Blessings, Chris
Chris van der Westhuizen
Getafix IT Solutions CC
http://www.getafix.biz
“God has given to man a short time here upon earth and yet upon this short time eternity dependsâ€