Search found 296 matches

by pböttcher
2018-12-09 15:06
Forum: Advanced Customizations > Others
Topic: Keep Table Group Expanded at the Startup(to be controlled by user)
Replies: 2
Views: 147

Re: Keep Table Group Expanded at the Startup(to be controlled by user)

Hi, you can try to add this to your hooks/footer-extras.php. Note, this is no full code, only the idea ## get the "keep Expanded" Checkbox status for your tablegroup. KeepExpanded = value of checkbox for LABEL If (KeepExpanded == 1) // Keep Expanded checkbox is checked { $j('a:contains("LABEL")').cl...
by pböttcher
2018-12-06 21:17
Forum: Tips And Tricks
Topic: put the data of 2 different tables that are related
Replies: 1
Views: 77

Re: put the data of 2 different tables that are related

Hi,

maybe this can help already

Code: Select all

http://bigprof.com/appgini/tips-and-tutorials/two-tables-same-page
by pböttcher
2018-11-22 12:21
Forum: Getting Started
Topic: Multiple Child tables per Parent table
Replies: 3
Views: 94

Re: Multiple Child tables per Parent table

Hi, what you need to do is to create a table (through AppGini), let call ist my_view. Next you specify all the fields that you want to have in this table (which would be the sum of your child tables) and generate your app. Now you need to go to your database, drop the table (my_view) and create a vi...
by pböttcher
2018-11-22 10:43
Forum: Getting Started
Topic: Have a trigger to Auto Create a Database Table
Replies: 6
Views: 210

Re: Have a trigger to Auto Create a Database Table

Hi, I think this is not possible with the nature of AppGini. AppGini uses either an exisiting database and you specify through the GUI how the behaviour for the fields should be (e.g. lookup-field, or download, etc). Or you create your tables and fields through AppGini and once done you will create ...
by pböttcher
2018-11-22 06:33
Forum: Getting Started
Topic: Have a trigger to Auto Create a Database Table
Replies: 6
Views: 210

Re: Have a trigger to Auto Create a Database Table

Hi, just to understand. If you create a table for each new user (programatically), how would you access these tables through your application. AppGini would not know about those tables. As a suggestion: you could check if the table already exists in the database for the currently logged in user, and...
by pböttcher
2018-11-22 06:28
Forum: Getting Started
Topic: Multiple Child tables per Parent table
Replies: 3
Views: 94

Re: Multiple Child tables per Parent table

Hi,

why dont you use a view, rather than replicate all information from the childs?
by pböttcher
2018-11-22 06:27
Forum: Getting Started
Topic: Link or join tables
Replies: 7
Views: 1357

Re: Link or join tables

Hi,

looks like you managed to find how to create a new post 8-) :

https://forums.appgini.com/phpbb/viewto ... dd09dc90a3
by pböttcher
2018-11-19 20:34
Forum: Getting Started
Topic: Upload with a special file name
Replies: 3
Views: 188

Re: Upload with a special file name

