Thank you for your post.
I am not familiar with Excel. However, if you click on "details", it probably launches a browser and displays a URL. You can then copy that URL and paste it into a field within FileMaker, and then have a Webviewer access that text field to display the details.
Is there anybody out there that has experience with Excel and export of links?
From one "Gal" to another, thanks for your reply! You are correct... when I click on "details," it does display a URL, and I agree that I could copy and past it into my filemaker field. However, there are hundreds and hundreds of rows in my Excel spreadsheet with "detail" in them, and each such "detail" provides me with different details for different cycling clubs. So... manually cutting and pasting all of these would eventually render me cross-eyed. I was hoping there was some "blanket" fix whereby I could convert this entire column of "details" to their respective base links without so much as blinking an eye... but it looks like I may be outta luck. :smileysad:
Also, even if I succeed in converting the hyperlink to a base link and importing it to my Filemaker database, I still have to format the database field properly so that I'm able to view the actual web page. If I type a link into my field right now, it does nothing when I click on it. It seems that there is not an easy way to format these link fields... I'm still trying to figure it out... :smileysad:
I wish I had a copy of excel on my current machine so that I give a more specific response, but it seems possible that you could create a calculation in your Excel file that manipulates the stored hyperlinks into a format that you can import into Filemaker. That would cure the "cross-eyed" syndrome.
Thanks, Phil. Yep - I thought of that, but I'm not very good at Excel calculations and a calculation like the one you mention would be a little complicated for me. I've been looking through Excel's "Help" feature this morning, however, to see if anything might provide me with any insights. Hopefully, I'll figure something out! If I'm successful, then I have to deal with my second problem - how to view the actual websites in Filemaker! Looks like that's going to take another complicated calculation in the calculation field. I think I may just run away... :-P
Maybe you can find a local "Excel Geek" to help you out on that end. He won't need to know filemaker just how to manipulate the contents of the field.
Yep... I'm trying that too! :-P