Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

FM - Calculated Path for Container Field?

Posted on 2011-02-22
8
Medium Priority
?
779 Views
Last Modified: 2012-05-11
I'm trying to write a calc for a container field so that whatever record I'm on the container will show the appropriate document.  I put the filewin path, but it just produced an shortcut icon (instead of showing the document) and when I clicked on the icon, a dialog box came up saying I didn't have the correct file path (yet I've used this file path in other situations).  See attached.

Also, dragging and dropping doesn't seem to be the answer because:  1) we will have over 700 records, and 2) when you do so, the pdf file shows nicely, but it doesn't give an option to store only a reference to the file.  I tried right-clicking, but this doesn't provide an option to store a reference either.  I've written calc paths for pictures, etc. in a web portal easily; what's the procedure for Container fields?
0
Comment
Question by:rvfowler2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 2

Author Comment

by:rvfowler2
ID: 34956627
Adding image.
-Container.JPG
0
 
LVL 4

Accepted Solution

by:
challengeday earned 1500 total points
ID: 34956711
Hi rvfowler,

Right Click on the Container field and choose "Insert Fie..."

The resulting dialog box has a checkbox for "Store only a reference to the file"

store-reference.jpg
Start playing with a plain container field (not a calculated one).
0
 
LVL 4

Assisted Solution

by:challengeday
challengeday earned 1500 total points
ID: 34956982
Here's an example file. I've used the IncomeExpense database that I had created earlier and added a document feature. Remember this is a quick example, but it should get you started.

 IncomeExpenseExample.fp7
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 2

Author Comment

by:rvfowler2
ID: 34957516
I don't mind doing this to learn, but I don't want to do this 700 x 5 times (that's how many files we have to reference.  I'd rather do it via a calc so they all populate automatically.  I was able to do this with our pictures via a web portal.
0
 
LVL 4

Assisted Solution

by:challengeday
challengeday earned 1500 total points
ID: 34957574
Hmm... How are those 700 X 5 files generated? Autmoatically? If so they could be attached when they are generated. ... Otherwise you could build a script to populate the database... Otherwise you can keep playing and troubleshoot the error you are getting (I haven't played with a calculated container field yet.)
0
 
LVL 2

Author Comment

by:rvfowler2
ID: 34958015
First, each file is generated by scanning it in as a pdf.  Then what I propose is to give it a naming convention, including a folder path by property and then by unit code as you see below.  I just used my calc in a web viewer that I use for images and it worked fine in a web viewer for a pdf file, so why do I even need a container field?  The drag and drop of the latter is nice, but it seems to automatically store it in FM; it does not give you the option of storing it as a reference only.  The following code worked fine in a web viewer.  Why not just use this for the 5 most standard docs, and then use ChallengeDays idea of a document table pulled over in a portal for all other docs?

"file://R:/TNTINFO/" & Tenants::PropCode & Tenants::EntityNum & Tenants::BldingRNum & "/" & Tenants::PropCode & Tenants::UnitCode & "/" & Tenants::PropCode & Tenants::UnitCode & "_InsCert.pdf"
0
 
LVL 2

Author Comment

by:rvfowler2
ID: 34971089
I still don't see the advantage of the container field, since it doesn't seem to take a script like a webviewer (when I use the same script I use for my webviewer in the autocalc of the container field, it just shows an icon and when I doubleclick on it, it says the path is wrong.).  In contrast, the webviewer is showing my pdf docs just fine.  The drag and drop of the container field is nice, but scripting is my first priority since we have 700 records x 5-10 docs each.  Or, maybe use both solutions?  Thanks.
0
 
LVL 2

Author Closing Comment

by:rvfowler2
ID: 35032384
Question not fully answered, but other valuable information received.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question