Search found 45 matches

by kbarrett
2019-05-24 20:21
Forum: Getting Started
Topic: Child Tables Settings
Replies: 7
Views: 254

Re: Child Tables Settings

Uchhavi,

Have you tried hiding the child table in detail view?
by kbarrett
2019-05-03 14:19
Forum: Getting Started
Topic: Online Database Backup
Replies: 8
Views: 340

Re: Online Database Backup

Hi Uchavi, You can FTP into your server and download it no different that if you had created the application on your local machine, did a back up and uploaded to your server. When you FTP into your server switch to the directory where your app is located, switch to the admin folder then backup. You ...
by kbarrett
2019-04-30 15:23
Forum: Getting Started
Topic: Online Database Backup
Replies: 8
Views: 340

Re: Online Database Backup

Uchavi, Here is a blog link that provides instruction on moving your app to a server. In it there is instructions on using the back up process within the the AppGini generated app: https://bigprof.com/blog/appgini/moving-an-appgini-application-to-a-new-server/ An easy process that essentially automa...
by kbarrett
2019-04-18 21:00
Forum: Advanced Customizations > Hooks
Topic: Show/Hide field based on lookup
Replies: 4
Views: 165

Re: Show/Hide field based on lookup

Yes,

Once I click on the drop down the field disappears and doesn't come back. LOL.
by kbarrett
2019-04-17 19:55
Forum: Advanced Customizations > Hooks
Topic: Show/Hide field based on lookup
Replies: 4
Views: 165

Re: Show/Hide field based on lookup

