Search found 55 matches

by Jay Webb
2019-08-14 19:07
Forum: Advanced Customizations > Others
Topic: Batch Action multi sources.
Replies: 7
Views: 122

Re: Batch Action multi sources.

Hi Jan; I don't want to sound ungrateful for the help or condescending, but I don't know what normalized model is, I'm doing all this as a favor for my Clan, I'm not a student or a programmer, I'm not doing it for a living, i'm a 62 year old guy who got was a bunch of data from 15+ people is various...
by Jay Webb
2019-08-14 14:49
Forum: Advanced Customizations > Others
Topic: Batch Action multi sources.
Replies: 7
Views: 122

Re: Batch Action multi sources.

Hi Jan, Great explanation, thanks for your help with this, I managed to get it and found limitation to using LEFT JOIN multi times on same table, spent all day reading and trying figure out how make this work; $sql = "SELECT `marriage`.*, COALESCE(`surname`.`surnames`, 'id') as 'surname1', COALESCE(...
by Jay Webb
2019-08-13 16:52
Forum: Advanced Customizations > Others
Topic: Batch Action multi sources.
Replies: 7
Views: 122

Re: Batch Action multi sources.

Hi Jan, Thank you for the assistance, I went with the recommended way with; $sql = "SELECT `marriage`.* , COALESCE(`surname`.`surnames`, 'id') as 'surname' FROM `marriage` LEFT JOIN `surname` ON `marriage`.`surname` = `surname`.`id` WHERE `marriage`.`id` in ({$cs_ids})"; $res = sql($sql, $eo); and t...
by Jay Webb
2019-08-13 04:53
Forum: Advanced Customizations > Others
Topic: Batch Action multi sources.
Replies: 7
Views: 122

Batch Action multi sources.

Hello All, I have a Batch Action that makes a datasheet from a table view that has several lookup fields which display at present there id's. "Red circles" here is my code; <?php $curr_dir = dirname(__FILE__); include("{$curr_dir}/defaultLang.php"); include("{$curr_dir}/language.php"); include("{$cu...
by Jay Webb
2019-08-06 04:54
Forum: Bugs/annoyances
Topic: Summary Reports bug
Replies: 0
Views: 96

Summary Reports bug

Ok, Summary Reports has bad path for header-extra. If I add background image to header-extra with an image path," hooks/images/image.png" Summary Reports throws an error bad path body background image shows path as "hooks/hooks/images/image.png" and therefor no background image. If I change path in ...
by Jay Webb
2019-08-03 19:17
Forum: AppGini Plugins
Topic: Summary Reports colums left default
Replies: 0
Views: 37

Summary Reports colums left default

Hi All, Trying to make columns alignment all left in Reports table by default and then if user would like different appearance they could still use the Report Configuration feature. It also would be nice if the text label for columns would also align with column choice instead of text label always b...
by Jay Webb
2019-08-02 16:21
Forum: Getting Started
Topic: Set a year limit to a required field.
Replies: 0
Views: 61

Set a year limit to a required field.

Hi All,
Is there a way to hook a cut of year to a field, so if a user inputs a value past the year 1930, it posts an error, like, "No records past 1930 accepted".
Hence the field "year" being required field whole table wont be updated.

Thanks
by Jay Webb
2019-07-30 21:30
Forum: Advanced Customizations > Hooks
Topic: Hide/show fields in Detail View
Replies: 12
Views: 138

Re: Hide/show fields in Detail View

Ok, I think this will work.

Image
Image
by Jay Webb
2019-07-30 20:02
Forum: Advanced Customizations > Hooks
Topic: Hide/show fields in Detail View
Replies: 12
Views: 138

Re: Hide/show fields in Detail View

