We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

how do I create a field in base that is all caps

asked 2021-04-25 00:47:02 +0200

andreatk gravatar image

updated 2021-05-17 13:13:58 +0200

Alex Kemp gravatar image

I imported a calc sheet into base. I have one column that needs to always be capital letters. I looked at all the options for text in the field type, but they don't make a whole lot of sense to me. I just want to use all caps in the one field, please help. thank you in advance

edit retag flag offensive close merge delete



Need to know the database used. On the main Base screen on the status bar (very bottom line) in the center it tells the database and on the left the connection. What are these?

Ratslinger gravatar imageRatslinger ( 2021-04-25 02:31:54 +0200 )edit

Open the sheet in calc and change the case there.

AdmFubar gravatar imageAdmFubar ( 2021-04-25 02:52:28 +0200 )edit

I didn't think it could be done easily. Thank you for the response

andreatk gravatar imageandreatk ( 2021-04-25 22:38:00 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2021-04-25 03:53:58 +0200

Ratslinger gravatar image


After some thought, knowing the database used is probably not going to help. The problem is the on-going entry of data and not just the initial import.

If the field information has a reasonable maximum length you can consider the table field as varchar and the entry form to use a pattern field. Otherwise you will need to use a macro.

See these posts:

Unique function to stop duplicate entry in either upper or lowercase

How do I make entry all caps

edit flag offensive delete link more


There is no need to close a question. Someone else may come along with a better solution. Also you closed with correct answer as accepted but no answer was marked.

Please see -> How do I mark an Answer as correct?

Ratslinger gravatar imageRatslinger ( 2021-04-25 22:56:15 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2021-04-25 00:47:02 +0200

Seen: 36 times

Last updated: Apr 25