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! 
1 Like
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.
1 Like
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âŚ
2 Likes
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.
1 Like
@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.
2 Likes
HmâŚkinda followingâŚIâm slow this morning I guess. Whatâs more interesting to me is when you click the triple dots:
3 Likes
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.
2 Likes
Ya. Saves me from having to create a âTimestamp Columnâ and then doing a Special Value hidden field in a form to populate the timestamp:
EDIT
Or so I thoughtâŚit actually appears to populate it with a NOW valueâŚthatâs misleadingâŚor a bug?
1 Like
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 
1 Like
YaâŚguess itâs a way to TRIM() as wellâŚjust another example of blank/null though.
3 Likes
