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.
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.
