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.
Search found 1576 matches
- 2023-03-16 20:02
- Forum: Advanced Customizations > Hooks
- Topic: Highlight date row of more than 1 day old.
- Replies: 8
- Views: 322
- 2023-03-15 20:20
- Forum: Getting Started
- Topic: Question about parent tables
- Replies: 19
- Views: 302
Re: Question about parent tables
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...
- 2023-03-15 20:15
- Forum: Advanced Customizations > Hooks
- Topic: Highlight date row of more than 1 day old.
- Replies: 8
- Views: 322
Re: Highlight date row of more than 1 day old.
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...
- 2023-03-14 21:28
- Forum: Advanced Customizations > Hooks
- Topic: Highlight date row of more than 1 day old.
- Replies: 8
- Views: 322
Re: Highlight date row of more than 1 day old.
Try
instead of
Code: Select all
var yesterday = new Date(new Date().getTime() - (24 * 60 * 60 * 1000));
Code: Select all
var yesterday = new Date(today.getTime() - (24 * 60 * 60 * 1000));
- 2023-02-17 18:23
- Forum: Advanced Customizations > Others
- Topic: Field editor in table view
- Replies: 34
- Views: 17658
Re: Field editor in table view
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.
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.
- 2023-02-12 13:43
- Forum: Bugs/annoyances
- Topic: Column sum wrong number format in table view
- Replies: 3
- Views: 187
Re: Column sum wrong number format in table view
Hi,
you can set
in the hooks/footer-extras.php
this will prevent changing the sum field.
you can set
Code: Select all
<script>
AppGini.noLocaleFormatting=true;
</script>
this will prevent changing the sum field.
- 2023-02-05 08:49
- Forum: Getting Started
- Topic: Trying to read src attribute of img tag
- Replies: 1
- Views: 304
Re: Trying to read src attribute of img tag
Hi,
Appgini will call the the display of the table, TV after a delete happend, so your script will not be executed.
Appgini will call the the display of the table, TV after a delete happend, so your script will not be executed.
- 2023-02-04 08:27
- Forum: Getting Started
- Topic: Trying to relocate image to another folder
- Replies: 2
- Views: 203
Re: Trying to relocate image to another folder
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...
- 2023-01-30 19:01
- Forum: Advanced Customizations > Hooks
- Topic: $options->QueryFrom & INNER JOIN
- Replies: 8
- Views: 454
Re: $options->QueryFrom & INNER JOIN
Hi,
try
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.
try
Code: Select all
$options->QueryFrom = ' `u05_tank` INNER JOIN `membership_users` ON `u05_tank`.`username` = `membership_users`.`memberID`';
- 2023-01-19 20:49
- Forum: Advanced Customizations > Hooks
- Topic: New Action Button
- Replies: 1
- Views: 185
Re: New Action Button
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...
- 2023-01-14 21:46
- Forum: Getting Started
- Topic: How to create thumbnail photos after the fact?
- Replies: 8
- Views: 400
Re: How to create thumbnail photos after the fact?
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...
- 2023-01-14 12:19
- Forum: Getting Started
- Topic: How to create thumbnail photos after the fact?
- Replies: 8
- Views: 400
Re: How to create thumbnail photos after the fact?
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, ...
- 2023-01-08 15:19
- Forum: Advanced Customizations > Hooks
- Topic: Hiding columns from non-owners
- Replies: 17
- Views: 1439
Re: Hiding columns from non-owners
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('...
- 2023-01-08 15:09
- Forum: Bugs/annoyances
- Topic: Save As Copy Not Working (child records)
- Replies: 29
- Views: 1448
Re: Save As Copy Not Working (child records)
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?
- 2023-01-08 15:08
- Forum: Feature Suggestions
- Topic: Multi select dropdown
- Replies: 3
- Views: 281
Re: Multi select dropdown
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 ...
- 2023-01-07 20:28
- Forum: Feature Suggestions
- Topic: Multi select dropdown
- Replies: 3
- Views: 281
Re: Multi select dropdown
Hi,
maybe this helps you as a starting point.
https://bigprof.com/blog/appgini/a-work ... gini-apps/
maybe this helps you as a starting point.
https://bigprof.com/blog/appgini/a-work ... gini-apps/
- 2023-01-07 19:47
- Forum: Bugs/annoyances
- Topic: Save As Copy Not Working (child records)
- Replies: 29
- Views: 1448
Re: Save As Copy Not Working (child records)
Maybe you can check the server logs (webserver) to identify if there is an error
- 2023-01-07 19:29
- Forum: Bugs/annoyances
- Topic: Save As Copy Not Working (child records)
- Replies: 29
- Views: 1448
Re: Save As Copy Not Working (child records)
is the CURLOPT_SSL_VERIFYPEER set to 1 or 0 ?
if 0 then it will probably not be the issue.
if 0 then it will probably not be the issue.
- 2023-01-07 18:54
- Forum: Bugs/annoyances
- Topic: Save As Copy Not Working (child records)
- Replies: 29
- Views: 1448
Re: Save As Copy Not Working (child records)
That sounds like the causing issue. Can you revert on the server to an older version?
- 2023-01-07 18:01
- Forum: Bugs/annoyances
- Topic: Save As Copy Not Working (child records)
- Replies: 29
- Views: 1448
Re: Save As Copy Not Working (child records)
Hi Ray,
can you dump you PHP version to verify that this is still the same than the one you have localy.
can you dump you PHP version to verify that this is still the same than the one you have localy.
- 2023-01-07 10:28
- Forum: Advanced Customizations > Others
- Topic: Send a SMS with text
- Replies: 3
- Views: 236
Re: Send a SMS with text
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...
- 2023-01-07 08:50
- Forum: Bugs/annoyances
- Topic: Save As Copy Not Working (child records)
- Replies: 29
- Views: 1448
Re: Save As Copy Not Working (child records)
Hi Ray,
first question: Did you change anything? Re-loaded the app, or anything else?
first question: Did you change anything? Re-loaded the app, or anything else?
- 2023-01-06 22:10
- Forum: Advanced Customizations > Others
- Topic: Send a SMS with text
- Replies: 3
- Views: 236
Re: Send a SMS with text
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 ...
- 2023-01-03 10:22
- Forum: Advanced Customizations > Hooks
- Topic: Scrollable table in DV-TV
- Replies: 4
- Views: 800
Re: Scrollable table in DV-TV
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.
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.
- 2022-12-24 15:42
- Forum: Tips And Tricks
- Topic: Not Empty field message
- Replies: 4
- Views: 477
Re: Not Empty field message
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?
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?