Save URL to MSDS and TDS - Where?
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
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.