Search found 34 matches

by rprevost
2019-08-05 19:18
Forum: AppGini Plugins
Topic: Mass Update - Questions
Replies: 2
Views: 76

Mass Update - Questions - Solved

OK, i finally succeeded in creating all my mass update function. After messing things around by creating many projects for the same ***.axp file, i decided to do some cleaning up to see if things would improve. Here is what i did: Delete all Mass Update Projects: Projects to delete are in /plugins/p...
by rprevost
2019-08-04 20:52
Forum: Getting Started
Topic: Auto-fill from more than one source field
Replies: 0
Views: 35

Auto-fill from more than one source field

Hello to you all, Using AG 5.76 I have two tables: stage and superviseur In superviseur table, the relevant four fields are: first_name, last_name, telephone and email In stage table, the relevant fields are: supername, super_telephone, super_email * supername (ID) is a lookup field which fetches th...
by rprevost
2019-08-03 19:40
Forum: Advanced Customizations > Hooks
Topic: Editable default value problem
Replies: 10
Views: 174

Editable default value solution

Thank you Mr pböttcher for you help. I finally succeeded implement a functionality based on Section 10, lesson 26 in the UdeMy course. Users of my app can now change, at will, the value of a lookup field and make sure this new value will be stored in the target table. They are saving thousands of ke...
by rprevost
2019-07-31 17:46
Forum: Advanced Customizations > Hooks
Topic: Editable default value problem
Replies: 10
Views: 174

Re: Editable default value problem

Here is the screen shot of the app with debugger stage.png "Sigle du cours" is a dropdown field linked to the "sigle" table. On change of this value I want the "nbrehres" fied value to appear in the "Nombre d'heures du stage complétées" entry box. The app already shows the "Nombre d'heures du stage"...
by rprevost
2019-07-31 01:48
Forum: Advanced Customizations > Hooks
Topic: Editable default value problem
Replies: 10
Views: 174

Re: Editable default value problem

I added alert(sigid); after the declaration of the var sigid.
Nothing is running (no alert is showing)