Hi, you can try this: add a function to the hooks/tablename.php file and edit the after_insert and after_update functions: function update_filename($id) { if (!$_REQUEST['file_remove']) { $dir = getUploadDir($dir); $extension=pathinfo($data['Document'], PATHINFO_EXTENSION); if ($extension != '') $ex...
by pböttcher
2018-11-16 13:12
Forum: Getting Started
Topic: How to specify URL to a tab
Replies: 14
Views: 159

Re: How to specify URL to a tab

Hi, basically correct, but I would do it rather generic. Something like: var url_string = window.location.href; var idx=url_string.indexOf("#"); if (idx > 0) { $j('.nav-tabs a[href="'+url_string.substring(idx)+'"]').tab('show'); } would check if the URL contains the # sign and show the according tab...
by pböttcher
2018-11-16 11:31
Forum: Getting Started
Topic: How to specify URL to a tab
Replies: 14
Views: 159

Re: How to specify URL to a tab

Hi, you will need to check the calling url, otherwise it will always redirect.
by pböttcher
2018-11-16 10:25
Forum: Getting Started
Topic: How to specify URL to a tab
Replies: 14
Views: 159

Re: How to specify URL to a tab

Hi,

can you try $j('.nav-tabs a[href="#address-info"]').tab('show');
by pböttcher
2018-11-16 08:21
Forum: Getting Started
Topic: How to specify URL to a tab
Replies: 14
Views: 159

Re: How to specify URL to a tab

put it in the hooks/eng_firms-dv.js file (if it exisits, or create it). You may need to test if the tabs are already loaded, not sure right now in which order that happens, can't test it now.
by pböttcher
2018-11-15 17:06
Forum: Getting Started
Topic: How to specify URL to a tab
Replies: 14
Views: 159

Re: How to specify URL to a tab

Hi, I'll try to give it a shot. I think, as the page is recreated with tabs after the initial call, you will not be able to get directly to a tab, but if you use the information in the URL and use javascript, you should be able to extract the "#...." information which indicates to which tab you want...
by pböttcher
2018-11-15 16:58
Forum: Advanced Customizations > Hooks
Topic: AUTO CALCULATION WHILE TEXT CHANGE EVENT
Replies: 2
Views: 117

Re: AUTO CALCULATION WHILE TEXT CHANGE EVENT

Hi, you need to do this via Javascript (here in combination with jquery). You can put the code in the <tablename>-dv.js file in the hooks folder. You need to so something like: $j('#taxalbleamount').on('change', function () { var tax=+($j('#taxalbleamount').val()); $j('#cgst').val(tax*1.5/100); $j('...
by pböttcher
2018-11-14 14:30
Forum: Advanced Customizations > Hooks
Topic: add a next button to form.
Replies: 3
Views: 144

Re: add a next button to form.

Hi, this would work if you have only 2 tabs. If you want you can make it a bit more generic if you have more tabs to navigate through. You can put the code (with the button creation code) in the hooks folder to the tablename-dv.js file, so it will not be overwritten once you recreate the code. $j('#...
by pböttcher
2018-11-14 07:37
Forum: Advanced Customizations > Hooks
Topic: Getting Jquery to call Function In Hooks file
Replies: 1
Views: 85

Re: Getting Jquery to call Function In Hooks file

Hi, if you want to use jquery you would need to add an ajax call to a php file which would contain your SQL statement to be executed. You cannot directly call a function (not without additional work). Just another idea: Why dont you add a checkbox field that would indicate that you want to update yo...
by pböttcher
2018-11-14 07:35
Forum: Advanced Customizations > Others
Topic: Select columns for CSV output
Replies: 4
Views: 129

Re: Select columns for CSV output

Sorry, I do not have the spm. But you could dump the $query content and have a look what is stored in there to see if the filter information is there.
by pböttcher
2018-11-06 17:18
Forum: Advanced Customizations > Hooks
Topic: Filter table with closed date > 21 days ago
Replies: 8
Views: 376

Re: Filter table with closed date > 21 days ago

Hi,
sorry I forgot to state that you need to adjust the filter to match your date field. In my sample I used field nr. 21, but yours is for sure different.

FilterField%5B8%5D=21
by pböttcher
2018-11-06 14:08
Forum: Advanced Customizations > Hooks
Topic: Filter table with closed date > 21 days ago
Replies: 8
Views: 376

Re: Filter table with closed date > 21 days ago

Hi you can try this: $filterdate= date('Y-m-d',strtotime('-21 days')); $navLinks[] = array( 'url' => 'http:xxxxxxxxxxxxxxxxxxxxxx/WDCD_view.php?SortField=8&SortDirection=asc&FilterAnd%5B1%5D=&FilterField%5B1%5D=8&FilterOperator%5B1%5D=like&FilterValue%5B1%5D=CD&FilterAnd%5B2%5D=and&FilterField%5B2%5...
by pböttcher
2018-11-06 09:42
Forum: Getting Started
Topic: lookup name in same table
Replies: 4
Views: 145

Re: lookup name in same table

Hi,

for a lookup you need to have the ID of the record and then the displayed information to be returned in the SQL query.

So in this case I assume you should try

Code: Select all

SELECT ID, Concat_Ws(' ',Firstname, Lastname) AS fullname FROM Employees WHERE Ismanager = TRUE
by pböttcher
2018-11-05 09:34
Forum: Getting Started
Topic: Link or join tables
Replies: 7
Views: 1357

Re: Link or join tables

Hi Richard,

can you please start a new post with your question as it is not related to this one.
Aslo it would be helpful if you show a screenshot of what you try to acheive.
by pböttcher
2018-11-05 09:29
Forum: Getting Started
Topic: lookup name in same table
Replies: 4
Views: 145

Re: lookup name in same table

Hi,

it depends on what you want to do, but usually you would display the concatenation of the firstname + surname as a lookup in AppGini. In your case you need to enhance the standard lookup with your where clause.
by pböttcher
2018-10-29 16:13
Forum: Advanced Customizations > Hooks
Topic: Filter table with closed date > 21 days ago
Replies: 8
Views: 376

Re: Filter table with closed date > 21 days ago

Hi,
what kind of filter are you looking for? Can you show an example.
by pböttcher
2018-10-29 16:11
Forum: Bugs/annoyances
Topic: Highlighting Specific Records
Replies: 2
Views: 143

Re: Highlighting Specific Records

Hi,

can you try to initialize your arrary and see.

Change
$options->QueryFieldsTV='';
to
$options->QueryFieldsTV=[];