Is it better to add fields

I have Users who can have ratings for multiple types of organizations.

Is it best to create several fields in Users and change that rating or is it better to collect the User and rating and add it to a new Data Type? I want them to be able to go back and edit their rating (Eventually I’d love to see it change automatically with a connection from the individual organization.

I am trying to figure out the best way to organize my data and I feel like I might be adding too many Data Fields to the User data type.

Thanks

Scott

I’d recommend using a separate table (i.e. Data type) for ratings.

Thank you.

There is a situation where I might take 5 users and add their handicaps together. Should I make the field a number or text?

If it’s going to be a number in any situation, then number is best.

1 Like