Field Name: Phone Number
Field Type: US Phone Number
I’m sure the format of US phone’s won’t change, so I go ahead and use that field type.
Like I said though, I usually default to text field types, unless I have a specific need for a different type.
As far as checkboxes are concerned, they are a type of input, so yes you’ll want to use them to create or modify data.
Right, that’s a good use case for a checkbox. In this case, I wouldn’t use a boolean (yes/no) field type though.
Let me back up though. I think the pain point here isn’t which field type to use for this rather it’s the underlying architecture or design of your database.
Gaby has an excellent write up on designing a database in one of her previous newsletters. She walks through building a database for a hair salon. Have you read it? I can dig up a link for it if you haven’t.