Contents
How to store multiple values in single field in SQL database?
Also, this is just pseudo code, so don’t use Table in the name. You should create separate tables for Person and PhoneNumber. As far as PostgreSQL is concerned, You can store XML data by using xml type which can store well-formed “documents”.
When to use multi select and single select?
I want users to be able to find people who match (hence Gender is a multi-select; they can choose to match against one or both genders) and interests/hobbies. Along with those fields, there are several “single-select” fields such as the user’s city, state, their gender, etc…
How to store multiple data as a delimiter?
You can store multiple data as delimiter separated values. Use pipe (|) or tilt (~) as the delimiter. And when we are inserting new value or updating existing value, check if the phone number already exists. If there is already some data present in the phone number column, just append it with delimiter + new phone number.
Can a column hold more than one item?
Each column should hold only one data item, but a comma-separated list is multiple items. Each Interest is a repeated data item in User.
Can you assign different recordtypes to different users?
You can accomplish this (by profile) with Apex and Visualforce, but if you want to use native capabilities you can do this with RecordTypes. you can have different pick-list values based on recordTypes and then have different users assigned different recordTypes based on their profile. 2.
How to limit picklist values per profile in Salesforce?
Deve’sc Sarilla’s Validation Rule method is great if you don’t mind the users seeing (and being able to errantly select the unacceptable options), but I don’t think it’s user-freindly to show options that will throw errors if selected/saved. So, I solved this same issue with the following approach: a.
Can a picklist be controlled by a profile?
Hope it helps, select it as best answer if it does the job. Shubham Nandwana. Picklists can only be controlled by Record Types but not by Profiles, If you are using Record types, you can then configure what picklist options are visible for each record type.