FileMaker Forum RSS Stream

Adding Family Members

Thu, 24 May 2012 01:23:52 +0000

My client's members can own boats in a number of classes. I have a Members table, a join table Class Member Data, and a Classes table. This has worked great for years.

Now the client has decided that family members of a Member should be identified as separate owners of class boats. Until now, family members have been identified in a separate Family table (related to the Members table by Members::membershipNumber = Family::membershipNumber).

I am not sure how to modify my solution to accommodate this. Should family members be moved to the Members table with a flag field that indicates that they should not be considered as full members for other purposes (voting, magazine mailing list, etc)? Or is there a way to link the Family table to Class Member Data in such a way as to identify both Members and Family as Class Members?

Script_Save pdf_Set Field Value on a g_Find

Thu, 24 May 2012 01:06:14 +0000

I am trying to write a script to save an Invoice pdf.

Manually the steps are:

Step 1: Go to Layout xyz
- xyz layout is a list layout, based on a Lines Table.

on layout xyz there is a find script that selects all lines related to an InvoiceID.

Step 2: Set field g_Find_InvoiceID
- this is a drop down value list based on a field, c_Find_InvoiceID that finds all Invoice ID

Step 3: Run script

This script is:
Enter Find
Set Field:(INVOICES:: kp_InvoiceID; LINES::g_Find Lines_InvoiceID)
Perform Find

Step 4:
I save as pdf

Is it possible to automate these steps from the Invoices layout where the g_Find InvoiceID is automatically set to current value of kp_InvoiceID on the Invoices layout?

I am using the Lines layout to produce an Invoice ID because it allows me to create a continuous Invoice using the Invoice portal data that page breaks appropriately.

Thanks
Matthew

Summarize just the shown contents of a portal.

Thu, 24 May 2012 00:34:08 +0000

I have a print form set up to print multiple pages. It uses several tabs, showing the related records in a portal with a finite number of rows on each (1-25, then 25-50, etc.), and the print script switches tabs as needed for the count of related items.

I now need to place a quantity total below on each tab, summarizing just the quantity field from related records of the portal range shown on that one tab.
So I need to a field to calc sum(quantity) from related records 1-25, and another for 25-50.

Trying to find something more graceful than a written out Get Nth, given I am recursive-challenged.

No sort on the portal, this is just based on count 'range' of related records as entered order.
This is real just about summarizing the records by range, and the portal itself is irrelevant.

Of note, it's a preprinted triplicate form on a roll fed strike printer, and requires precise graphic alignment, so would prefer to maintain the tabbed pagination rather than redo and face alignment issues to utilize summary breaks just for this one new addition.

Check if a file exists

Wed, 23 May 2012 23:46:01 +0000

I have these two columns: "products_model" and "products_image". The "products_image" takes the model number and adds ".jpg". Works fine, but it generates this for ALL records. I only want it to write the string for products for which I really have an image.

"products_image" is an calculation field: "covers/" & Products::MANUFACTURER & "/" & Products::PRODUCT & ".jpg"

Replacing Alphanumeric Values in a string

Wed, 23 May 2012 22:41:36 +0000

Hello, I need to process a string on over 6000+ records and will eventually become an automated routine, basically I need to clean a string which will be implemented in web publishing and I would like to know if there is a way with just 1 step to read a string and replace all the alphanumeric values (meaning a value that contains both numbers and letters) in uppercase.

I already have a custom function that cleans the string based on the on the symbols I don't need.
These would be a few examples of what I need to do:

Original: Ultra2 SCSI Cable
New: ULTRA2 SCSI Cable

Original: CMOS Battery (7.2V, 15Mah)
New: CMOS Battery (7.2V, 15MAH)

Original: 68 To 50pin SCSI Adapter
New: 68 To 50PIN SCSI Adapter

Original: 146.8gb SCSI Hard Drive
New: 146.8GB SCSI Hard Drive

Thanks in advance for the help, if you need further information just let me know.

Error: cURL is required to use the FileMaker API.

