Search found 42 matches

by kbarrett
2019-04-18 21:00
Forum: Advanced Customizations > Hooks
Topic: Show/Hide field based on lookup
Replies: 4
Views: 63

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: 63

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: 213

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: 63

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: 213

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: 213

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: 46

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: 213

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: 134

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: 201

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: 134

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: 201

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: 213

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: 201

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: 192

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: 192

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: 201

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: 201

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: 213

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: 213

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: 84

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: 84

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...
by kbarrett
2019-04-02 21:08
Forum: Advanced Customizations > Hooks
Topic: Show filering
Replies: 3
Views: 84

Show filering

Hello All, Using AppGini 5.75 in and working in MyTable.php in Hooks. I am trying to limit the ability to filter tables by position. I have added Position as memberInfo['custom'][1]. The problem I have is being able to add multiple positions. I used the code below in the function MyTable_init(&$opti...
by kbarrett
2019-04-02 17:59
Forum: Advanced Customizations > Others
Topic: Appgini SideMenu Layout Mod
Replies: 20
Views: 5228

Re: Appgini SideMenu Layout Mod

Yes please x 2
by kbarrett
2019-04-02 17:58
Forum: Bugs/annoyances
Topic: Upper and lower case lettering
Replies: 4
Views: 192

Re: Upper and lower case lettering

Hi,

Thanks for that. I am likely going to drop the table, reload everything after I make that change on the home server.

Kevin