AppGini Community Forums

Hi,

maybe you explain a little bit in detail what you try to acheive, so there might be another solution.

Hi, not sure what exactly you try to acheive, but maybe you can try: var TempVar = document.createElement("textarea"); document.body.appendChild(TempVar); TempVar.textcontent = this.responseText; TempVar.focus(); TempVar.setSelectionRange(0, target.value.length); document.execCommand("copy"); docume...

Hi,

I dont think AppGini is designed (at this point) to support multiple databases.

Hi,

what do you try to acheive. Can you make an example?

Hi, you can try this in the hooks/<tablename>.php file into the <tablename>_dv function the following: function <tablename>_dv($selectedID, $memberInfo, &$html, &$args){ if ($memberInfo['group'] == 'GROUPTOHIDE') { ob_start(); ?> <script> $j('label[for="Observacao"]').parent().detach(); </script> <?...

Hi,

can you please explain a little more detailed what you try to acheive. Do you want to hide the field in the TableView and/or in the DetailView?

Don't set it to read only, hide it in detailview and tableview.

Hi, you could try to grant access to the second db and the use it in a custom query. to grant access use as root in your DB: GRANT select ON DB2.* TO DB1@localhost; FLUSH PRIVILEGES; as a custom query you can address the DB2 like: select <tablename_db2>.<id>, <tablename_db2>.<field> from <tablename>...

Hi, I would guess that your SQL query fails. That's why you get the twirling image. Try replacing SELECT `all_contacts`.`contact_ID`, `all_contacts`.`company` FROM `all_contacts` WHERE `all_contacts`.`contact_type` = `Customer` ORDER BY 2 by SELECT `all_contacts`.`contact_ID`, `all_contacts`.`compan...

Glad to see it is working

Hi,

can you explain a little bit in more detail where you want the font to change color. Is it in the tableview? Detailview? Is it when you enter your data in the detailview?
When are you running the php you posted to calculate the balance_supply?

ok, so if you do not want to hide :-) you can try to add this after the </ul>: <script> $j(function(){ post("parent-children.php", { ChildTable: "PARENTTABLE", ChildLookupField: "PARENTFIELD", SelectedID: $j("[name=SelectedID]").val(), Page: 1, SortBy: "", SortDirection: "", Operation: "get-records"...

Hi,

just a suggestion. If you want you can also add to the detailview a check if your specific value for the ID passed matches your "dont show the details" (=600 in your sample), redirect the user to the tableview.

Hi, if editing the parent_templateDV.html does not matter, you can try putting this in instead. <ul class="nav nav-tabs"> <li class="active"><a href="#panel_PARENTTABLE-PARENTFIELD" id="tab_PARENTTABLE-PARENTFIELD" data-toggle="tab" aria-expanded="true">PARENTTABLE</a></li> <div id="panel_PARENTTABL...

Hi, maybe you can try in the hooks/<tablename>.php -> tablename_header function: switch($contentType){ case 'tableview': $header="<%%HEADER%%><script type=\"text/javascript\"> \$j(function(){ \$j('td.TABLENAME-FIELD*').addClass('text-left'); }); </script>"; Where TABLENAME is your tablename :-) and ...

Hi,

can you run the SQL directly on the database? Do you get the correct sum? if this is not the case,
can you check if the table pasirinkimai contains the primary key id. Maybe it is named differently.

Hi,

if you have a look at

templates\caves_templateTV.html (I assume your table is named caves)

You will find the class text-right being part of your integer fields. If you remove this, you should see the numbers left aligned.

Yes, please try this.

Hi,
can you please verify/confirm if you have another column which has the "Show column sum" set.
If you do not have another one, AppGini will not create the row displaying the sum at the bottom of your table.

Hi,

can you post the code you put in your app? Also a screenshot of what you try to acheive?

Hi,

it looks like you have a sort order of month-day-year.

Can you check in AppGini

Hi,

what is the dateformat -> order that you have set in AppGini for your project (App)? Maybe that is the source.
Did you have only records for 2018 yet in your table?

Hi, I think per default, only real values (no lookup values) are considered for the sum. You can try this if you want to get the sum of your lookup field. In the hooks/<TABLENAME>.php file, go the the <TABLENAME>_header function and put in the case tableview statement case 'tableview': $sum=sqlvalue...

Hi,

I think this is the default. An empty table group is not displayed, same as an empty entry in the nav-bar.

Hi,

I don't think this is possible through the customization (advance SQL) as the memberInfo is not available at the time you need it.