Search found 376 matches

by pböttcher
2019-04-18 13:04
Forum: Advanced Customizations > Hooks
Topic: Show/Hide field based on lookup
Replies: 4
Views: 60

Re: Show/Hide field based on lookup

Hi, not sure what the issue is. Every selection (apart "Safety Concern") will hide the ScID. Only if you select the Safety Concern, it will be shown. This does of course not work for the initial load of the page, as you react with the "on('change'..) only on changes to the fieldvalue. If you want to...
by pböttcher
2019-04-18 10:07
Forum: Getting Started
Topic: Custom Filters
Replies: 11
Views: 175

Re: Custom Filters

Hi,

can you change the SQL to :

SELECT `companies`.`id`, `companies`.`name` FROM `companies` ORDER BY 2

and try again.

Why do you need user_categories and countries in your SQL?
by pböttcher
2019-04-17 19:32
Forum: Getting Started
Topic: Custom Filters
Replies: 11
Views: 175

Re: Custom Filters

Hi,

sorry to ask again,

can you please post the SQL for the company_id field, as I assume that this is the one which causes the auto-fill.
by pböttcher
2019-04-17 19:31
Forum: Advanced Customizations > Hooks
Topic: Show/Hide field based on lookup
Replies: 4
Views: 60

Re: Show/Hide field based on lookup

