Hi pasbonte,
maybe you explain a bit more what you try to acheive and why you need to store that data in the same table. That could help in finding a solution.
Search found 1615 matches
- 2023-11-09 22:14
- Forum: Advanced Customizations > Others
- Topic: How do I save the amount and not the id in my database?
- Replies: 3
- Views: 935
- 2023-10-22 16:13
- Forum: Tips And Tricks
- Topic: Grey one field according to another
- Replies: 1
- Views: 1668
Re: Grey one field according to another
Hi, as this is very specific the answer can not be clear. What kind of fields do you have? If you say gray out, does it mean that you want to make that field read-only? in general, with javascript (jquery) you can a "on change" event on you fields and react accordingly, e.g. $j(document).ready(funct...
- 2023-10-15 15:56
- Forum: Advanced Customizations > Others
- Topic: Quick search: search for two items at the same time
- Replies: 9
- Views: 2045
Re: Quick search: search for two items at the same time
Can you show the _init function with the code and the _header -> tableview case as mentioned above.
- 2023-10-15 15:26
- Forum: Tips And Tricks
- Topic: Date Picker
- Replies: 2
- Views: 954
Re: Date Picker
Hi Ron,
did you change anything? Upgrade you AppGini Version?
did you change anything? Upgrade you AppGini Version?
- 2023-10-15 15:24
- Forum: Advanced Customizations > Others
- Topic: Quick search: search for two items at the same time
- Replies: 9
- Views: 2045
Re: Quick search: search for two items at the same time
Can you post your code here?
- 2023-10-14 15:13
- Forum: Advanced Customizations > Others
- Topic: No Image Uploaded - default image req'd
- Replies: 5
- Views: 974
Re: No Image Uploaded - default image req'd
Hi Ron,
try in the function your_horse_after_insert and function your_horse_after_update
try in the function your_horse_after_insert and function your_horse_after_update
Code: Select all
if (empty($data['horse_pic'])) {
$eo=[];
$sql="UPDATE your_horse set horse_pic='no_image.png' where id={$data['selectedID']}";
sql($sql,$eo);
}
- 2023-10-14 11:26
- Forum: Advanced Customizations > Others
- Topic: automatic calculation instead of after update/insert code
- Replies: 3
- Views: 812
Re: automatic calculation instead of after update/insert code
Hi, without having the table really visibile it is hard to understand. You may try: SELECT SUM(`m2`.`Lordo`)-acquisto_peso.Tot_blocchi FROM `Movimenti_acquisto_peso` LEFT JOIN Movimenti_acquisto_peso m2 on m2.Totfat = Movimenti_acquisto_peso.Totfat LEFT JOIN acquisto_peso on acquisto_peso.id=m2.Totf...
- 2023-10-13 20:55
- Forum: Advanced Customizations > Others
- Topic: No Image Uploaded - default image req'd
- Replies: 5
- Views: 974
Re: No Image Uploaded - default image req'd
Hi
you could add an image to the images folder and use sql to add this image in the after insert hook.
you could add an image to the images folder and use sql to add this image in the after insert hook.
- 2023-10-12 20:29
- Forum: Advanced Customizations > Others
- Topic: automatic calculation instead of after update/insert code
- Replies: 3
- Views: 812
Re: automatic calculation instead of after update/insert code
Hi, you may try: SELECT SUM(`Movimenti_acquisto_peso`.`Lordo`) - `Acquisto_peso`.Tot_blocchi` FROM `Movimenti_acquisto_peso`, `Movimenti_acquisto_peso` WHERE `Movimenti_acquisto_peso`.`Totfat`= `Movimenti_acquisto_peso`.`Totfat` AND `Acquisto_peso`.`id` = `Movimenti_acquisto_peso`.`Totfat` AND `Movi...
- 2023-10-10 21:04
- Forum: Getting Started
- Topic: PHP number of days for each year between two dates
- Replies: 2
- Views: 802
Re: PHP number of days for each year between two dates
Hi, as you ask for a php solution you could try: // Define start and end dates $startdate='2021-05-12'; $enddate='2023-09-24'; $start_date = new DateTime($startdate); $end_date = new DateTime($enddate); // Define interest rates for each year $interest_rates = [ 2021 => 3.50, 2022 => 2.94, 2023 => 4....
- 2023-10-07 13:01
- Forum: Advanced Customizations > Others
- Topic: Quick search: search for two items at the same time
- Replies: 9
- Views: 2045
Re: Quick search: search for two items at the same time
Hi, the actual answer is no, you cannot do it without adding some code. AppGini uses by default a wildcard search on the string you enter. So if you say that you use the "space" as a delimiter for your search, you might try this: in the hooks/TABLENAME.php -> _init function if (isset($_REQUEST['Sear...
- 2023-10-01 19:18
- Forum: Getting Started
- Topic: Having a Problem getting a Global Variable
- Replies: 2
- Views: 1002
Re: Having a Problem getting a Global Variable
Hi, you reference 2 problems. But I'm not even clear on one of them. Can you specify this in more details? From what you write I would assume that you store in$memberInfo['custom'][0]; a custindex that you have in your product table as well. If you try to display only the product for the user which ...
- 2023-10-01 19:07
- Forum: Advanced Customizations > Hooks
- Topic: Saves and all the fields are blocked
- Replies: 3
- Views: 785
Re: Saves and all the fields are blocked
Hi,
you could use the _footer hook (case 'detailview':) to check if the status = OFF and if the group of the user != Admins then disable all input fields.
There might be a bit more to do, but I hope this give you a starting point.
you could use the _footer hook (case 'detailview':) to check if the status = OFF and if the group of the user != Admins then disable all input fields.
There might be a bit more to do, but I hope this give you a starting point.
- 2023-10-01 19:00
- Forum: Getting Started
- Topic: How can I do to display numbers in the format 1.234,56 ?
- Replies: 8
- Views: 3098
Re: How can I do to display numbers in the format 1.234,56 ?
Hi ,
which version of AppGini are you using? I think the newer versions allow using the Data format with calculated fields.
which version of AppGini are you using? I think the newer versions allow using the Data format with calculated fields.
- 2023-09-27 19:32
- Forum: Tips And Tricks
- Topic: Import csv
- Replies: 12
- Views: 1814
Re: Import csv
Hi Ron, is it possible that you do not have a value in the field Link_pCloud ? This field seems to be unique field and if you do not have a different value per row, only one row will be imported. I didn't see the field in the first dataset with the 3 records and no value in the second one with only ...
- 2023-09-18 20:57
- Forum: Getting Started
- Topic: To do List, Work, but need to make recurrent in an easy way.
- Replies: 1
- Views: 757
Re: To do List, Work, but need to make recurrent in an easy way.
Hi,
what you can try.
In the hooks/__global.php -> login_ok function you can add a SQL statement to check if the records for today already exist. If not just create them as a copy from the last available TODO's with resetting the date value.
what you can try.
In the hooks/__global.php -> login_ok function you can add a SQL statement to check if the records for today already exist. If not just create them as a copy from the last available TODO's with resetting the date value.
- 2023-09-13 19:18
- Forum: Getting Started
- Topic: Update account auto
- Replies: 2
- Views: 875
Re: Update account auto
Hi,
just as an idea. Why not use the _after_insert hook and make the calculation with SQL for the ACCOUNTS table.
just as an idea. Why not use the _after_insert hook and make the calculation with SQL for the ACCOUNTS table.
- 2023-09-12 18:50
- Forum: Advanced Customizations > Hooks
- Topic: Validation help - In stock check
- Replies: 6
- Views: 1713
Re: Validation help - In stock check
Hi,
can you explain a bit detailled how your stucture looks like?
can you explain a bit detailled how your stucture looks like?
- 2023-09-06 19:13
- Forum: Getting Started
- Topic: Fetch Issue
- Replies: 3
- Views: 998
Re: Fetch Issue
Hi,
csn check what type your trknum field has. Guess this has only 10 char.
csn check what type your trknum field has. Guess this has only 10 char.
- 2023-09-03 14:59
- Forum: Getting Started
- Topic: How can I do to display numbers in the format 1.234,56 ?
- Replies: 8
- Views: 3098
- 2023-09-03 07:07
- Forum: Advanced Customizations > Hooks
- Topic: Validation help - In stock check
- Replies: 6
- Views: 1713
Re: Validation help - In stock check
Hi,
at the time the user enters the Quantity (on change event) you could retrive the Quantity in stock via ajax and check if enough is available.
at the time the user enters the Quantity (on change event) you could retrive the Quantity in stock via ajax and check if enough is available.
- 2023-09-03 07:01
- Forum: Getting Started
- Topic: Suggestion about migration from IIS 7.5 to IIS 10.0
- Replies: 5
- Views: 1165
Re: Suggestion about migration from IIS 7.5 to IIS 10.0
Hi Alex,
for MySql the recent version should be fine.
for MySql the recent version should be fine.
- 2023-08-31 10:22
- Forum: Getting Started
- Topic: Suggestion about migration from IIS 7.5 to IIS 10.0
- Replies: 5
- Views: 1165
Re: Suggestion about migration from IIS 7.5 to IIS 10.0
Hi,
I would suggest to go with a PHP Version 7.x for the older AppGini App.
I would suggest to go with a PHP Version 7.x for the older AppGini App.
- 2023-06-08 18:32
- Forum: Getting Started
- Topic: action button after "Save Changes" was pressed
- Replies: 3
- Views: 1247
Re: action button after "Save Changes" was pressed
Hi,
just a short question to understand you need. Why cant you put your code in the _after_update hook?
just a short question to understand you need. Why cant you put your code in the _after_update hook?
- 2023-06-08 17:45
- Forum: Getting Started
- Topic: Question about the Field Caption Length
- Replies: 1
- Views: 723
Re: Question about the Field Caption Length
Hi,
not sure if I get what you really try to acheive, but may try to add to your hooks/header-extras.php the following:
where the 200px is just an example.
not sure if I get what you really try to acheive, but may try to add to your hooks/header-extras.php the following:
Code: Select all
<style>
.field-caption-tv {
width: 200px !important;
}
</style>