how to record a user from security module to a from field

Applications Forms
#1

hi guys, if i want to make a new field in the database that receieves the value of the logged in user from the database, how i can do that?

i want to display the user that added this form field in the grid/report

is there an easy way to do that? without going to log module and search? simple i want the grid to show the form information that added by the user and also shows the one who put those info

#2

[usr_name] variable is what you need

#3

perfect, where to put it? how to use it in form field?

create a new field in db and make this field hidden in sc form then add defined value like that? or you have better idea?

#4

Just use it on default value of the field for.example

#5

hi again dude
wish you are doing fine
are you sure this works? i put this variable but didn’t record anything to the db field!? should i add echo?

#6

Can you share an screesnhot? Has you loged in?

#7

i’m sorry i was putting the variable in the grid_mask, because it was annoying in the development enviornment as with every preview was asking for the variable like id_form_[usr_name] and prompt for it so i thought there was something wrong :slight_smile:

now changed it to “database value on insert and on update” as force value and it work :slight_smile: hopefully will not get any other errors, but i will post any error if i find

thanks Giu, you are a life saver along with Albert :slight_smile: