This would be big for @Lucas_Pires and @Robert_Petittoās Trebuchet method, I believe.
Also, it would eliminate a lot of extra columns we had to previously create specifically for template columns.
This would be big for @Lucas_Pires and @Robert_Petittoās Trebuchet method, I believe.
Also, it would eliminate a lot of extra columns we had to previously create specifically for template columns.
I see it this morning and I thought āThat wasnāt there yesterday rightā? Awesome!

This is really Great
Oh just realized it would be much better to have the left side to be a custom value as well, it would be of great help for removing items from a joined list.
But its custom now no? I mean if you want to remove items you can add the joined list as the thing you want to use as template and then put the item you donāt want or you want to replace in the left side of the replacement and let the right one as custom in order to simulate a ādeleteā item.
what am I missing? Iām failing to see how this is any different from just entering the actual custom values in the Template field itselfā¦
in the image from top there is a replacement to āEā that you can now put as āCustomā.
The left hand side is an entry that canāt be pointed to another column. Letās say if I have a list of rowIDs I canāt know ahead what I want to replace.
Oh true, do you mean to use a column on the left side?. Thatās true that is not possible (yet i hope)
Yeah I did hope that will become a thing. I was thinking I can point a rowID to that place and an empty field on the right side to āremoveā that ID.
@Robert_Petitto A template can dynamically point to another column, so at that point, you wouldnāt be able to just enter a value in the template to be replaced, but I suppose you could do the same thing in the source column or create a pre-template template. Depends on the situation.
Where I would use this, and have needed it many times, is in situations where I want to replace a character or value with a blank or null. (An example would be my calculator, where I can backspace delete the numbers. All that does is replace the last number and a special character with a null value.
Trebuchet-ish I guess you could say.) I have several sheets with a tmp-Empty or txt-Blank column just so I can do these replacements. Now I can get rid of those extra columns. Another situation might be where you want to replace a decimal or ā0.ā with blank or null to easily create a left zero padded number value.
I think in most cases where something like this is used, the source template is dynamically driven by another column instead of typing in your own template.
Basically if you need to replace a value for whatever reason with a static value, you can avoid extra columns to hold that static value. You know it when you need itā¦and Iāve needed it a handful of times. 
Thatās awesome with the special values. I donāt remember seeing that before.
Yeah, I noticed that. A little misleading with the wording. Iām guessing itās still meant to be transferred to another column when a form is submitted???
I thought the Unique Value is interesting as well. It looks like it assigns a unique value to each row, but I wonder if something would ever cause it to change, or if itās static, like the row id.
I guess thatās awesome!
The most common use case I can think by now is the blank/null value we can now create without creating another template column only to replace it as @Jeff_Hager said
But if you guys have more use cases, share with us 
Yaā¦guess itās a way to TRIM() as wellā¦just another example of blank/null though.