Hi, I substituted my values and it works in reverse, every selection hides the ScID field. Ideally the field stays hidden and selecting 'Safety Concern' shows the ScID field: $j(function(){ $j('#Inspection_Reason').on('change', function(){ var IR = $j('#s2id_Inspection_Reason-container .select2-chos...
by kbarrett
2019-04-17 18:53
Forum: Advanced Customizations > Hooks
Topic: Email Membership Group
Replies: 8
Views: 347

Re: Email Membership Group - Solved

To close this string. With a lot of incredible assistance from PBoettcher the following code will work in both the after_insert and after_update sections of the hook file: function My_Table_after_insert($data, $memberInfo, &$args){ $res=SQL("SELECT email FROM `membership_users` where custom2='{$data...
by kbarrett
2019-04-17 18:48
Forum: Advanced Customizations > Hooks
Topic: Show/Hide field based on lookup
Replies: 4
Views: 165

Show/Hide field based on lookup

Hi all, I likely am way of with this but I am trying to show hide a field or two based on one value from a lookup field. I thought I would create a tablename-dv.js file with the following code in it. I have tried both text and a numerical value of the text selection. Neither works: $j(document).read...
by kbarrett
2019-04-13 03:37
Forum: Advanced Customizations > Hooks
Topic: Email Membership Group
Replies: 8
Views: 347

Re: Email Membership Group

Here is the latest code I tried: $res=SQL("SELECT email FROM `membership_users` where custom2='Position'",$eo); $name=""; while($row = db_fetch_assoc($res)) { $name=$name.";".$row['email']; } $name=ltrim($name, ';'); sendmail(array( 'to' => $name, 'name' => "myemail@mysite", 'subject' => "A record i...
by kbarrett
2019-04-13 02:54
Forum: Advanced Customizations > Hooks
Topic: Email Membership Group
Replies: 8
Views: 347

Re: Email Membership Group

Hi,

I changed the appropriate values and it doesn't work. The pages doesn't load.
by kbarrett
2019-04-12 18:59
Forum: Advanced Customizations > Hooks
Topic: Set Table DV fields to readonly based on field value
Replies: 0
Views: 102

Set Table DV fields to readonly based on field value

Hello All, I have read numerous posts where users would like to see a record lock once a certain state is achieved. I have read and understand there are certain complexities and complications that can arise from this. I have a similar need but think it can be met if the right circumstances are enabl...
by kbarrett
2019-04-12 18:45
Forum: Advanced Customizations > Hooks
Topic: Email Membership Group
Replies: 8
Views: 347

Re: Still stuck

No solutions ?
by kbarrett
2019-04-11 20:46
Forum: Advanced Customizations > Others
Topic: External Link in Modal Window
Replies: 3
Views: 344

Re: External Link in Modal Window

Hi All, With PBoettcher's help I figured out a solution. Please keep in mind this is more than likely an unintended hack of what Ahmed and his team had originally considered or intended for the feature's use. Anyway in the table field description it is possible to launch a modal window using the fol...
by kbarrett
2019-04-11 19:12
Forum: Advanced Customizations > Hooks
Topic: Changing Color - Has anyone got this to work?
Replies: 7
Views: 332

Re: Changing Color - Has anyone got this to work?

So to conclude this string. I added a line to the common.js.php file to create an alert when the record he or she is creating results in a the value that would prompt a colour change. As a result the record is not accepted and the user has to go back and edit the record so the value is not produced....
by kbarrett
2019-04-10 19:23
Forum: Advanced Customizations > Others
Topic: External Link in Modal Window
Replies: 3
Views: 344

External Link in Modal Window

Hello Coding Gurus, Using AppGini V 5.75 I am hoping to add help files via a wiki from an external folder/site to my project. I know I could add to the field description but some of the explanations get wordy and a pop up modal window could provide an extra bit of assistance in many cases. I have tr...
by kbarrett
2019-04-10 17:44
Forum: Advanced Customizations > Hooks
Topic: Changing Color - Has anyone got this to work?
Replies: 7
Views: 332

Re: Changing Color - Has anyone got this to work?

Hello, Thanks for the console tip. I had a look one of the problems I had was a script that I had put in the footer-extras.php file to get Chrome to not cache the a javascript. I took it out, the detail view colour change works, the table view doesn't but I can live with it. I added an alert in the ...
by kbarrett
2019-04-09 19:59
Forum: Advanced Customizations > Hooks
Topic: Email Membership Group
Replies: 8
Views: 347

Re: Email Membership Group- Still stuck

I borrowed some code and have been trying to get it to work in place of my previous failed attempts. I can get the email to work from my last post above, it emails me fine. However I would like to email a group or the Position which is defined in $memberInfo['custom'][1] which is "Position". I have ...
by kbarrett
2019-04-09 19:55
Forum: Advanced Customizations > Hooks
Topic: Changing Color - Has anyone got this to work?
Replies: 7
Views: 332

Re: Changing Color - Has anyone got this to work? - Not working on server

Ok, No this is a mystery. The code suggested works perfectly as intended on my local Windows machine but when uploaded to my server it doesn't work. It's a Linux server running PHP Version 7.2.16 if that is any help. I have tried a few variations of the syntax such as upper and lower case names and ...
by kbarrett
2019-04-05 21:48
Forum: Bugs/annoyances
Topic: Upper and lower case lettering
Replies: 4
Views: 274

Re: Upper and lower case lettering

I found a work around in case any other newbie males the same mistake. Simply insert a letter beside the upper case letter, e.g. Tablename becomes Ttablename then click outside the corrected field. Once the highlight has disappeared, re-highlight (click twice) then delete the upper case character, e...
by kbarrett
2019-04-05 21:28
Forum: Bugs/annoyances
Topic: Upper and lower case lettering
Replies: 4
Views: 274

Re: Upper and lower case lettering

Yeah, it's a no go on the home server. Currently using linux Mint but will be switching it later on. It would still be nice to be able to rename tables in the AppGini application. The only choice it seems is to delete the table and start over from scratch which is certainly counter productive.
by kbarrett
2019-04-05 19:58
Forum: Advanced Customizations > Hooks
Topic: Changing Color - Has anyone got this to work?
Replies: 7
Views: 332

Re: Changing Color - Has anyone got this to work?

Hello,

Thanks to the both of you, the code that pbottcher supplied worked when I added the bootstrap class that jsetzer suggested. Thanks again.
by kbarrett
2019-04-04 21:12
Forum: Advanced Customizations > Hooks
Topic: Changing Color - Has anyone got this to work?
Replies: 7
Views: 332

Changing Color - Has anyone got this to work?

Hello All, using version 5.75 Has anyone got this to work? I have made several attempts and it doesn't work. And, yes I did substitute the tablename and fieldname. $header="<%%HEADER%%><script>\$j(function(){ \$j('td.tablename-fieldname').each(function(){ if(\$j(this).text() == 'Important'){ \$j(thi...
by kbarrett
2019-04-04 20:43
Forum: Advanced Customizations > Hooks
Topic: Email Membership Group
Replies: 8
Views: 347

Re: Email Membership Group

Hi, Thanks, I am a little slow at, well lots, anyway I tried to create a variable from the SQL query and name it Group for this code: // to compose a message containing the submitted data, // we need to iterate through the $data array foreach($data as $field => $value){ $messageData .= "$field: $val...
by kbarrett
2019-04-04 19:54
Forum: Advanced Customizations > Hooks
Topic: Email Membership Group
Replies: 8
Views: 347

Email Membership Group

Hello, I am trying to figure out a couple of more things to customize my project. One of them is I would like to email a subset of a group based on their $memberInfo['custom'][1] which is 'Position' once a record is changed in the table that pertains to their 'Position' I have tried a few different ...
by kbarrett
2019-04-03 00:50
Forum: Advanced Customizations > Hooks
Topic: Show filering
Replies: 3
Views: 158

Re: Show filtering

BAH!
Colour me thick! I figured it out! Many thanks again!

Kevin
by kbarrett
2019-04-02 22:22
Forum: Advanced Customizations > Hooks
Topic: Show filering
Replies: 3
Views: 158

Re: Show filering

Hi, Tried the code: switch($memberInfo['custom'][1]) { case "Manager": $options->AllowFilters=1; break; case "Director": SET OTHER OPTION; break; default: $options->AllowFilters=0; break; } but the following error string was returned: Parse error: syntax error, unexpected 'OPTION' (T_STRING) in C:\x...