Forum Discussion

Marcusdahlberg's avatar
Marcusdahlberg
Frequent Visitor
5 years ago
Solved

Change URL with dynamic values based on values in a table

Hi

 

I have a small issue that maybe someone can help me with.

 

I have a report where you can see all transactions that has been done in different accounting accounts, where some of them are payments of various invoices. These invoices are accessible for different user in our company and are stored on an external page/server from the "invoice-company".

 

What i got is a Url from the invoice company that should be a dynamic url, where 2 different values need to be changed so that the link points to the exact correct invoice. 

 

The link looks like this (i changed some just for secutiry reasons): 

https://ourcompany.invoiceprovider.com/viewer/SupplierInvoice$global/P1-001/?VoucherNumber=XXXXXX&InvoiceDate=XXXX-XX-XX. The parts that needs to be dynamic are obviously the XXXXXX that represent the unique voucher number and XXXX-XX-XX is the date for the same voucher.
 
I have the values for VoucherNumer and InvoiceDate in a table that is called "fact_ledg" and in this the values are in colum "VerNr" and "Date".
 
So the part that i would like to get help with is how i do to get these XXXXXX values to change to unique url:s based on "VerNr" and "Date" so that the user can click the link and get access to his/her invoices.
 
Hope you understand what im looking for.
 
Br / Marcus

 

Need Help