# šŸ†• Use custom value for right-hand side of template column **URL:** \ **Category:** Ask for Help\ **Created:** [April 30, 2021, 8:50am UTC](https://community.glideapps.com/t/use-custom-value-for-right-hand-side-of-template-column/26209 "2021-04-30T08:50:51Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 30, 2021, 8:50am UTC](https://community.glideapps.com/t/use-custom-value-for-right-hand-side-of-template-column/26209/1 "2021-04-30T08:50:51Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/5/b5d342b60352a825b5a042f48cd9e3c70e9af93d.png) This would be big for @Lucas_Pires and @Robert_Petittoā€™s Trebuchet method, I believe. > [@Shared "User Specific" Lists Between Users!](https://community.glideapps.com/t/shared-user-specific-lists-between-users/24747): > > Note: NOT a native feature in Glide. Uses the Pires-Petitto Trebuchet Method! Requires ~10 columns and 0 additional rows! Tutorial coming tomorrowā€”hereā€™s a (soundless) sneak peak! For context, thereā€™s one master list of items. Iā€™m switching between two users that are linked via a ā€œleadā€ email. The adding/removing of items from this master list is unique to these two users. Other users in the app have their own set of tools! [[Shared User Specific Column] ](https://www.youtube.com/watch?v=A6yC6kYv6F0)@Lucas_Pires > [@Trebuchet Method link](https://community.glideapps.com/t/trebuchet-method/25477): > > [image] Also, it would eliminate a lot of extra columns we had to previously create specifically for template columns. ---
**Author:** ![adriasoce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adriasoce/32/24153_2.png) [@adriasoce](https://community.glideapps.com/u/adriasoce)\ **Post date:** [April 30, 2021, 8:59am UTC](https://community.glideapps.com/t/use-custom-value-for-right-hand-side-of-template-column/26209/2 "2021-04-30T08:59:58Z")
I see it this morning and I thought ā€œThat wasnā€™t there yesterday rightā€? Awesome! šŸ˜ šŸ˜ šŸ˜ ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [April 30, 2021, 9:39am UTC](https://community.glideapps.com/t/use-custom-value-for-right-hand-side-of-template-column/26209/3 "2021-04-30T09:39:06Z")
This is really Great ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 30, 2021, 10:04am UTC](https://community.glideapps.com/t/use-custom-value-for-right-hand-side-of-template-column/26209/4 "2021-04-30T10:04:27Z")
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. ---
**Author:** ![adriasoce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adriasoce/32/24153_2.png) [@adriasoce](https://community.glideapps.com/u/adriasoce)\ **Post date:** [April 30, 2021, 10:07am UTC](https://community.glideapps.com/t/use-custom-value-for-right-hand-side-of-template-column/26209/5 "2021-04-30T10:07:29Z")
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. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 30, 2021, 11:19am UTC](https://community.glideapps.com/t/use-custom-value-for-right-hand-side-of-template-column/26209/6 "2021-04-30T11:19:32Z")
šŸ¤” 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ā€¦ ---
**Author:** ![adriasoce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adriasoce/32/24153_2.png) [@adriasoce](https://community.glideapps.com/u/adriasoce)\ **Post date:** [April 30, 2021, 11:30am UTC](https://community.glideapps.com/t/use-custom-value-for-right-hand-side-of-template-column/26209/7 "2021-04-30T11:30:18Z")
in the image from top there is a replacement to ā€˜Eā€™ that you can now put as ā€˜Customā€™. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 30, 2021, 11:32am UTC](https://community.glideapps.com/t/use-custom-value-for-right-hand-side-of-template-column/26209/8 "2021-04-30T11:32:37Z")
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. ---
**Author:** ![adriasoce](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adriasoce/32/24153_2.png) [@adriasoce](https://community.glideapps.com/u/adriasoce)\ **Post date:** [April 30, 2021, 11:33am UTC](https://community.glideapps.com/t/use-custom-value-for-right-hand-side-of-template-column/26209/9 "2021-04-30T11:33:50Z")
Oh true, do you mean to use a column on the left side?. Thatā€™s true that is not possible (yet i hope) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 30, 2021, 11:34am UTC](https://community.glideapps.com/t/use-custom-value-for-right-hand-side-of-template-column/26209/10 "2021-04-30T11:34:46Z")
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. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 30, 2021, 12:51pm UTC](https://community.glideapps.com/t/use-custom-value-for-right-hand-side-of-template-column/26209/11 "2021-04-30T12:51:06Z")
@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. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 30, 2021, 12:59pm UTC](https://community.glideapps.com/t/use-custom-value-for-right-hand-side-of-template-column/26209/12 "2021-04-30T12:59:50Z")
Hmā€¦kinda followingā€¦Iā€™m slow this morning I guess. Whatā€™s more interesting to me is when you click the triple dots: ![Screen Shot 2021-04-30 at 8.58.59 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/7/27cfb42e792afc5e51b055f97f60bf5c30283ee9.jpeg) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 30, 2021, 1:07pm UTC](https://community.glideapps.com/t/use-custom-value-for-right-hand-side-of-template-column/26209/13 "2021-04-30T13:07:15Z")
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. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 30, 2021, 1:24pm UTC](https://community.glideapps.com/t/use-custom-value-for-right-hand-side-of-template-column/26209/14 "2021-04-30T13:24:02Z")
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: ![Screen Shot 2021-04-30 at 9.22.55 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/0/a0d8f3dae6039127733172f8a28d18430b0e16fd.png) ### EDIT Or so I thoughtā€¦it actually appears to populate it with a `NOW` valueā€¦thatā€™s misleadingā€¦or a bug? ![Screen Shot 2021-04-30 at 9.26.11 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/a/3af7e286cdf8b48c3b909b01daa4afafe1c59756.png) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 30, 2021, 1:30pm UTC](https://community.glideapps.com/t/use-custom-value-for-right-hand-side-of-template-column/26209/15 "2021-04-30T13:30:32Z")
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. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [April 30, 2021, 1:44pm UTC](https://community.glideapps.com/t/use-custom-value-for-right-hand-side-of-template-column/26209/16 "2021-04-30T13:44:42Z")
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 šŸ˜ ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [April 30, 2021, 1:56pm UTC](https://community.glideapps.com/t/use-custom-value-for-right-hand-side-of-template-column/26209/17 "2021-04-30T13:56:49Z")
> [@Lucas\_Pires](#): > > 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. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [May 4, 2021, 3:25pm UTC](https://community.glideapps.com/t/use-custom-value-for-right-hand-side-of-template-column/26209/18 "2021-05-04T15:25:13Z")
Used this today to add a space after a comma in a delineated list: ![Screen Shot 2021-05-04 at 11.24.00 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/b/3b55523184456c4e6aeea0c60d6d6054e19659fd.png) ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [September 14, 2021, 6:19pm UTC](https://community.glideapps.com/t/use-custom-value-for-right-hand-side-of-template-column/26209/19 "2021-09-14T18:19:01Z")
> [@ThinhDinh](#): > > 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. Bumping this. Came into a situation where I needed to set the left hand value dynamically from a column value. This should be a relatively easy add, no? ![Rx_Billing_Genie_Ā·_Glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/f/2f70e7ada692a25a8427b7c375130d6a5bf98369.png)