Search found 77 matches

by sjohn
2019-05-23 12:00
Forum: Advanced Customizations > Hooks
Topic: fix table header
Replies: 3
Views: 144

Re: fix table header

Take a look at this amazing solution from pböttcher : viewtopic.php?f=4&t=2673
It functions and number of records on a "page" can be set in AppGini, and the fixed area can be set in the code.
by sjohn
2019-05-08 11:02
Forum: Advanced Customizations > Hooks
Topic: Order by date if lookup field
Replies: 23
Views: 480

Re: Order by date if lookup field

@fgazza
just a question : Would it be possible for you to use the date format as : yyyy-mm-dd.
With this format, it should give the same result if sorting is in date or alphabetical order.
by sjohn
2019-04-27 15:03
Forum: Advanced Customizations > Hooks
Topic: Upload via FTP
Replies: 4
Views: 191

Re: Upload via FTP

If it MUST be FTP then there is a script on GitHub : https://gist.github.com/gayanhewa/8f16e94842f48814ca28
by sjohn
2019-04-27 14:59
Forum: Advanced Customizations > Hooks
Topic: Upload via FTP
Replies: 4
Views: 191

Re: Upload via FTP

Is FTP a must?

If not, then I have a good script that can view files, and upload files. Can be password-protected. The uploading is browser-based.
It is all in a single php-file.
by sjohn
2019-04-25 09:31
Forum: Feature Suggestions
Topic: Create views in AppGini
Replies: 2
Views: 449

Create views in AppGini

It would be a good thing if you could create views in AppGini. You should have the possibility to create a "special" table as a copy of another table. The field definitions should be shown automatically from the "original" and should not be changeable. You should have the possibility to add new fiel...
by sjohn
2019-04-25 09:14
Forum: Advanced Customizations > Hooks
Topic: insert data in the first table the same data is automatically inserted in the second identical table
Replies: 6
Views: 241

Re: insert data in the first table the same data is automatically inserted in the second identical table

There is no code that need to be integrated. The example was only to show how to make a view with a calculated row. The view only has to be created once. But you have to create it manually. Once it is created it can be used almost like a "normal" table. All you have to do is : In AppGini you create ...
by sjohn
2019-04-24 08:29
Forum: Advanced Customizations > Hooks
Topic: insert data in the first table the same data is automatically inserted in the second identical table
Replies: 6
Views: 241

Re: insert data in the first table the same data is automatically inserted in the second identical table

Short answer - yes. The following example defines a view that selects two columns from another table as well as an expression calculated from those columns: mysql> CREATE TABLE t (qty INT, price INT); mysql> INSERT INTO t VALUES(3, 50); mysql> CREATE VIEW v AS SELECT qty, price, qty*price AS value F...
by sjohn
2019-04-23 14:22
Forum: Advanced Customizations > Hooks
Topic: insert data in the first table the same data is automatically inserted in the second identical table
Replies: 6
Views: 241

Re: insert data in the first table the same data is automatically inserted in the second identical table

Could you not make the second table as a view of the first table. This way all data is automatically updated. You could first create both tables in AppGini. Then upload and let the tables be created. Then delete the "mirror"-table and recreate it as a view of the first table. Hope you understand wha...
by sjohn
2019-04-10 09:33
Forum: Getting Started
Topic: disable row editing if a field is equal to....
Replies: 7
Views: 230

Re: disable row editing if a field is equal to....

I have a question to this : Should also not something be done in the detail-view? I guess that mouse (left) click is disabled if record contains a certain value. But what if user right-click and then "pick" the link-address/URL, and opens this in a new tab - will the user then not see the detail view?
by sjohn
2019-02-27 14:25
Forum: Tips And Tricks
Topic: Filtering tables with dropdowns
Replies: 2
Views: 275

Re: Filtering tables with dropdowns

This could be really good. And in the dropdown - a count for each group-by. By this I mean : the dropdown should show the different grouped values for a column and then a count for each existence. Much like when you make a filter for a shop or so. The count should give a hint of how many records wil...
by sjohn
2019-02-26 09:01
Forum: Tips And Tricks
Topic: view more than 10 records in a Child Table
Replies: 7
Views: 2814

Re: view more than 10 records in a Child Table

I thought that setting the records per page would also affect the setting for the child table - but apparently not. It is maybe hardcoded and prepared for a setting option in a future release.
by sjohn
2019-02-25 17:15
Forum: Tips And Tricks
Topic: view more than 10 records in a Child Table
Replies: 7
Views: 2814

Re: view more than 10 records in a Child Table

