AppGini Community Forums

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...

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

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...

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...

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...

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...

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 ...

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

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...

it works great!

Thank you so much!!!!

Fabiano

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...

:-( 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...

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.

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...

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...

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

Key =

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...

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!

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...

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...

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

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...

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...

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!

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...