AppGini Community Forums

pböttcher

Hi,

just to add, if you change the code, please consider how you change it.

In your code you have

Date = new Date(d[2] + '/' + d[1] + '/' + d[0]);

which causes the error. Use entereddate instead of Date and it should work.

pböttcher

Hi, you need to select the text from the produits table. Also the join needs to reflect the field that are connected `Produits`.`id` and `bondecommande`.`bon_produit` Try SELECT `Produits`.`prod` FROM `bondecommande` INNER JOIN `Produits` ON `Produits`.`id` = `bondecommande`.`bon_produit` WHERE `bon...

pböttcher

Hi, yo have 2 issues, first you did not put the code correctly. In your code you have $j(function() { $j('.louth-entereddate').each(function() { var entereddate = new date($j(this).text()); var yesterday = new date(new date().getTime() - (24 * 60 * 60 * 1000)); if (entereddate < yesterday) { $j(this...

pböttcher

Try

Code: Select all

var yesterday = new Date(new Date().getTime() - (24 * 60 * 60 * 1000));

instead of

Code: Select all

var yesterday = new Date(today.getTime() - (24 * 60 * 60 * 1000));

pböttcher

Hi,

maybe you can share a bit more information.

As the call goes to the server (php file) you can check in der browser network tab if you see the call and the response.
Also you can trace the php side to see if your call statement to the mysql side workes.

pböttcher

Hi,

you can set

Code: Select all

<script>
AppGini.noLocaleFormatting=true;
</script>

in the hooks/footer-extras.php

this will prevent changing the sum field.

pböttcher

Hi,

Appgini will call the the display of the table, TV after a delete happend, so your script will not be executed.

pböttcher

Hi, without digging into it, I would assume that you navigate through the wrong directory structure. the after_insert function is located in the hooks directory, but called within the root directory. So the used path should be relativ to the root directory. If you put your test script in the hooks f...

pböttcher

Hi,

try

Code: Select all

$options->QueryFrom = ' `u05_tank` INNER JOIN `membership_users` ON `u05_tank`.`username` = `membership_users`.`memberID`';

I think there is no need for the first FROM. But looking at your original query you may need the other fields (joins) as well.

pböttcher

Hi, as far as I know, for new entries the button labels "Save New", if you edit an existing record the button text changes to "Save Changes". Not sure what else you would need. If you need to update a field on the "save change" action you can use the _before_update or _after_update function within t...

pböttcher

Hi, I think there are some points tu understand. Per default AppGini stores all images into one folder. If you want to store images in different folders this requires some code. For the default image folder (=baseUploadPath ) AppGini generates thumbnails for the TV and DV. These are named like the o...

pböttcher

Hi, maybe it is helpful to understand your setting. - you create a new backend (with AppGini). -> Do you have the information about the images stored in your database? Usually AppGini stores the name of the image in the database. - you changed the baseUploadPath -> are all your images in this path, ...

pböttcher

Hi, I just reviewed the code above. Maybe the erro was with the fixed name "John". Try $from_old['postcode']="if ((select memberID from membership_userrecords where tableName='listing' and pkValue=listing.listingID)='".'$memberInfo['username']."', IF( CHAR_LENGTH(`postcode1`.`postcode`), CONCAT_WS('...

pböttcher

As far as I could see the option is set "hard" to 0 so it should not matter. Any error messages in the Webserver/PHP log files?

pböttcher

Well, where is your problem? You use your 'items' from your second table and populate the "firsttable.multiselectfield.csv" file on insert/update/delete from your second table. The tags table in the blog is your second table and the tag field is your items field. In your first table your create the ...

pböttcher

Hi,

maybe this helps you as a starting point.

https://bigprof.com/blog/appgini/a-work ... gini-apps/

pböttcher

Maybe you can check the server logs (webserver) to identify if there is an error

pböttcher

is the CURLOPT_SSL_VERIFYPEER set to 1 or 0 ?
if 0 then it will probably not be the issue.

pböttcher

That sounds like the causing issue. Can you revert on the server to an older version?

pböttcher

Hi Ray,

can you dump you PHP version to verify that this is still the same than the one you have localy.

pböttcher

Hi, there is an error in the script: function envoyer_sms(GES_SMS, ids){ const message="Please enter data"; var text=window.prompt(message); var url = envoyer_sms.php?table=' + GES_SMS + "&id="+encodeURI(ids)+"&text="+encodeURI(text); window.open(url); } This is just a sample. It will send one messa...

pböttcher

Hi Ray,

first question: Did you change anything? Re-loaded the app, or anything else?

pböttcher

Hi, if you have your function ready to send the sms on a selected record, you can just add a popup with requesting the data you need to be entered. Once the users entered that data, pass it to the "SEND SMS" PHP in the url. Now you can use the data to fill the SMS. something like: function send_sms ...

pböttcher

Hi,

this should work. Can you please recreate your app, clear the browser cache and change the 10 in the parent-children.php and check again.

pböttcher

Hi Ron,

I would rather guess that there has been a hickup with the settings. I should just work fine with the option list and having it as required.

Maybe you can try that again.

Did you, by any chance, have the field definied different before you made it an option list?

AppGini Community Forums

Search found 1576 matches

Re: Highlight date row of more than 1 day old.

Re: Question about parent tables

Re: Highlight date row of more than 1 day old.

Re: Highlight date row of more than 1 day old.

Re: Field editor in table view

Re: Column sum wrong number format in table view

Re: Trying to read src attribute of img tag

Re: Trying to relocate image to another folder

Re: $options->QueryFrom & INNER JOIN

Re: New Action Button

Re: How to create thumbnail photos after the fact?

Re: How to create thumbnail photos after the fact?

Re: Hiding columns from non-owners

Re: Save As Copy Not Working (child records)

Re: Multi select dropdown

Re: Multi select dropdown

Re: Save As Copy Not Working (child records)

Re: Save As Copy Not Working (child records)

Re: Save As Copy Not Working (child records)

Re: Save As Copy Not Working (child records)

Re: Send a SMS with text

Re: Save As Copy Not Working (child records)

Re: Send a SMS with text

Re: Scrollable table in DV-TV

Re: Not Empty field message