AppGini Community Forums

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...

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?

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.

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(); }...

Hi,

thanks, can you show which fields map to the CATEGORY and COUNTRY in you APPGini Setting, also can you post the SQL statement.

Hi,

can you post the query you have in the lookup for the field where the user selects the company.

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?

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...

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.

Hi,

have a look at

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

per default the SUM of AUTO-FILL does not work

<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" ...

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

In chrome press F12 and look at the consol-tab

Hi,
what browser are you using? Can you post a screenshot of the debugger that shows your fields.

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

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);

Hi,

you need to refere to $memberInfo not $mi in your code.

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.

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...

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.

Hi,

maybe you describe a litte more what your need is (shown by a screenshot helps a lot).

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 ...

Hi,

try

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...

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...