# Create Custom Links based on Static and Dynamic Data **URL:** \ **Category:** Ask for Help\ **Created:** [October 1, 2023, 10:31pm UTC](https://community.glideapps.com/t/create-custom-links-based-on-static-and-dynamic-data/66686 "2023-10-01T22:31:55Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Joshua\_Mentrup](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joshua_mentrup/32/54600_2.png) [@Joshua\_Mentrup](https://community.glideapps.com/u/Joshua_Mentrup)\ **Post date:** [October 1, 2023, 10:31pm UTC](https://community.glideapps.com/t/create-custom-links-based-on-static-and-dynamic-data/66686/1 "2023-10-01T22:31:55Z")
It would be extremely helpful to create custom links and display values with a mix of dynamic and static data. For example, if I have a person that has $100 as their price listed from a Google Sheet, but the calculation in Google Sheet is only 100 (not showing the dollar sign), it would be great to be able to display $100 instead of just 100 in the Glide App. Another application would be links: Let’s say I have a user with the username “john”. Instead of having to calculate the profile link and any other links in Google Sheet, making it slower, the more users I have, it would be awesome if you could have this dynamically created, so the field would consist of a static part ([www.website.com](http://www.website.com)) and the dynamic part from the data table (username=john) and it would link to [www.website.com/john](http://www.website.com/john), for example. This would have numerous valuable applications for links, display fields, buttons, etc. ---
**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:** [October 2, 2023, 1:21am UTC](https://community.glideapps.com/t/create-custom-links-based-on-static-and-dynamic-data/66686/2 "2023-10-02T01:21:25Z")
> [@Joshua\_Mentrup](#): > > it would be great to be able to display $100 instead of just 100 in the Glide App. You can do this with number column formatting in Glide > [@Joshua\_Mentrup](#): > > so the field would consist of a static part ([www.website.com](http://www.website.com)) and the dynamic part from the data table (username=john) and it would link to [www.website.com/john](http://www.website.com/john), for example. You can do this with a template column in Glide. ---
**Author:** ![Joshua\_Mentrup](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joshua_mentrup/32/54600_2.png) [@Joshua\_Mentrup](https://community.glideapps.com/u/Joshua_Mentrup)\ **Post date:** [October 2, 2023, 1:35am UTC](https://community.glideapps.com/t/create-custom-links-based-on-static-and-dynamic-data/66686/3 "2023-10-02T01:35:34Z")
That’s true, but not if all the data is stored in a Google Sheet. What you mentioned only works with Glide columns, but there’s no option to format in the app itself. ---
**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:** [October 2, 2023, 1:38am UTC](https://community.glideapps.com/t/create-custom-links-based-on-static-and-dynamic-data/66686/4 "2023-10-02T01:38:59Z")
---
**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:** [October 2, 2023, 1:39am UTC](https://community.glideapps.com/t/create-custom-links-based-on-static-and-dynamic-data/66686/5 "2023-10-02T01:39:14Z")
> [@litter\_in\_bin\_sign Trash your Excel Formulas](https://community.glideapps.com/t/trash-your-excel-formulas/55788): > > wave Hey Gliders! By request, I created a video that explains how to replace 14 commonly used Google Sheet/Excel Formulas using Glide computed columns and other native Glide functionality. Formulas are timestamped in the description. For good measure, I also threw in how to use the Excel Formula plugin column upside_down_facepopcorn Enjoy! [[Glide: Replace 14 Excel Formulas with Glide Computed Columns] ](https://www.youtube.com/watch?v=YITKadLUKNE) ---
**Author:** ![Joshua\_Mentrup](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joshua_mentrup/32/54600_2.png) [@Joshua\_Mentrup](https://community.glideapps.com/u/Joshua_Mentrup)\ **Post date:** [October 4, 2023, 5:40am UTC](https://community.glideapps.com/t/create-custom-links-based-on-static-and-dynamic-data/66686/6 "2023-10-04T05:40:06Z")
This is great, thank you! I didn’t know that such columns could be created without affecting the Google Sheet. I guess that’s why you’re the expert! 😃 ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [October 11, 2023, 5:40am UTC](https://community.glideapps.com/t/create-custom-links-based-on-static-and-dynamic-data/66686/7 "2023-10-11T05:40:44Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.