Hi, Just spent the last hour and half normalizing my tables and fields as was being suggested. I made the change to name of radio button as shown in the console, even ran debugger and no change and debugger says it's all good. Here's what I got; function marriage_dv($selectedID, $memberInfo, &$html,...
by Jay Webb
2019-07-30 17:07
Forum: Advanced Customizations > Hooks
Topic: Hide/show fields in Detail View
Replies: 12
Views: 138

Re: Hide/show fields in Detail View

Hi pböttcher Wow, thanks for that code, I would have never figured that out as the method, I had to add the correct id's for none, 1,2,3, and, the fields hide, the only issue is the; $j("input[type=radio][name=marriages]").click(function(){ switch($j(this).val()) selecting one of the radios has no e...
by Jay Webb
2019-07-30 09:15
Forum: Advanced Customizations > Hooks
Topic: Hide/show fields in Detail View
Replies: 12
Views: 138

Re: Hide/show fields in Detail View

Hi Jan Yes, I have that as a look to table (Other Marriages) for all 4 lookup fields and all linked by FF Numbers (Family File Number) and having a lot of data entry fields I'd like to hide those to shorted the entry fields and show only if selected. I got to keep it simple as there will be 8 other ...
by Jay Webb
2019-07-30 05:52
Forum: Advanced Customizations > Hooks
Topic: Hide/show fields in Detail View
Replies: 12
Views: 138

Re: Hide/show fields in Detail View

Here is what I tried in Marriages-dv.js jQuery(function(){ jQuery('#Other_Marriages').click(function(){ if(jQuery(this).prop('Other_Marriages0')){ // Other_Marriages0, is "id" for None. /* hide some stuff */ jQuery('#Marriage_2, #Marriage_3, #Marriage_4').hide(); }else{ /* show some stuff */ jQuery(...
by Jay Webb
2019-07-30 05:32
Forum: Advanced Customizations > Hooks
Topic: Hide/show fields in Detail View
Replies: 12
Views: 138

Hide/show fields in Detail View

Using AppGini: 5.76 Hello All, I've tried a dozen different ways and no success, searched forums and nothing worked. Setup: In table Marriages, I have a field Other_Marriages that has 4 radio buttons, "None", "2nd Marriage", "3rd Marriage" and "4th Marriage". In same table Marriages, I have 3 fields...
by Jay Webb
2019-07-25 00:48
Forum: Getting Started
Topic: Lookup join.
Replies: 6
Views: 160

Re: Lookup join.

Hi Olaf Yep, most of it is ID numbers except for the surnames and codes. Would you now of a way to limit the code/number being used once per table, (ie) Marriages, Baptism_Birth, Deaths. I made the table FF_Codes, field Codes unique but that only prevents it from being added again in the FF_Codes ta...
by Jay Webb
2019-07-24 16:08
Forum: Getting Started
Topic: Lookup join.
Replies: 6
Views: 160

Re: Lookup join.

Hello Olaf The video was perfect, that's just what I'm trying to do and I have success, knowing what to call it was half the trouble, took me 3 tries to get it to work but it works. Now just need to figure how to make all CSV files to populate with all the data I've already collected. Thank you so m...
by Jay Webb
2019-07-23 22:36
Forum: Getting Started
Topic: Lookup join.
Replies: 6
Views: 160

Re: Lookup join.

Well, I figured how to make the join, made another field "SURNAME" in Add_File_Number, that is a lookup to "SURNAME_LIST" to populate as selections. But haven't figure how to limit surnames to specific code groups for "NUMBERS' in Add_File_Number. I'm thinking JS in magic file is the best route but ...
by Jay Webb
2019-07-23 18:11
Forum: Getting Started
Topic: Lookup join.
Replies: 6
Views: 160

Lookup join.

I'm using AppGini 5.76 Here is my current tree (image.1) table "Marriages" field "FFN" gets its lookup from table "File_Surname_Number" and is to be compiled from table "File_Surname_Number" fields "FF_SURNAMES" and field "FF_NUMBERS". (image2) Image.1 https://i.ibb.co/vmLs1k1/current-appgini-tree.j...
by Jay Webb
2019-07-22 17:01
Forum: Getting Started
Topic: Lookup field not showing data.
Replies: 3
Views: 66

Re: Lookup field not showing data.

Hey pbottcher!

That did it, just need to change surnames to ID# and it worked.
by Jay Webb
2019-07-22 16:48
Forum: Getting Started
Topic: Lookup field not showing data.
Replies: 3
Views: 66

Re: Lookup field not showing data.

Thanks for replying,

Do you mean use the ID# for the surname spelling in SURNAME_LIST as the value in table MARRIAGES field SURNAME?
by Jay Webb
2019-07-22 16:14
Forum: Getting Started
Topic: Lookup field not showing data.
Replies: 3
Views: 66

Lookup field not showing data.

I'm using AppGini 5.76 rv.1058 Lookup field SURNAME not showing data on CSV import. First, all tables have field "ID". I have a table called "MARRIAGES", with a lookup field called "SURNAME", that a looks to table "ADD_SURNAME", field "SURNAME_LIST". There are 2,656 "MARRIAGE" records I'm trying to ...
by Jay Webb
2018-05-20 23:02
Forum: Advanced Customizations > Hooks
Topic: MySql Right Join to hook.
Replies: 3
Views: 862

Re: MySql Right Join to hook.

Hello: Pascal I'v tried a dozen different ways and I can't seem to get it working. Did a bunch of reading and came up with this, function FF_Reference_Check_init(&$options, $memberInfo, &$args){ $options=$query $query = mysql_query("SELECT ID, FamilyFile, LastName, FirstName, Birth, BirthDate, Birth...
by Jay Webb
2018-05-17 22:13
Forum: Advanced Customizations > Hooks
Topic: MySql Right Join to hook.
Replies: 3
Views: 862

MySql Right Join to hook.

Trying to to input data from tbl1 to empty tbl2. My php comes from successful query in phpmyadmin, now would like to add as hook so on page load, data is retrieved from tbl1 and sent to tbl2. I tried this code, it run with blank screen, not sure how to proceed In; ../hooks/FF_Reference_Check.php fun...
by Jay Webb
2018-05-11 23:35
Forum: Getting Started
Topic: navLinks, whats the limit?
Replies: 8
Views: 1133

Re: navLinks, whats the limit?

Hey, Pascal Found the problem it's in "dynamic.css.php" line 55 .navbar ul.dropdown-menu { max-height: 400px; overflow-y: auto; } I changed, overflow-y: scroll; and I can see all 49 links with scrollbar, I could also change, max-height: 600px; and also see all links, so the issue wasn't there was a ...
by Jay Webb
2018-05-11 21:50
Forum: Getting Started
Topic: navLinks, whats the limit?
Replies: 8
Views: 1133

Re: navLinks, whats the limit?

Hello,

Well, made the file, ran it, got no errors, there is 49 links in table_group 0.
See file results here https://drive.google.com/file/d/1cVKtes ... sp=sharing
think this should work.
by Jay Webb
2018-05-11 19:01
Forum: Getting Started
Topic: navLinks, whats the limit?
Replies: 8
Views: 1133

Re: navLinks, whats the limit?

Hi, I made a new links-navmenu.php in hooks folder with nothing in it but, <?php for ($i=1; $i<50; $i++) { $navLinks[] = array( 'url' => '#', 'title' => 'Navl-Link '.$i, 'groups' => array('*'), // groups allowed to see this link, use '*' if you want to show the link to all groups 'icon' => 'table.gi...