This is the problem, the script is not running on change: $j('#etu_sigle-container').on('change', function()

The etu_sigle-container might not be the right variable to monitor for change
by rprevost
2019-07-30 21:42
Forum: Advanced Customizations > Hooks
Topic: Editable default value problem
Replies: 10
Views: 174

Re: Editable default value problem

Hello again,

Tried : var sigid = $j('input[name="etu_sigle"]').val();

Still not working. The problem might lie possibly elsewhere.
Sorry about that.
Regards
by rprevost
2019-07-30 20:52
Forum: Advanced Customizations > Hooks
Topic: Editable default value problem
Replies: 10
Views: 174

Re: Editable default value problem

Thank you pbottcher, nice suggestion. However, it is still not working and according to my understanding of the code it cannot work. I might be completely wrong in my reasoning but this is the way I see it. You suggest using: var sigid = $j('#s2id_etu_sigle-container .select2-chosen').text(); If so,...
by rprevost
2019-07-30 19:51
Forum: Advanced Customizations > Hooks
Topic: Editable default value problem
Replies: 10
Views: 174

Editable default value problem

Hello to you all, (using AG 5.76) In order to facilitate user input and save keystrokes, I am trying to implement a functionality demonstrated in the following section of the UdeMy course: 26. Retrieving parent record info into detail view field Main goal: On change for a dropdown field ("etu_sigle"...
by rprevost
2019-07-30 14:58
Forum: AppGini Plugins
Topic: Mass Update - Questions
Replies: 2
Views: 76

Re: Mass Update - Questions

Hello, I also noticed that Mass Update Plugin modified one of some hook's file (stage.php) directly on the server side making it different from my original file located on my computer. It is like two distinct sources are writing the same file. I cannot imagine the mess that could result over time. M...
by rprevost
2019-07-30 14:34
Forum: AppGini Plugins
Topic: Mass Update - Questions
Replies: 2
Views: 76

Mass Update - Questions

Hello, thank you for this plugin. I ran into some issues that need to be addressed: Mass Update is not working as expected. It is a simple update of a dropdown field with (Allow user to specify) and confirm first option. The output seems ok: Copying language-mass-update.js ... OK Updating footer-ext...
by rprevost
2019-02-28 19:10
Forum: Bugs/annoyances
Topic: Visualize and Add Icons not always displayed when viewed in a tab
Replies: 5
Views: 476

Re: Visualize and Add Icons not always displayed when viewed in a tab

Hopefully this will help you identify the source of the problem. This part of the stage.php file in the Hooks directory: function stage_dv($selectedID, $memberInfo, &$html, &$args){ /* if this is the print preview, don't modify the detail view */ if(isset($_REQUEST['dvprint_x'])) return; ob_start();...
by rprevost
2019-02-25 18:09
Forum: Bugs/annoyances
Topic: Visualize and Add Icons not always displayed when viewed in a tab
Replies: 5
Views: 476

Re: Visualize and Add Icons not always displayed when viewed in a tab

Hello, Thank you for the suggestions. I tried both but it is still not working. Here is another piece of information that might give you a clue on the source of the problem : - When I display the detail view page, all relevant fields on the main section of the page show the appropriate icons. - If I...
by rprevost
2019-02-16 20:46
Forum: Feature Suggestions
Topic: Updating multiple records using Batch Action
Replies: 2
Views: 324

Updating multiple records using Batch Action

Hello to you all, Wanting to change the value of a single field in many records (+- 1200), i searched the forum for solutions and suggestions. I emplemented a solution found here : https://forums.appgini.com/phpbb/viewtopic.php?f=2&t=1600&p=4183&hilit=batch+action#p4183 It worked but it is very weak...
by rprevost
2019-02-04 12:34
Forum: Getting Started
Topic: Lookup fields (auto-fill) linked to two data entry fields
Replies: 5
Views: 608

Re: Lookup fields (auto-fill) linked to two data entry fields

Thank you for your great work. I hope this "improvement" will come soon.
by rprevost
2019-01-12 21:53
Forum: Getting Started
Topic: Lookup fields (auto-fill) linked to two data entry fields
Replies: 5
Views: 608

Re: Lookup fields (auto-fill) linked to two data entry fields

Hello to all of you. I am still experiencing some difficulty understanding lookup fields and I hope one of you can help me because, my app is coming along very well so far (thanks to Mr Geany). So here it goes: In my mind a lookup value should help me to retrieve a piece of information based on spec...
by rprevost
2019-01-12 21:21
Forum: Bugs/annoyances
Topic: Visualize and Add Icons not always displayed when viewed in a tab
Replies: 5
Views: 476

Visualize and Add Icons not always displayed when viewed in a tab

Hello to all of you. I wish you all a happy new year. I noticed an annoyance while browsing the application I am working with: Lookup fields (showing a dropdown list from another table) do not always show the accompanied visualize and add icons when they are displayed in a tab. This behaviour is not...
by rprevost
2018-12-26 12:06
Forum: Feature Suggestions
Topic: Auto-fill functionality improvement
Replies: 2
Views: 671

Auto-fill functionality improvement

Hello to you all. Maybe the following feature request has been asked for before but since I did not find it in the Feature Suggestions forum, here it is: Auto-fill is a great feature (easy to use and powerfull). However, I was faced with one limitation that became rapidly bothersome for me. The limi...
by rprevost
2018-12-04 14:18
Forum: Getting Started
Topic: Lookup fields (auto-fill) linked to two data entry fields
Replies: 5
Views: 608

Re: Lookup fields (auto-fill) linked to two data entry fields

Thank you for taking the time to help me with this problem. Your solution is clever.
by rprevost
2018-12-02 22:47
Forum: Tips And Tricks
Topic: store VALUE instead ID
Replies: 15
Views: 1911

Re: store VALUE instead ID

Hello to you all, I deeply sympathize with people who tried over the years to explain and to convince "seniors-knowledable-appgini-experts" about the importance of Storing value instead of ID in a field. Three distinct situations are possible : A: Recuperate the current phone number of a client in t...
by rprevost
2018-12-02 21:21
Forum: Getting Started
Topic: Lookup fields (auto-fill) linked to two data entry fields
Replies: 5
Views: 608

Lookup fields (auto-fill) linked to two data entry fields

Hello to you all, Hopefully one of you can assist me in finding a solution to the following problem I have with an application I designed with AG. Table A : list of people (name, email, phone, ....) === the same person can be at times a supervisor or a co-supervisor, or he can be a teacher. Each and...
by rprevost
2018-10-09 00:25
Forum: Advanced Customizations > Hooks
Topic: show_error improvement
Replies: 2
Views: 347

show_error improvement

Hello to you all, The show_error function used in field content validation javascript is great. However, the title of the modal window is sometimes "cryptic" especially if the name of the database name of the field looks like "sta_form_start_date". Since the caption of the field is nicer "Student Cl...
by rprevost
2018-07-20 21:28
Forum: Getting Started
Topic: Lookup Filter
Replies: 2
Views: 524

Re: Lookup Filter

Sorry, my stupid mistake. I put the WHERE statement before the FROM statement. The following works great ------------------------- SELECT `equipe`.`id`, IF(CHAR_LENGTH(`equipe`.`nom`) || CHAR_LENGTH(`equipe`.`id`), CONCAT_WS('', `equipe`.`nom`, ' / ', `equipe`.`id`), '') FROM `equipe` WHERE `equipe`...
by rprevost
2018-07-20 20:58
Forum: Getting Started
Topic: Lookup Filter
Replies: 2
Views: 524

Lookup Filter

Hello to you all, Using 5.72 sorry to bother you with this 'trivial' problem. I am trying to filter a lookup list. The filter is on a field named actif in the equipe table. the field actif is a varchar of length 3 In phpMyAdmin, the field actif has been set to index PROBLEM : On click over the field...
by rprevost
2018-07-17 13:08
Forum: Advanced Customizations > Others
Topic: Enter data directly
Replies: 3
Views: 847

Re: Enter data directly

Hello, how would you proceed with the following situation? One table for inscription with some fields to be entered by parent (anonymous entry form) and other fields reserved for administration. Administrative fields must be hidden from parent at entry time. With admin login, one should be able to s...
by rprevost
2018-07-16 20:49
Forum: Getting Started
Topic: Suddenly, it's impossible to sign-in under any username
Replies: 4
Views: 809

Re: Suddenly, it's impossible to sign-in under any username

For the sake of it. This behaviour was the use of an error in the language.php (french translation). It worked with the original language.php (english). So I downloaded the french version and replace the original language.php. Working OKay now.
Thank you.