tylertul

Got it. Thanks Commit. Tyler

Thanks LaRetta! I just updated my profile as you suggested. Comment. I think you just nailed it. That makes sense. I bet Windows 7 is doing it and storing the file that it retrieves in a temp folder them somehow Filemaker is being told that location by the OS and bam it imports. Same thing is NOT happening as a scripted import. Thanks for the suggestion. Does someone have a link to a post or a suggestion for the simplest way to script an import from a web-based .CSV file into Filemaker? I imagine it is the same for and excel file as well. I'll keep digging for sure. Just thought I would ask in case someone could paste a link or something. Really appreciate your help over the past 11 years when I have needed it!

FileMaker 11 and it doesn't have import from URL. What works fine is file menu > import > past the url into field that asks for location of file > open button (or maybe it says import) it it will import the data from google drive into a table just fine. If you try and do the same through a url script step it complains about the url not being a valid location (or says something similar)

I can manually import a .csv URL from the web just fine. Works every time. Why can't I script it to import that same URL? Thanks! An example (not a real URL) is: https://docs.google.com/spreadsheets/d/16irOtO503scu0pKguIzYSM0PTu1oc7rvY7Y/export?gid=0&format=csv

Mr. Vodka (My favorite drink as well) Thanks for helping : I have explored using a portal but I need to be able to filter on sub data. That appears to be very tricky. For example: I want to build a layout based on SCHOOL and on it have a portal based on CLASSES. I then want to filter the portal to show me only what classes are about the subject "History" that are in a ROOM with a projector in it. I know I need another g_equipment and it seems like it should be in the SCHOOL table but I am not sure how to relate it to the ROOMS table to be able to display and filter data from the CLASSES table and related info (equipment) from the ROOMS table on the same portal row on the layout based on the SCHOOL table. SCHOOL TABLE g_subject CLASSES TABLE subject (many to many related to SCHOOL by g_subject) fk_rooms ROOMS TABLE pk_rooms (related to CLASSES by fk_rooms) equipment

Thanks for the assistance Barbara! I am experimenting with your suggested structure. In the mean time a couple of quick questions. 1) I am unfamiliar with applications for join tables. Is the need for a join table determined primarily or solely by the need to have a many to many relationship? 2) You are most likely correct in that I need to change my data structure and again I am working on that. At the same time I am trying to understand a principle in my original question. Can you give me any clarity on that? (i.e. How can you show the results of a search in a list view that was based on data a few relationships down the road? Without using a portal. I need to do quite a few different types of filtering and searching on the data and don't think that a portal is the way to go because of complexity and limitations on filtering by criteria that is a few relationships away from the primary data.) Thanks again! ~ Tyler

Hello, I am overlooking something very obvious here. Any help would be much appreciated. I have 3 tables: Teachers->Students->Classes I have a list view layout based on the Teachers table. I have fields from all 3 tables in the list view. In the Classes table there are 2 fields: Subject and Description. I have 1 teacher record related to one student record related to 2 class records. - The 1st class record - Subject field contents: "Science" Description field contacts: "Hard Class" - The 2nd class record - Subject field contents: "Math" Description field contacts: "Easy Class" PROBLEM: When I am on the Teachers layout (List view) and search the field Classes::Description for the word "Easy" it does what I would expect, it shows the student record that is it related to but... It shows the 1st record of the two related class records (i.e. Subject: "Science" Description "Hard Class") QUESTION: How can I get it to show the related record for the which the match was based on (i.e. Subject: "Math" Description "Easy Class") in the list view. Thanks!

How do I open an excel workbook to a specific worksheet whose name matches the contents of a field in FM7? I have tried to use a hyperlink but can't get FM to pass worksheet i.e. c:/workbook.xls#sheetname I also tried using the Send Event script step but couldn't get it to pass the worksheet name either. How can this be done using VB Script or ANY other solution? Again, I need to pass the contents of a field in FM7 to some soft of external script that will select and display an Excel worksheet of the same name as the contents of the field. Thanks in advance! ~ Tyler

Thanks! I'll post something over there as well. Any other suggestions? Thanks again, ~ Tyler

How do I open an excel workbook to a specific worksheet whose name matches the contents of a field in FM7? I have tried to use a hyperlink but can't get FM to pass worksheet i.e. c:/workbook.xls#sheetname Thanks!

Perfect! Thanks a million Lee. I knew I had my head wrapped around that one incorrectly!

I have been struggling with this one for about 8 hours! Please help... I have a container field that is on a portal row. There is a field on the portal row that has a transaction date. These dates are not always the 1st of the month but the 1st of each month is when tuition is due. I think I need to round each date entry to the first of the month for the calculation for starters. The first line of the script below seems to work. Also I have named the date field "Month" I hope that is not a problem. What I need is a calculation that will show a global container field when today’s date is 10 days away from the end of the month. To better describe the scenario... Dec tuition is on a portal row Nov tuition is on the row below it I have gDue on the portal row so that the current month's tuition in the portal row will have a little "Due" graphic on it. The tricky part for me is that I need it to show on the December portal row starting 10 days before December 1st. Then it would show on the December row each day until today is 10 days before Jan and then it would show on the January row. Thanks in advance for any ideas you may have. The last failed attempt I came up with is below. GetAsDate(Date(Month(Month); 1; Year(Month))) = GetAsDate(Date(Month(Get(CurrentDate))+1; -10; Year(Get(CurrentDate)))) ; gDue ;nothing) ~ Tyler

Perfect Sam! Thanks for all the help. I am interested in seeing if we can develop a scheduling solution that needs to support recurring weekly appointments with occasional exceptions and have a nice weekly calendar overview. Currently we use excel for this. I want it to tie in with the accounting solution that I am currently finishing up. I don't think I have the expertise to do this. Again we are just exploring the idea and don't have s big budget or anything but if you would be interested and feel like you could create or co-create a solution let me know. you can go to the website above and email me from there if so. Thanks again for your help! ~ Tyler

Thanks Comment!

Comment, Thanks a million! I had tried the same approach but had put the field in the transactions table instead of the clients table and it just gave me the sum of a single transaction. Makes sense now. At what point do you think we will get bogged down using this? 1000 records, 100,000 records? And what would be the way to do this after we have too many records? Just a tip as to where to look in the future would be great! I'll keep notes. Thanks, Tyler