Search found 1070 matches

by jsetzer
2021-06-18 05:29
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: React to lookup changes - No working
Replies: 2
Views: 28

Re: React to lookup changes - No working

  • Did you clear browser cache when reloading?
  • Are there any error messages in console output?
Troubleshooting guide:
https://appgini.bizzworxx.de/support/troubleshooting/
by jsetzer
2021-06-18 05:27
Forum: Getting Started
Topic: Issue with the database backup on the new version
Replies: 28
Views: 11081

Re: Issue with the database backup on the new version

You don't have to create a "root" user, becaue you already have one. Have a look at your config.php file. There are the credentials which AppGini uses to connect to your database. According to your information, there will be the following lines: $dbUsername = 'root'; $dbPassword = '...YOUR.PASSWORD....
by jsetzer
2021-06-18 05:16
Forum: Tips And Tricks
Topic: Creating Auto Fields in a Table
Replies: 2
Views: 60

Re: Creating Auto Fields in a Table

So you'd like to turn records of one table into columns of a second table like so: Table "Services" -id -name Data 1 ; Webhosting 2 ; Domain Names 3 ; Support Table "TABLE2" -id -webhosting -domain_names -support That's not possible "on the fly" with standard AppGini, because AppGini requires a stat...
by jsetzer
2021-06-18 05:00
Forum: Advanced Customizations > Others
Topic: Displaying Invoice Items ordered by Item Group
Replies: 6
Views: 172

Re: Displaying Invoice Items ordered by Item Group

OK, fields are there, SQL seems fine for this setup.

Please show us configuration and SQL of calculated field `item_group_position`
by jsetzer
2021-06-18 04:56
Forum: Getting Started
Topic: Disable "Add New" if I reach 0 (zero)
Replies: 3
Views: 91

Re: Disable "Add New" if I reach 0 (zero)

