Hello again,
I have one table called user_data where I want to collect some user data, I have in this table the elements:
name = field
userpoints = calc
email = field
Then I have another table called user_points where I want to have the possibility to add user points. So I added these elements
user = database join from table user_data
from = date
to = date
points = field
Now I try to get the calc element working.
I want that the value of the calc element userpoints will be generated by the field points, corresponding to the username. Means
I have a user Test1 and Test2 created in the table user_data.
Now I added a from and to date and 200 points to the user Test1 in the table user_points
I also added a from and a to date and 500 points to the user Test2 in the table user_points
So after duing this the element userpoints in the table user_data for Test1 should have as value 200 and for Test2 the value 500
Hope it is clear what I mean and hope someone can help.
Kind Regards and thanks,
joki94
I have one table called user_data where I want to collect some user data, I have in this table the elements:
name = field
userpoints = calc
email = field
Then I have another table called user_points where I want to have the possibility to add user points. So I added these elements
user = database join from table user_data
from = date
to = date
points = field
Now I try to get the calc element working.
I want that the value of the calc element userpoints will be generated by the field points, corresponding to the username. Means
I have a user Test1 and Test2 created in the table user_data.
Now I added a from and to date and 200 points to the user Test1 in the table user_points
I also added a from and a to date and 500 points to the user Test2 in the table user_points
So after duing this the element userpoints in the table user_data for Test1 should have as value 200 and for Test2 the value 500
Hope it is clear what I mean and hope someone can help.
Kind Regards and thanks,
joki94
Last edited: