Search found 330 matches

by pböttcher
2019-02-12 20:21
Forum: Getting Started
Topic: Batch actions
Replies: 7
Views: 182

Re: Batch actions

Hi,

maybe you explain a little bit in detail what you try to acheive, so there might be another solution.
by pböttcher
2019-02-12 16:17
Forum: Getting Started
Topic: Batch actions
Replies: 7
Views: 182

Re: Batch actions

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...
by pböttcher
2019-02-08 21:59
Forum: Feature Suggestions
Topic: Linking two databases.
Replies: 4
Views: 213

Re: Linking two databases.

Hi,

I dont think AppGini is designed (at this point) to support multiple databases.
by pböttcher
2019-02-08 21:57
Forum: Getting Started
Topic: mask CPF e Tel
Replies: 4
Views: 170

Re: mask CPF e Tel

Hi,

what do you try to acheive. Can you make an example?
by pböttcher
2019-02-08 20:40
Forum: Getting Started
Topic: hide a field
Replies: 3
Views: 86

Re: hide a field

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> <?...
by pböttcher
2019-02-08 07:56
Forum: Getting Started
Topic: hide a field
Replies: 3
Views: 86

Re: hide a field

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?
by pböttcher
2019-02-07 09:42
Forum: Advanced Customizations > Others
Topic: Single entry a registered user
Replies: 7
Views: 141

Re: Single entry a registered user

Don't set it to read only, hide it in detailview and tableview.
by pböttcher
2019-02-07 07:54
Forum: Feature Suggestions
Topic: Linking two databases.
Replies: 4
Views: 213

Re: Linking two databases.

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>...
by pböttcher
2019-02-04 10:16
Forum: Getting Started
Topic: Look-up field problem
Replies: 2
Views: 126

Re: Look-up field problem

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...
by pböttcher
2019-01-26 08:36
Forum: Advanced Customizations > Others
Topic: Font Color changes when value changes
Replies: 11
Views: 320

Re: Font Color changes when value changes

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?
by pböttcher
2019-01-25 21:13
Forum: Advanced Customizations > Others
Topic: Separate individual Child tables from the Child Tables tabs?
Replies: 5
Views: 178

Re: Separate individual Child tables from the Child Tables tabs?

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"...
by pböttcher
2019-01-24 20:25
Forum: Advanced Customizations > Hooks
Topic: Disable all links in a table (tableview) row
Replies: 3
Views: 233

Re: Disable all links in a table (tableview) row

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.
by pböttcher
2019-01-24 20:07
Forum: Advanced Customizations > Others
Topic: Separate individual Child tables from the Child Tables tabs?
Replies: 5
Views: 178

Re: Separate individual Child tables from the Child Tables tabs?

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...
by pböttcher
2019-01-20 16:52
Forum: Getting Started
Topic: Aligning integer field data
Replies: 8
Views: 270

Re: Aligning integer field data

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 ...
by pböttcher
2019-01-14 18:29
Forum: Tips And Tricks
Topic: SUM lookup column ?
Replies: 11
Views: 360

Re: SUM lookup column ?

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.
by pböttcher
2019-01-13 21:12
Forum: Getting Started
Topic: Aligning integer field data
Replies: 8
Views: 270

Re: Aligning integer field data

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.
by pböttcher
2019-01-13 17:57
Forum: Tips And Tricks
Topic: SUM lookup column ?
Replies: 11
Views: 360

Re: SUM lookup column ?

Yes, please try this.
by pböttcher
2019-01-13 13:15
Forum: Tips And Tricks
Topic: SUM lookup column ?
Replies: 11
Views: 360

Re: SUM lookup column ?

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.
by pböttcher
2019-01-12 18:58
Forum: Tips And Tricks
Topic: SUM lookup column ?
Replies: 11
Views: 360

Re: SUM lookup column ?

Hi,

can you post the code you put in your app? Also a screenshot of what you try to acheive?
by pböttcher
2019-01-10 22:24
Forum: Bugs/annoyances
Topic: Change table sorting
Replies: 4
Views: 113

Re: Change table sorting

Hi,

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

Can you check in AppGini
date.gif
date.gif (10.84 KiB) Viewed 102 times
by pböttcher
2019-01-10 21:35
Forum: Bugs/annoyances
Topic: Change table sorting
Replies: 4
Views: 113

Re: Change table sorting

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?
by pböttcher
2019-01-10 21:27
Forum: Tips And Tricks
Topic: SUM lookup column ?
Replies: 11
Views: 360

Re: SUM lookup column ?

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...
by pböttcher
2019-01-10 20:24
Forum: Getting Started
Topic: Can $homeLinks[] reside in a Table Group on their own
Replies: 1
Views: 73

Re: Can $homeLinks[] reside in a Table Group on their own

Hi,

I think this is the default. An empty table group is not displayed, same as an empty entry in the nav-bar.
by pböttcher
2019-01-06 12:56
Forum: Getting Started
Topic: Lookup field, advanced SQL edit, memberInfo
Replies: 5
Views: 202

Re: Lookup field, advanced SQL edit, memberInfo

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.