# Facility to hyperlink based on results of Generic Inquiry functions and Writebacks

**URL:** <https://community.velixo.com/t/facility-to-hyperlink-based-on-results-of-generic-inquiry-functions-and-writebacks/53>\
**Category:** Ideas & Feature Requests\
**Tags:** Acumatica\
**Created:** [March 28, 2024, 12:10am UTC](https://community.velixo.com/t/facility-to-hyperlink-based-on-results-of-generic-inquiry-functions-and-writebacks/53 "2024-03-28T00:10:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jeffrey\_Patch](https://community.velixo.com/user_avatar/community.velixo.com/jeffrey_patch/32/25_2.png) [@Jeffrey\_Patch](https://community.velixo.com/u/Jeffrey_Patch)\
**Post date:** [March 28, 2024, 12:10am UTC](https://community.velixo.com/t/facility-to-hyperlink-based-on-results-of-generic-inquiry-functions-and-writebacks/53/1 "2024-03-28T00:10:11Z")

</div>

It would good if we had a Velixo Function that gave us the url path for the current connection

e.g: //https://_Acumatica Site_//Main?CompanyID=_Acumatica Tenant_&ScreenID=

Then on the Velixo spreadsheet, we could just add the screen name and record parameter(s)

The function would be something like VelixoHyperlink (Connection, Screen, Parameter1, Variable1, Parameter2, Variable2…)

e.g. =VelixoHyperlink( “VelixoDemo”,“GL301000”,“Module”,B13#,“BatchNbr”,B14#)

_This idea had 2 votes on the previous Velixo community._

---

<div class="post-metadata">

**Author:** ![Damien](https://community.velixo.com/letter_avatar_proxy/v4/letter/d/9de053/32.png) [@Damien](https://community.velixo.com/u/Damien)\
**Post date:** [April 2, 2024, 1:24am UTC](https://community.velixo.com/t/facility-to-hyperlink-based-on-results-of-generic-inquiry-functions-and-writebacks/53/2 "2024-04-02T01:24:33Z")

</div>

Hi Jeffrey

This is a great idea! And it’s a funny timing too, as we are about to release a new AR Aging Report Template with custom hyperlinks to records.

This doesn’t require any new Velixo function today, see this example below that uses only the HYPERLINK and CONCAT functions:

 ![](https://community.velixo.com/uploads/default/original/1X/ca9a07e160dd252b5e52641bcce280a9ef803b60.png)

However that needs a hardcoded Instance URL and in some cases for records that also require a DocType, a mapping of document type and their Screen id:

 ![](https://community.velixo.com/uploads/default/original/1X/61006f0f9978422ecfb5baaad4ab4e787be7e3df.png)

Regarding InstanceURL, we are planning to work on such new function which would return the full URL or the parts that users specify on the Connection screen (i.e URL, Tenant).

I hope this helps.