This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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.