# How to pass multiple field values of a table to URL **URL:** \ **Category:** Kibana\ **Created:** [May 17, 2017, 4:12pm UTC](https://discuss.elastic.co/t/how-to-pass-multiple-field-values-of-a-table-to-url/86143 "2017-05-17T16:12:56Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![kabali12345](https://avatars.discourse-cdn.com/v4/letter/k/6a8cbe/32.png) [@kabali12345](https://discuss.elastic.co/u/kabali12345)\ **Post date:** [May 17, 2017, 4:12pm UTC](https://discuss.elastic.co/t/how-to-pass-multiple-field-values-of-a-table-to-url/86143/1 "2017-05-17T16:12:56Z")
how to pass multiple field values of a table to URL where i am able to pass a single field value ```auto http://example.com/{{rawValue}}/ ``` but i want pass two field values to URL is there any way for that to do.....? Thanks ---
**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\ **Post date:** [May 17, 2017, 4:49pm UTC](https://discuss.elastic.co/t/how-to-pass-multiple-field-values-of-a-table-to-url/86143/2 "2017-05-17T16:49:06Z")
@kabali12345 Using the URL Field formatter to do so isn't possible; however, you should be able to do so using [Scripted Fields](https://www.elastic.co/guide/en/kibana/current/scripted-fields.html) ---
**Author:** ![kabali12345](https://avatars.discourse-cdn.com/v4/letter/k/6a8cbe/32.png) [@kabali12345](https://discuss.elastic.co/u/kabali12345)\ **Post date:** [May 18, 2017, 7:44am UTC](https://discuss.elastic.co/t/how-to-pass-multiple-field-values-of-a-table-to-url/86143/3 "2017-05-18T07:44:44Z")
Got it. Thank you very much. ---
**Author:** ![sravya](https://avatars.discourse-cdn.com/v4/letter/s/b5a626/32.png) [@sravya](https://discuss.elastic.co/u/sravya)\ **Post date:** [May 19, 2017, 11:52am UTC](https://discuss.elastic.co/t/how-to-pass-multiple-field-values-of-a-table-to-url/86143/4 "2017-05-19T11:52:16Z")
hii@Brandon\_Kobel can you please share some more details to me ---
**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\ **Post date:** [May 19, 2017, 12:56pm UTC](https://discuss.elastic.co/t/how-to-pass-multiple-field-values-of-a-table-to-url/86143/5 "2017-05-19T12:56:04Z")
@sravya the URL Field formatters work against a single Field in a document. However, you can use Scripted Fields to do more advanced logic, including string concatenation. ---
**Author:** ![softec17](https://avatars.discourse-cdn.com/v4/letter/s/4af34b/32.png) [@softec17](https://discuss.elastic.co/u/softec17)\ **Post date:** [May 19, 2017, 1:31pm UTC](https://discuss.elastic.co/t/how-to-pass-multiple-field-values-of-a-table-to-url/86143/6 "2017-05-19T13:31:35Z")
hello@Brandon\_Kobel, can you please elaborate and show me an example ---
**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\ **Post date:** [May 19, 2017, 2:39pm UTC](https://discuss.elastic.co/t/how-to-pass-multiple-field-values-of-a-table-to-url/86143/7 "2017-05-19T14:39:34Z")
@softec17 @sravya to create a Scripted Field, you select Management -\> Index Patterns ![](https://us1.discourse-cdn.com/elastic/original/3X/9/9/999da3cdc22918ea0c21aa14d95d295e73d0bf1d.png) And then Scripted Fields -\> Add Scripted Field ![](https://us1.discourse-cdn.com/elastic/original/3X/9/5/952c698241ea22454cfc8ad88af1fac2ebf47da0.png) If you create a scripted field with a Type of "string", a Format of "url" and the Script of: `'http://testwebsite.com/' + doc['geo.dest'].value + '/' + doc['geo.src'].value` it'll create a URL using two fields from the document ![](https://us1.discourse-cdn.com/elastic/original/3X/1/3/13f06e614cb0fb70b5154ca449e0f20bd104dc3c.png) ---
**Author:** ![softec17](https://avatars.discourse-cdn.com/v4/letter/s/4af34b/32.png) [@softec17](https://discuss.elastic.co/u/softec17)\ **Post date:** [May 19, 2017, 3:39pm UTC](https://discuss.elastic.co/t/how-to-pass-multiple-field-values-of-a-table-to-url/86143/8 "2017-05-19T15:39:58Z")
i followed all the steps you suggested me but i am getting an error in discover field ![](https://us1.discourse-cdn.com/elastic/original/3X/6/1/61c869e67841afbbe3b02ffb785365fc2aa32eda.png) ![](https://us1.discourse-cdn.com/elastic/original/3X/7/a/7a195fa95e010f032abd36e4cb5ddf694783161e.png) ---
**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\ **Post date:** [May 19, 2017, 4:44pm UTC](https://discuss.elastic.co/t/how-to-pass-multiple-field-values-of-a-table-to-url/86143/9 "2017-05-19T16:44:44Z")
@softec17 that warning/error that you're seeing in Discover doesn't appear to be related to the Scripted Field, but because a shard failed when executing the query. If you remove the scripted field, do you still see the warning/error? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 19, 2017, 8:13am UTC](https://discuss.elastic.co/t/how-to-pass-multiple-field-values-of-a-table-to-url/86143/11 "2017-06-19T08:13:09Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.