Search found 101 matches

by fgazza
2019-10-14 23:09
Forum: Advanced Customizations > Hooks
Topic: check and avoid duplicate fields and show custom error message
Replies: 6
Views: 86

Re: check and avoid duplicate fields and show custom error message

Sorry but now I'm trying to do the exact same thing with a table named anagrafica_persone where the check is done on three fields: nome cognome codice_fiscale the tree fields automatically concatenate in the field nome_cognome_cf Everything works perfectly until the error message appears, if the "no...
by fgazza
2019-10-13 15:50
Forum: Advanced Customizations > Hooks
Topic: check and avoid duplicate fields and show custom error message
Replies: 6
Views: 86

Re: check and avoid duplicate fields and show custom error message

Hi pböttcher!
It works fine.
Thank you so much!
A special thanks to Uday Vattury for the original code that also works like a charm!
Ciao!
Fabiano
by fgazza
2019-10-13 09:25
Forum: Advanced Customizations > Hooks
Topic: check and avoid duplicate fields and show custom error message
Replies: 6
Views: 86

Re: check and avoid duplicate fields and show custom error message

Excuse me, looking at the code I realized the error message was commented and therefore didn't work. Now the error message appears (see screenshot). This would be fine if after clicking "OK" the contents of the first and last name were deleted but if the "cognome_nome" field is not set as "unique" i...
by fgazza
2019-10-13 00:09
Forum: Advanced Customizations > Hooks
Topic: check and avoid duplicate fields and show custom error message
Replies: 6
Views: 86

Re: check and avoid duplicate fields and show custom error message

Hello. An example of what happen: In the table there is already a record with the nome_cognome field containing the text "Altman John". Now I create a new record where I insert john in the nome field and insert Altman in the cognome field. The cognome_nome field is automatically filled with the cont...
by fgazza
2019-10-12 08:39
Forum: Advanced Customizations > Hooks
Topic: check and avoid duplicate fields and show custom error message
Replies: 6
Views: 86

check and avoid duplicate fields and show custom error message

Hello to all I have a "staff_progetto" table. In the table there are a field "nome" (= name), a field "cognome" (= surname) and a field "cognome_nome". The "cognome_nome" field automatically concatenate (on change) the "cognome" field and the "nome" field. I need to prevent that in my database there...
by fgazza
2019-10-07 19:08
Forum: Advanced Customizations > Hooks
Topic: Error message if a pair of values exist in database
Replies: 5
Views: 114

Re: Error message if a pair of values exist in database

