AppGini Community Forums

pböttcher

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.

pböttcher

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...

pböttcher

Can you show the _init function with the code and the _header -> tableview case as mentioned above.

pböttcher

Hi Ron,

did you change anything? Upgrade you AppGini Version?

pböttcher

Can you post your code here?

pböttcher

Hi Ron,

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);
}

pböttcher

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...

pböttcher

Hi
you could add an image to the images folder and use sql to add this image in the after insert hook.

pböttcher

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...

pböttcher

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....

pböttcher

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...

pböttcher

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 ...

pböttcher

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.

pböttcher

Hi ,

which version of AppGini are you using? I think the newer versions allow using the Data format with calculated fields.

pböttcher

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 ...

pböttcher

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.

pböttcher

Hi,

just as an idea. Why not use the _after_insert hook and make the calculation with SQL for the ACCOUNTS table.

pböttcher

Hi,
can you explain a bit detailled how your stucture looks like?

pböttcher

Hi,
csn check what type your trknum field has. Guess this has only 10 char.

pböttcher

Hi,

maybe this help:
viewtopic.php?f=11&t=4510&p=18281&hilit ... lds#p18281

pböttcher

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.

pböttcher

Hi Alex,

for MySql the recent version should be fine.

pböttcher

Hi,

I would suggest to go with a PHP Version 7.x for the older AppGini App.

pböttcher

Hi,

just a short question to understand you need. Why cant you put your code in the _after_update hook?

pböttcher

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:

Code: Select all

<style>
.field-caption-tv {
	width: 200px !important;
}
</style>

where the 200px is just an example.

AppGini Community Forums

Search found 1615 matches

Re: How do I save the amount and not the id in my database?

Re: Grey one field according to another

Re: Quick search: search for two items at the same time

Re: Date Picker

Re: Quick search: search for two items at the same time

Re: No Image Uploaded - default image req'd

Re: automatic calculation instead of after update/insert code

Re: No Image Uploaded - default image req'd

Re: automatic calculation instead of after update/insert code

Re: PHP number of days for each year between two dates

Re: Quick search: search for two items at the same time

Re: Having a Problem getting a Global Variable

Re: Saves and all the fields are blocked

Re: How can I do to display numbers in the format 1.234,56 ?

Re: Import csv

Re: To do List, Work, but need to make recurrent in an easy way.

Re: Update account auto

Re: Validation help - In stock check

Re: Fetch Issue

Re: How can I do to display numbers in the format 1.234,56 ?

Re: Validation help - In stock check

Re: Suggestion about migration from IIS 7.5 to IIS 10.0

Re: Suggestion about migration from IIS 7.5 to IIS 10.0

Re: action button after "Save Changes" was pressed

Re: Question about the Field Caption Length