Hi Kevin, if you need only to check for the change you can use: $j(function(){ $j('#My_Field').on('change', function(){ var IR = $j('#s2id_My_Field-container .select2-chosen').text()); if(IR == 'MYVALUE'){ $j('#ScID').parents('.form-group').show(); }else{ $j('#ScID').parents('.form-group').hide(); }...
by pböttcher
2019-04-16 18:28
Forum: Getting Started
Topic: Custom Filters
Replies: 11
Views: 175

Re: Custom Filters

Hi,

thanks, can you show which fields map to the CATEGORY and COUNTRY in you APPGini Setting, also can you post the SQL statement.
Unbenannt.GIF
Unbenannt.GIF (57.81 KiB) Viewed 83 times
by pböttcher
2019-04-15 17:28
Forum: Getting Started
Topic: Custom Filters
Replies: 11
Views: 175

Re: Custom Filters

Hi,

can you post the query you have in the lookup for the field where the user selects the company.
by pböttcher
2019-04-12 20:58
Forum: Getting Started
Topic: Custom Filters
Replies: 11
Views: 175

Re: Custom Filters

Hi, as a guess, in the page you show, there is no category-id but you refere to that this should be the selected Item to use for the auto-fill, so your query joins all companies to all categories which give these multiples. What would you like the user to see here? For what would this entry be used?
by pböttcher
2019-04-12 20:53
Forum: Advanced Customizations > Hooks
Topic: Email Membership Group
Replies: 8
Views: 205

Re: Email Membership Group

Hi, can you try $res=SQL("SELECT email FROM `membership_users` where where custom2='Position'",$eo); $name=""; while($row = db_fetch_assoc($res)) { $name=$name.";".$row['email']; } $name=ltrim($name, ';'); sendmail(array( 'to' => $name, 'name' => "siteadmin@mydomain.com", 'subject' => "A record in t...
by pböttcher
2019-04-11 18:37
Forum: Getting Started
Topic: Blank page when trying to download CSV
Replies: 2
Views: 86

Re: Blank page when trying to download CSV

Hi,

do you habe any hook-code in you application. It could be that there is a SQL error and that causes the page to be displayed blank.
by pböttcher
2019-04-11 18:32
Forum: Advanced Customizations > Hooks
Topic: sum AUTO-FILL
Replies: 1
Views: 64

Re: sum AUTO-FILL

Hi,

have a look at

https://forums.appgini.com/phpbb/viewto ... 9368#p9368

per default the SUM of AUTO-FILL does not work
by pböttcher
2019-04-11 18:30
Forum: Advanced Customizations > Others
Topic: External Link in Modal Window
Replies: 3
Views: 132

Re: External Link in Modal Window

<div> <a class="btn bootpopup" title="This is title" target="popupModal2">Open modal</a> Hi, I think this is a little bit more complex. You can try to add this: <a class="alert bootpopup" title="Test" data-target="modal" data-toggle="modal">Help link here</a> <div id="popupModal" class="modal fade" ...
by pböttcher
2019-04-10 11:34
Forum: Getting Started
Topic: disable row editing if a field is equal to....
Replies: 7
Views: 112

Re: disable row editing if a field is equal to....

Hi,
yes of course, but this was not part of the question :-)

If you want to disable the DV for a particular setting, you can do this as well via the hooks
by pböttcher
2019-04-10 08:48
Forum: Advanced Customizations > Hooks
Topic: Readonly, but not for a specific group
Replies: 25
Views: 252

Re: Readonly, but not for a specific group

In chrome press F12 and look at the consol-tab
by pböttcher
2019-04-08 21:39
Forum: Advanced Customizations > Hooks
Topic: Readonly, but not for a specific group
Replies: 25
Views: 252

Re: Readonly, but not for a specific group

Hi,
what browser are you using? Can you post a screenshot of the debugger that shows your fields.
by pböttcher
2019-04-08 21:37
Forum: Getting Started
Topic: disable row editing if a field is equal to....
Replies: 7
Views: 112

Re: disable row editing if a field is equal to....

Hi,

you can try this:

$j('td.TABLE-FIELD :contains({VALUE})').parent().find('a').each(function () { $j(this).removeAttr("onclick").removeAttr("href") } )

Where you replace TABLE, FIELD and VALUE according to your needs
by pböttcher
2019-04-08 07:24
Forum: Advanced Customizations > Hooks
Topic: Readonly, but not for a specific group
Replies: 25
Views: 252

Re: Readonly, but not for a specific group

Hi,

try

$j("#ELEMENT-container").attr('disabled',true);

where you replace ELEMENT by the name of your dropdown.

For checkboxes you should use the same as for an input field.
$j("#ELEMENT").attr('disabled',true);
by pböttcher
2019-04-07 18:22
Forum: Advanced Customizations > Hooks
Topic: Readonly, but not for a specific group
Replies: 25
Views: 252

Re: Readonly, but not for a specific group

Hi,

you need to refere to $memberInfo not $mi in your code.
by pböttcher
2019-04-07 15:24
Forum: Advanced Customizations > Hooks
Topic: Readonly, but not for a specific group
Replies: 25
Views: 252

Re: Readonly, but not for a specific group

Hi again,

after reviewing your screenshot, I think you need to put the "EOC" for the end delimiting at the start of the line without tabs. The screenshot shows two tabs. You may try this as well.
by pböttcher
2019-04-07 15:01
Forum: Advanced Customizations > Hooks
Topic: Readonly, but not for a specific group
Replies: 25
Views: 252

Re: Readonly, but not for a specific group

Hmmm, strange, can you try this: function Participants_dv($selectedID, $memberInfo, &$html, &$args){ if($mi['group'] != 'Admins'){ ob_start(); ?> <script> $j(function(){ $j('#Email').prop('readonly', 'readonly'); }) </script> <?php $new_layout = ob_get_contents(); ob_end_clean(); $html .= $new_layou...
by pböttcher
2019-04-07 13:57
Forum: Advanced Customizations > Hooks
Topic: Readonly, but not for a specific group
Replies: 25
Views: 252

Re: Readonly, but not for a specific group

Hi,
your first version is fine, but the error seems to indicate that there is something wrong with your HEREDOC.
Can you please verify that there is no extra character after the HEREDOC "EOC" in your first version.
by pböttcher
2019-04-07 06:36
Forum: Advanced Customizations > Hooks
Topic: Readonly, but not for a specific group
Replies: 25
Views: 252

Re: Readonly, but not for a specific group

Hi,

maybe you describe a litte more what your need is (shown by a screenshot helps a lot).
by pböttcher
2019-04-06 19:22
Forum: Advanced Customizations > Hooks
Topic: Readonly, but not for a specific group
Replies: 25
Views: 252

Re: Readonly, but not for a specific group

Hi, if it is for one field only I would guess that this is not possible via the AppGini Console. Also be aware that if you set a field to readonly via the AppGini console, that field is not getting saved to the database, even if you change the fieldvalue via script (Unless you hook the SQL to store ...
by pböttcher
2019-04-05 06:45
Forum: Advanced Customizations > Hooks
Topic: Changing Color - Has anyone got this to work?
Replies: 7
Views: 199

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

Hi,

try

Code: Select all

$header="<%%HEADER%%><script>\$j(function(){
\$j('.tablename-fieldname').each(function(){
if(\$j(this).text() == 'Important'){
\$j(this).parent().addClass('danger');
}
})
})</script>";
by pböttcher
2019-04-04 20:12
Forum: Advanced Customizations > Hooks
Topic: Email Membership Group
Replies: 8
Views: 205

Re: Email Membership Group

Hi, if you want to send an email after a record has been created, use the after_insert function, if you want to send the mail after a record has been updated, use the after_update function. In your SQL you just need to retrieve the e-mail address for the users with the $memberInfo['custom'][1] = YO...
by pböttcher
2019-04-04 17:35
Forum: Advanced Customizations > Others
Topic: Import CSV as ordinary user
Replies: 2
Views: 136

Re: Import CSV as ordinary user

Hi, I copied the pageUploadCSV.php to the root directory and replaced $currDir = dirname(__FILE__); require("{$currDir}/incCommon.php"); by $app_dir = dirname(__FILE__); if(!defined('PREPEND_PATH')) define('PREPEND_PATH', ''); include("$app_dir/defaultLang.php"); include("$app_dir/language.php"); in...