Save URL to MSDS and TDS - Where?

[TheRob]

I have saved a number of materials we regularly buy in the Items List section. I now have a need to download the data to a spreadsheet for use in another app but on that spreadsheet I also need to save a URL to the item's Material Safety Data Sheet (MSDS) and its Technical Data Sheet (TDS). I would like to have used a Custom fields for that but they're only 30 characters long so that's not enough. Does anyone have a suggestion? I am trying to avoid having multiple lists that I need to keep manually synchronised. Keeping it maintained in MYOB and exporting an updated list every now and then is the simplest way I think

Rob

[Neil_M · Accepted solution]

Hi @TheRob 

If its an issue of character count, one possibility is to use a third party service to create shortlinks. So rather than save the full link you can save and use the shortlink, which acts as a redirect to the longer link. There are a number of third party sites that offer this as a service.

As an alternative you could potentially save the URLs in the Notes field of the item. This is unfortunately not an exportable field, however does have a longer length.

[TheRob]

Thanks for the suggestion. Saving it in notes is of no value if it's not able to be downloaded, however creating short URL's is a potential solution that I will explore. Thanks for the suggestion