First thing which comes into my mind: As this is a detail view, you can check value of balance in TABLENAME_dv hook: If balance is zero, revoke insert permission on database level (using SQL command) from group or even from specific user (we don't know your use-case). Then append an alert to $html v...
by jsetzer
2021-06-16 19:02
Forum: Getting Started
Topic: Issue with the database backup on the new version
Replies: 28
Views: 11081

Re: Issue with the database backup on the new version

If you can connect to database "TecnoApps" on localhost, port 3307 with user "root" and password using Adminer, but mysqldump command with identical settings and credentials raises error "Unknown MySQL server host 'localhost:3307'", actually, I have no idea right now. If the server is the same and a...
by jsetzer
2021-06-16 18:50
Forum: Getting Started
Topic: Disable "Add New" if I reach 0 (zero)
Replies: 3
Views: 91

Re: Disable "Add New" if I reach 0 (zero)

Change permissions in admin area.
Revoke insert permission on that table from the specify group or groups.
by jsetzer
2021-06-16 18:48
Forum: Advanced Customizations > Others
Topic: Displaying Invoice Items ordered by Item Group
Replies: 6
Views: 172

Re: Displaying Invoice Items ordered by Item Group

Then fields are missing or you have an error in your SQL query, perhaps table- or field-names are different
by jsetzer
2021-06-14 07:58
Forum: Advanced Customizations > Others
Topic: Displaying Invoice Items ordered by Item Group
Replies: 6
Views: 172

Re: Displaying Invoice Items ordered by Item Group

Maybe it works the following way: add a new integer field `position` to `item_groups` table add a new calculated field `item_group_position` to `items` table SQL for calculated field (untested): SELECT `position` FROM `item_groups` WHERE `items`.`item_group` = `item_groups`.`id` AND `items`.`id` = '...
by jsetzer
2021-06-14 07:48
Forum: Getting Started
Topic: Limit record on subform based quantity requested
Replies: 2
Views: 85

Re: Limit record on subform based quantity requested

Also Is it possible to disable or hide the button called "Details Commande" on the top at the left.
(1) For hiding the top-right button ("children links"):

AppGini_hlwSkDyg2o.png
AppGini_hlwSkDyg2o.png (74.34 KiB) Viewed 65 times

---
(2) For hiding the tab at the bottom ("children tabs")

AppGini_5KUsWYQsuz.png
AppGini_5KUsWYQsuz.png (159.7 KiB) Viewed 65 times
by jsetzer
2021-06-14 07:42
Forum: Getting Started
Topic: Issue with the database backup on the new version
Replies: 28
Views: 11081

Re: Issue with the database backup on the new version

Unknown MySQL server host 'localhost:3307
Did your check if your local SQL server is running at all and listening on port 3307?

You can check it by downloading and using a tool like Adminer (https://www.adminer.org/) or any other database tool you prefer.
by jsetzer
2021-06-09 19:24
Forum: Bugs/annoyances
Topic: Can't save a new record
Replies: 10
Views: 322

Re: Can't save a new record

Don't overwrite especially config.php and setup.md5 when uploading to your server using FTP or whatever.

Yes, it is documented somewhere, but don't ask me where I read it during my first steps with AppGini.
by jsetzer
2021-06-07 06:12
Forum: Bugs/annoyances
Topic: Can't save a new record
Replies: 10
Views: 322

Re: Can't save a new record

There are several files you should exlude from upload. Maybe I forgot some, but I'll give it a start here: config.php config.bak.php setup.md5 *.axp I got used to save my project files within the same directory for convenience reasons. But I do not upload them to production servers. Thumbs.db ./imag...
by jsetzer
2021-06-07 05:56
Forum: Getting Started
Topic: Issue with the database backup on the new version
Replies: 28
Views: 11081

Re: Issue with the database backup on the new version

I have added the C:/inetpub/wwwroot/admin/backups in environmental variable path You have to set the directory name of mysqldump.exe , not your backups-directory. In my case this is C:\xampp\mysql\bin but it may be different in your machine, depending on your database server installation. As I was ...
by jsetzer
2021-06-04 05:03
Forum: Advanced Customizations > Hooks
Topic: prevent from being saved if an option is selected on radio button field and the next field is left blank
Replies: 1
Views: 156

Re: prevent from being saved if an option is selected on radio button field and the next field is left blank

Seems you are looking for conditional validation: field2 is required IF field1 does not contain a certain value. Alternative 1 (PHP) Unset "required", re-generate app, then validate $data on serverside (PHP) in _before_insert and _before_update. Depending on the validation result, return TRUE or FAL...
by jsetzer
2021-06-04 04:44
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: console error on react to lookup changes
Replies: 1
Views: 83

Re: console error on react to lookup changes

Please check, if you are using just the fieldname (like "fieldname") or a jquery selector (like "#fieldname") instead, when using field functions of AppGiniHelper Javascript Library. When using functions such as dv.getField('"fieldname") or dv.getFields(["fieldname1", "fieldname2"]) or other field-r...
by jsetzer
2021-06-04 04:36
Forum: Feature Suggestions
Topic: Very large number of image files
Replies: 1
Views: 75

Re: Very large number of image files

Thanks for your contribution! A customer of mine once told me about similar experiences having > 10000 files per directory. So in that customer project we split files into subdirectories. Possible workaround In a project, handling product pictures, after_insert we move images into in a separate subd...
by jsetzer
2021-06-03 15:01
Forum: Bugs/annoyances
Topic: All $Translation strings (and image folder) available to view in source code?
Replies: 3
Views: 148

Re: All $Translation strings (and image folder) available to view in source code?

+1 I totally agree with @peebee. That much javascript code directly inside the main file gets annoying more and more. I'd definately prefer loading literals ($Translations) from an external javascript- or JSON file. <script src="resources/appgini/language.js?v=1234567"></script> For avoiding cache p...
by jsetzer
2021-05-26 04:54
Forum: Advanced Customizations > Others
Topic: Calculated field with time format
Replies: 2
Views: 309

Re: Calculated field with time format

Code: Select all

SELECT 
time_format(timediff(`stop`, `start`), '%H:%i')
FROM `dtv_test_dv`
WHERE `id`='%ID%'
by jsetzer
2021-05-25 15:23
Forum: Getting Started
Topic: Autocomplete
Replies: 14
Views: 454

Re: Autocomplete

autocomplete in a text box Lookup fields support searching for items when typing a few characters, by default. If you need autocomplete in a text-box can you please explain your idea a bit more detailed. Do you mean <input> or <textarea>? You will need some Javascript on client-side which, after ch...
by jsetzer
2021-05-05 09:58
Forum: Advanced Customizations > Others
Topic: Calculated fields
Replies: 5
Views: 265

Re: Calculated fields

Perhaps the solution is much simpler: I just saw that a single quote is missing at the end of your SQL command SELECT ( `DNB_MAITRISE_SOCLE`.`D11_FR`+`DNB_MAITRISE_SOCLE`.`D11_HG`+`DNB_MAITRISE_SOCLE`.`D11_SVT`+`DNB_MAITRISE_SOCLE`.`D11_PHY`+`DNB_MAITRISE_SOCLE`.`D11_TECHNO`)/5 FROM DNB_MAITRISE_SOC...
by jsetzer
2021-05-05 09:46
Forum: Advanced Customizations > Others
Topic: Calculated fields
Replies: 5
Views: 265

Re: Calculated fields

+1 for @pböttcher: Using NULL for calculations may produce unexpected results, I totally agree, see simple example in SQL: chrome_bHPwdWloWX.png But on the other hand we can see from the screenshot that you don't have NULLs in the selected fields of that specific row. Narrow down Did you check if yo...
by jsetzer
2021-05-05 04:38
Forum: Getting Started
Topic: Concatenation with date() to get month
Replies: 5
Views: 208

Re: Concatenation with date() to get month

Does $data contain a prefix-value? prefix field must not be readonly. For narrowing down I would debug the contents of $data in before_insert hook to see if there is any $data['prefix'] array item at all: var_dump($data); exit(); :oops: SORRY, I was too fast. My answer is not helpful as you said, yo...
by jsetzer
2021-05-04 08:26
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: add and view buttons disappear when adding to tab
Replies: 8
Views: 1403

Re: add and view buttons disappear when adding to tab

One more question: Are you using .wrap() function on fields, for example something like this?

Code: Select all

dv.getFields("item_id,task_id").wrap();
by jsetzer
2021-05-02 17:16
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: add and view buttons disappear when adding to tab
Replies: 8
Views: 1403

Re: add and view buttons disappear when adding to tab

(1) I'd like to to repeat my question from last post: Does it also happen without including AppGiniHelper? Can you please answer this. (2) AppGiniHelper | problem with label This warning message (yellow) usually means that you try to change a field that does not exist or cannot be found at that mome...