Wed, 23 May 2012 22:24:16 +0000

after done the php script lines. i have foud this error on my url (http://localhost/test/connect.php)

Even i have used my ip instead of local host. but the same error found

Error: cURL is required to use the FileMaker API.

Kindly help me some one if you face this problem before..

Getting Distinct ID's

Wed, 23 May 2012 22:18:15 +0000

Love the DISTINCT function of the SQL but trying to figure out how to get the correct set of records.

In a normalized file

member ----< email

there could be one or more duplicate emails in that table.

suppose I am already on the FOUND set in Members, i want a unique list of email addresses - or rather its ID's - i want to go to the related email table keeping the first instance of an email and omitting subsequent duplicates.

I need to end up on the email table so it can export the desired unique found set, that relate to the FOUND set in members.

Savvy?

Thanks

Stephen

iPad 2 Connects to Hosted Databases, iPhone 4 Does Not...

Wed, 23 May 2012 22:08:36 +0000

In testing my FDS version of FileMaker Server 12, I am encountering a problem that I can't resolve. My iPad2 connects to hosted databases, but the iPhone 4 does not. When I try to connect to the hosted databases from the iPhone, I can see the hosted server name, but am asked to "Enter Filename". When I enter the IP and Network File Path (10.0.1.10/RG_Content.fmp12, I get the following error message:

"The file "RG_Content.fmp12" could not be opened. Either the host is not available, or the file is not available on that host"

Yet, I can connect using my iPad 2 without needing to enter the IP and Full Network Path. I have put "10.0.1.10/Databases/RG_Content" without success. I have tried connecting to other databases, including the built-in sample on the Server. No success. Both the iPad and iPhone are running iOS 5.1.1 and FileMaker Go 12. FileMaker Server is version 12.0.1.178. The MacOS X is 10.7.4. I have deleted FileMaker Go on the iPhone 4 and reinstalled it, and re-set the iPhone (twice). Still no success. Am I missing something or doing something wrong? Any input would be gladly appreciated.

Rob

IP Address Change

Wed, 23 May 2012 20:51:12 +0000

Hello All

It is time to change the IP address of my Filemaker 11 server, yet again.

I am wondering if there is a way to use computer name instead of IP address for the external FM database relationships? (ex: \\computer_name instead of \\192.168.2.6)

If I can get this to work, we can change the IP whenever we want, because DNS would take over.

I'm thinking I may need to a 3rd party plugin, but I'm not sure.

Thanks for any advice.

More Portal Sorting with FM12

Wed, 23 May 2012 20:37:41 +0000

With FMP12 we can now sort portals by multiple columns. This demo expands and slightly tweaks some of the scripts from the original portal sorting demo using FMP12 posted here.

Attached Files

Portal_sort_multiple.zip 85.39K 18 downloads

Filemaker 11 Blurry when scrolling in BROWSE

Wed, 23 May 2012 19:59:30 +0000

I know there was a problem in the layout mode that was updated but yesterday we ran the new update 10.7.4 and now the files blur when scrolling until it goes dark. Only inside the database. The FM program frame with headers is unaffected. You can go out of one report to another and it corrects itself when going back to the prior layout, but only until you do another query. Help.....

To show certain data in a portal

Wed, 23 May 2012 19:01:37 +0000

I think it is a matter of relationships but I can’t make it work.

What I’d like to accomplish is:

To show in the portal coloured in red the names of all contacts (only once each contact) related to the properties of a particular building.

Once shown, can I skip them by type of relationship using the portal filter I.e. TypeOfRelationships::Relationship (or whatever fixed table) = "Owner"?

I know is not correct in my sample file, I have just done it to show with an example what I need to accomplish and trying to explain.

Thanks to all for your help.

Attached Files

Relationships.zip 9.16K 6 downloads

Help on creating a new layout

Wed, 23 May 2012 18:49:03 +0000

Ive created my database a few years ago now with two tables: tb_customers and tb_jobinfo. The customers jobs layout displays the customers details and a portal displaying the relevant jobs carried out for that customer over the years. To create a new job, I scroll down the portal to click an empty field and fill in.

I would like to replace this layout showing the customers info as above but then a 2x tab control, first tab displaying 'Current job', in other words the last job entered for that customer. The second tab labeled 'History' which will use a portal to display all previous work.

Because I'm using fields from the tb_jobinfo table in the 'Current Job' tab as a posed to a portal, I dont know how to add a new record.

I would like it to work so as when the 'New Job' button is clicked, the fields on the 'Current Job' tab clear ready to enter a new job for the relevant customer.

I dont know whether this is the right way or anybody else can advise on a different way.

Sub Summary Report needs to show Expenses Line Item from another table

Wed, 23 May 2012 16:49:12 +0000

Hi,

I have a sub summary report showing open projects for my client.

And everything is great; Client, then under the client I show all their open project with a total due.

However, I'm trying to add a sub summary under each project listing all expenses associated to each project. And since each expense is in the Expense Line Items Table how can I build the Sub Summary Report to show each expense listed under their respective project ? Hmm ...

All the tutorials that have visuals ( I need visuals ) show sub summary reporting when all records and field are in one table. There is a tutorial in Filemaker Forms that is really confusing and I can not seem to follow it a this moment. ( No pics )

I tried building the report the other way using calculation and lookup to put information into the Expense Line Items Table, but that only create double data and unnecessary clutter, I would really like to keep my expense table clean.

The best I can get is only one of the line items to show up, please see pic. Totaling the line items per project and adding them to the total project is complete.

Is there a way to show each of the Expense Line Items under each project in my projects table Sub Summary Report ??

Any assistance here would be grateful.

Thank you.

Attached Files

SubSummary.pdf 32.27K 6 downloads

Condtional Valuelists with FM12

Wed, 23 May 2012 16:48:30 +0000

Here is a demo of conditional value lists using FMP12 and ExecuteSQL. In the demo there is one sample of using straight text and another using IDs instead of the text.

There are no relationships between the user interface and the tables of values.

Attached Files

ConditionalVL_SQL.zip 101.27K 9 downloads

Script to clear one field in records displayed through a portal

Wed, 23 May 2012 15:54:27 +0000

Hello again,

I would like to create a script that allows me to clear just one field that are in the recordsdisplayed through a portal. Is this possible? The script I have only clears the field of the active record in the portal, but not the rest of the records that are displayed.

My scenario: I'm looking at Record/Job #123. I have a portal displaying multiple records of all material that was ordered on Job #123. On each material record there is one field called "amount to bill." I would like the option to clear the contents of this one field when I press a button from my Job table.

Please let me know if further clarification is needed and thank you so much ahead of time for the help!

eXCetera BLOG: UPDATED! Drag-n-Drop Using the Separation Model

Wed, 23 May 2012 15:11:39 +0000

Andy Persons of Excelisys has done it again! A revised way for drag and drop using FileMaker 11 & 12!

Get Demo and WhitePaper

The demo includes consolidation of several of the ‘Move’ scripts and removal of extraneous ones. We’ve also included a new approach for the ‘Sort’ technique that removes the need for two adjunct TOs. There have also been various smaller enhancements/cleanup.

This file demonstrates how to use FileMaker Pro’s event-based scripting features to allow the use of drag-and-drop interfaces. It has been updated to demonstrate how to use the technique with the data separation model, as well as streamlining certain elements...

______

Excelisys, Inc. - Custom Design, Development & Consulting for LAN/WAN, Web, & Mobile FileMaker Database Solutions

www.excelisys.com • 866-592-9235

Excelisys is a team of FileMaker Pro™ Certified Consultants & Developers, as well as Web and Mobile Application Designers & Developers. Excelisys has a solid 11-year reputation for breaking through with leading edge GUI design, technical development and business process workflow expertise. We take care of people, businesses, and organizations all over the globe, no matter the size and scope of your project or business. Contact us today for a no-charge initial consultation and estimate!

Scribe save to Supercontainer

Wed, 23 May 2012 15:11:06 +0000

Hi everyone,

I am trying to save a modified file from Scribe to Supercontainer. After the modification, i used ScribeDocSaveFile
to save the document to the folder it originally came from, say:

from Scribedocload ( http://ip:8020/SuperContainer/RawData/docs/foldername
to the same.

I tried variations without RawData and so forth.

Do I have to save to temp and upload via SuperContainer Plugin?

Thanks

How do I disable the mouse scroll wheel from changing records?

Wed, 23 May 2012 14:17:19 +0000

I am using Windows 7 and FMP 11. When I use my mouse scroll, my records change instead of the window scrolling up and down. On a Mac, it scrolls the layout, but on Windows, it changes the records. I've read solutions online that suggest lock/hide status area, but I would prefer to keep the status area on the window. Has anyone come across this problem and found a solution? Thanks in advance!

Record Omission - special case

Wed, 23 May 2012 13:56:07 +0000

Hi.

I have a scenario that I cannot quite resolve and would like to know if anybody can point me in the right direction please.

I have a table with a list of about 500 clients and a unique ID for each. I need some of those clients hidden (by omission) to certain users (logged in) when browsing lists.
Currently I have a global variable with the ID of one or more clients in it, and as the list is opened, if the variable is not empty, then it runs a loop from record 1 to n omitting each record that meets that pattern. It works OK, but as I have several ways of manipulating that list (Live Search etc), it's become a headache to ensure that omission script is run at the right time and not mucking up the other process running.

Is there an easier way to do this please?

Greg

BARCODE4J/scriptmaster example

Wed, 23 May 2012 13:19:07 +0000

Attached is a simple SM example which generates a Code39 and POSTNET barcode using Barcode4J Link . Result is returned as a Container.

This has been tested on Windows and should run on Macs; barcode is saved as a JPEG to temporary folder, then loaded back into a container. It may be possible to instead load it directly into a container, but I wasn't sure how to achieve that. Code39 is trivial since it can be achieved with free fonts, but this may be of interest for POSTNET and other symbologies supported by BARCODE4J.

Be sure to check the JAR on the Code39 example, I forgot to do that before uploading...

Attached Files

1286166403-SM_Barcodes_3.zip 357.23K 224 downloads

Cross File Scripting on Server

Wed, 23 May 2012 11:10:09 +0000

Hello all --

A little while back I moved from: MacOSX FM Server 10 Advanced on MacOSX ... to: FM Server 11 Advanced on Windows. My current production solution is 3 files in a Folder that all "know" about eachother. (In "External Data Sources" they reference eachother by file:xxx).

In Filemaker Server 10 Advanced ... as long as your Files you wanted to "cross file server script" with were in the same folder on the same machine and you use the above "file:xxx" ... you could get away this.

Well since the move to 11 and switching operating systems ... these Server Scripts fail. I can provide the error number ... if you need it ... but this exact same scripts were working fine not to long ago. Anybody have any advice?

Thanks,
--Rich

Get PDF Page Count?

Wed, 23 May 2012 08:07:48 +0000

Between the various tools how would I get the page count of a PDF

iText & ScriptMaster

SuperContainer Plugin

Scribe

How do I change the account user back to admin?

Wed, 23 May 2012 08:05:27 +0000

I am new to FMP and database development. I created an account with data entry privileges only, logged in as that account to see how it works and now I am stuck in my database as that user with limited privileges. I cannot get back in as Admin with full access. How do I get to an option that lets me change the account user back to admin?

Rotate text left or right?

Wed, 23 May 2012 07:29:23 +0000

Okay so do you rotate your text clockwise one quarter to rotate to vertical or do you rotate three times to three quarter position?

Do you like to cock your head to read sideways text to the left or to the right? Does it bother you if the text is the opposite direction?

Now don't you laugh ... I really want to know which way people prefer reading sideways text, such as longer labels on narrow columns.