Hello nycwebmaster You could use the amazing piece of code displayed by pböttcher https://forums.appgini.com/phpbb/viewtopic.php?f=4&t=2673&p=8401#p8401 It is made in the hook's and will not be overwritten. This code is really useful. It still initially show 10 records. but if you set the records to...
by sjohn
2019-02-24 10:23
Forum: Getting Started
Topic: Multiple items update at once with a "invoice" output format
Replies: 4
Views: 316

Re: Multiple items update at once with a "invoice" output format

1+2 : You create an invoice. On this invoice you create lines. You create the invoice-lines by choosing from another table ( the products table). On each line you put in a quantity. This way you have a copy of the product as a invoice-line. When you delete a line in the invoice it is not the product...
by sjohn
2019-02-23 10:24
Forum: Getting Started
Topic: Multiple items update at once with a "invoice" output format
Replies: 4
Views: 316

Re: Multiple items update at once with a "invoice" output format

Just to clarify :
You create the view table as a "normal" table in Appgini. It could be a copy of the original table.
The view has to be created on the server.
by sjohn
2019-02-23 10:07
Forum: Getting Started
Topic: Multiple items update at once with a "invoice" output format
Replies: 4
Views: 316

Re: Multiple items update at once with a "invoice" output format

Should it be only you that could perform this operation? Or should also other persons be able to do it. If it is more persons, then you could create an invoice by creating a invoice-header ( parent ) and then "attach" invoice lines ( will be child ) from a product table. This would be much like you ...
by sjohn
2019-02-16 15:26
Forum: Getting Started
Topic: mask CPF e Tel
Replies: 4
Views: 373

Re: mask CPF e Tel

Was it not possible for you to use the built-in format option? Eventually add/edit date formats?
format.jpg
format.jpg (37.29 KiB) Viewed 290 times
by sjohn
2019-02-07 12:39
Forum: Advanced Customizations > Others
Topic: Single entry a registered user
Replies: 7
Views: 381

Re: Single entry a registered user

Do you have existing data?
There could be a conflict then, with more records that has the same "empty" value - and then the unique setting.
Check in the table if the field is set as unique. Maybe it is needed you manually set a value in existing records before the field can be set as unique.
by sjohn
2019-02-06 18:50
Forum: Advanced Customizations > Others
Topic: Single entry a registered user
Replies: 7
Views: 381

Re: Single entry a registered user

Maybe the easiest would be, to have a field where you store the user.
This could be done by using the : Default >> Auto - username
If you then set this field a unique, then a user will only be allowed to create one entry, and if he tries to create one more, then he will see that this is not possible.
by sjohn
2019-01-17 11:48
Forum: Advanced Customizations > Hooks
Topic: Apply a default filter on a table
Replies: 3
Views: 369

Re: Apply a default filter on a table

This is a catch 22 - but as it is an initial filter, then when paging the same thing happens as with eventual "marked/checked" records - it is a new page-load. If it is a table with not too many records, you could maybe use the fantastic "scroll" suggested by pböttcher : https://forums.appgini.com/p...
by sjohn
2019-01-14 09:45
Forum: Tips And Tricks
Topic: Picture field
Replies: 3
Views: 344

Re: Picture field

OR - do you mean that you by upload want to be able to specify a folder name on the server, and then have the images be stored in this folder ?
by sjohn
2019-01-14 09:35
Forum: Getting Started
Topic: Aligning integer field data
Replies: 8
Views: 518

Re: Aligning integer field data

What setting do you have for the field?
alignment.jpg
alignment.jpg (7.41 KiB) Viewed 498 times
by sjohn
2019-01-14 06:42
Forum: Tips And Tricks
Topic: Picture field
Replies: 3
Views: 344

Re: Picture field

Hello hubert Maybe the post from jsetzer about the organisation chart could be used. https://forums.appgini.com/phpbb/viewtopic.php?f=4&t=2874 Imagine that instead of a name on a person, then it was the name of a folder. The "name" can be made clickable. The structure can be made from data in the da...
by sjohn
2019-01-02 12:46
Forum: Tips And Tricks
Topic: DropDown List different colors
Replies: 6
Views: 798

Re: DropDown List different colors

Hello mskuodas Provided I understand the "problem" I have a simple solution, that requires no code at all. Create a lookup table. In this lookup table make a field defined as a rich-text field. In the field you can then have an image and/or some colored text. In the table where you want the lookup s...
by sjohn
2018-12-18 16:37
Forum: Advanced Customizations > Hooks
Topic: Change All fields to Read only
Replies: 6
Views: 449

Re: Change All fields to Read only

Is it not possible to make a supervisor-group, that has the credentials needed for supervisors? Or - let the supervisor login as supervisor when he should be supervisor, and log in as "normal" user when/if he should be a normal use? I am just guessing - to suggest a proper solution, requires that on...