Thanks! The code you suggested should be inserted in the file tablename-dv.js? If yes, I can inserti it at the end othis code? function updateName() { var name= $j( '#name' ).val(), last_name= $j( '#last_name' ).val(); $j( '#first_last_name' ).text(last_name+' '+name); $j( '#first_last_name' ).val(l...
by fgazza
2019-10-07 12:21
Forum: Advanced Customizations > Hooks
Topic: Error message if a pair of values exist in database
Replies: 5
Views: 114

Re: Error message if a pair of values exist in database

Thanks! I am very sorry but I have difficulty understanding the code in the post you suggested to me and I understand that we need to modify the header-extra.php file? in my table I also have a "first_last_name" field in which the name and last_name fields are concatenated in real time. can someone ...
by fgazza
2019-10-06 20:09
Forum: Advanced Customizations > Hooks
Topic: set a checkbox field as readonly for those who do not belong to the admin group
Replies: 4
Views: 55

Re: set a checkbox field as readonly for those who do not belong to the admin group

Thank you so much for your explanations!
So i think too that in my case I can use the disable attribute with no risks!
Thanks a lot !!!
Fabiano
by fgazza
2019-10-06 17:18
Forum: Advanced Customizations > Hooks
Topic: set a checkbox field as readonly for those who do not belong to the admin group
Replies: 4
Views: 55

Re: set a checkbox field as readonly for those who do not belong to the admin group

thanks also for this advice! I read in the forum somewhere that the "disable" attribute can create data loss. I didn't understand what you meant. Can I safely use the disable attribute? the important thing is that if the administrator sets the field in a state and an unauthorized user opens the reco...
by fgazza
2019-10-06 14:10
Forum: Advanced Customizations > Hooks
Topic: How to display image in printing page
Replies: 24
Views: 343

Re: How to display image in printing page

it works great!

Thank you so much!!!!

Fabiano
by fgazza
2019-10-06 12:21
Forum: Advanced Customizations > Hooks
Topic: set a checkbox field as readonly for those who do not belong to the admin group
Replies: 4
Views: 55

set a checkbox field as readonly for those who do not belong to the admin group

Hi! I would like to set a checkbox field (named autorizza_attestato) as readonly for those who do not belong to the admin group. I used this code in the hook file of my table partecipazione_evento_pubblico but it does not work. function partecipazione_evento_pubblico_dv($selectedID, $memberInfo, &$h...
by fgazza
2019-10-05 21:31
Forum: Advanced Customizations > Hooks
Topic: How to display image in printing page
Replies: 24
Views: 343

Re: How to display image in printing page

:-( the result is: Key = 10Url= I try to answer to your question: what is the relation between the partecipazione_evento_pubblico and the intestazioni_grafiche table? In the table "appuntamenti" i select an image uploaded with the table "intestazioni_grafiche" so there is a lookup field to choose th...
by fgazza
2019-10-05 20:22
Forum: Advanced Customizations > Hooks
Topic: How to display image in printing page
Replies: 24
Views: 343

Re: How to display image in printing page

sorry I accidentally translated the name of the table "intestazioni_grafiche" into "header_grafiche" but the table "header_grafiche" does not exist. Instead of "header_grafiche" I wanted to write "intestazioni_grafiche".

Now I try the query you suggested and let you know.
by fgazza
2019-10-05 19:29
Forum: Advanced Customizations > Hooks
Topic: How to display image in printing page
Replies: 24
Views: 343

Re: How to display image in printing page

Hi and Thank you so much for the help of the forum and specially to you pböttcher! In the forum I spoke to simplify, of three tables "image", "activity" and "subscription" (tables that I actually used to do the tests). In reality, my tables are called "intestazioni_grafiche", "appuntamenti" and "par...
by fgazza
2019-10-05 17:14
Forum: Advanced Customizations > Hooks
Topic: How to display image in printing page
Replies: 24
Views: 343

Re: How to display image in printing page

Yes but I have no idea how to do it! I'm trying to auto copy content of llokup field in another field so i made another help request in the forum (see my post https://forums.appgini.com/phpbb/viewtopic.php?f=7&t=3254#p11162 but I have problem with this work too. Hope you or someone will help me agai...
by fgazza
2019-10-05 14:21
Forum: Advanced Customizations > Hooks
Topic: How to display image in printing page
Replies: 24
Views: 343

Re: How to display image in printing page

hi. Putting echo "Key = ".$key; the output is

Key =
by fgazza
2019-10-05 14:16
Forum: Advanced Customizations > Hooks
Topic: auto copy content of llokup field in another field
Replies: 0
Views: 31

auto copy content of llokup field in another field

Hello to all. I have an "appointments" table with a "intest_attestato_graph" field which is a lookup field that points to an image type field in another table. When working with the records in the "appointments" table, I would like the image of the chosen image to be copied to another "url_intest_at...
by fgazza
2019-10-05 06:43
Forum: Advanced Customizations > Hooks
Topic: How to display image in printing page
Replies: 24
Views: 343

Re: How to display image in printing page

sorry pböttcher can you tell me exactly what i have to write in sql query of phpmyadmin? sorry but i'm not expert with the code
Thanks!
by fgazza
2019-10-04 19:42
Forum: Advanced Customizations > Hooks
Topic: How to display image in printing page
Replies: 24
Views: 343

Re: How to display image in printing page

hello! the strange thing is that if I look in the tables of my database the image column of the subscritpions table is empty (null) if I run SELECT picture from pictures where pri_key = '1' the result is the name of the jpg file loaded in the pictures table with pri_key = 1 but if I run the query SE...
by fgazza
2019-10-03 21:29
Forum: Advanced Customizations > Hooks
Topic: Error message if a pair of values exist in database
Replies: 5
Views: 114

Error message if a pair of values exist in database

Hello! In my table I have a name field and a last _name field. I need to create a code that, once these fields have been filled in and before saving the record, checks the database and if the name - surname pair is already present prevents from saving the new record, empty the name and surname field...
by fgazza
2019-10-03 08:41
Forum: Advanced Customizations > Hooks
Topic: How to display image in printing page
Replies: 24
Views: 343

Re: How to display image in printing page

Thank you very much pböttcher, unfortunately it doesn't work: I wrote like this: ________________________ $url = sqlvalue ("SELECT picture from pictures where pri_key = '{$key}'"); /* to test if work: */ echo $url; ________________________ but nothing appears! I hope you can help me. Thanks! Fabiano
by fgazza
2019-10-02 16:38
Forum: Advanced Customizations > Hooks
Topic: How to display image in printing page
Replies: 24
Views: 343

Re: How to display image in printing page

Hello. I need to do the same thing but since the jpg file I want to display on the page is not in the same table but in a table called "pictures" I can't get the url of the image but only the primary key of the record of the "pictures" table (the url is in the "picture" field of the "pictures" table...
by fgazza
2019-10-01 18:50
Forum: Advanced Customizations > Hooks
Topic: live auto fill field based on other field content
Replies: 3
Views: 152

Re: live auto fill field based on other field content

Thanks to Reham and Uday now i have the code!!! Here is the code: function updateName() { var name= $j( '#name' ).val(), last_name= $j( '#last_name' ).val(); $j( '#full_name' ).text(last_name+' '+nome); $j( '#full_name' ).val(last_name+' '+nome); } $j('#last_name,#name').on('change', function() { up...
by fgazza
2019-09-29 08:05
Forum: Advanced Customizations > Hooks
Topic: live auto fill field based on other field content
Replies: 3
Views: 152

Re: live auto fill field based on other field content

thanks for the valuable suggestions.
Unfortunately I'm not good with the code.
Is it possible to have some help to create the code to insert in the table-dv.js file?
Thanks!
by fgazza
2019-09-28 12:32
Forum: Advanced Customizations > Hooks
Topic: live auto fill field based on other field content
Replies: 3
Views: 152

live auto fill field based on other field content

Hello to all. I have a "name" field and a "last _name" field I have another surname_name field I would like to make sure that when a user fills in the first and last_name fields the surname_name field fills up automatically concatenating surname and name This should happen live by filling out the fo...