Prefix Suffix to number entry

Welcome to the community, Michael! :grinning_face_with_big_eyes: Can you give an example of a prefix/suffix you’d like to add to numerical values? There might be a way to pull it off via a formula.

@Justin_Barrett could be cool for units. For example, 42 would be formatted as 42 g, 42 km, etc.

Good point. Not sure why 2019 me didn’t think of that. :slightly_smiling_face:

Hi there,

I am looking for a way to automatically generate a prefix when performing a manual input in a field. Ex:

Automatically generated prefix = 21
Manually inputed value = 222

Result in the field = 21222

Thank you

Welcome to the community, @Frederic_Faugere! :grinning_face_with_big_eyes: This might be possible, but not in a very clean/convenient way. It’s possible to design an automation that looks for changes in a given field and updates the entered value with a predetermined prefix/suffix/???, but the problem comes in the timing. If the automation triggers directly on the field change, it could interrupt what you type, leading to an incomplete replacement. A delay could be designed, but if you want the result sooner, waiting for that delayed trigger might be frustrating. And then there’s the possibility that having an automation trigger on changes—instant or delayed—to a field and make changes to the same field, that might end up triggering an endless automation loop. (I think that Airtable distinguishes between automation-based changes vs manual changes, but I haven’t run any concrete tests, so I can’t be sure.)

While it would be very convenient to have some automated process create the modified output you want in the same field, I suggest using a formula field to take the value you enter and output the modified value that you want.

This is a pretty basic feature. You want the data to be stored as a number not as text but to be displayed with the proper units. 

Is this still not a feature?