FileMaker Forum RSS Stream

Layout Part not moving up

Thu, 23 Feb 2012 00:53:32 +0000

Hi Forum.

I have a Layout like this:

<>
<>
SOME FIXED TEXT

[a single field] [another single field]

singletextfield2 is a sizeable box 500 height x 150 width and it can contain one single or multiple lines of text.
Thats why i make <> and SOME FIXED TEXT "Sliding up based on, all objects above as well as, Also resize enclosing part".
However when the field only contains one line, the space left between SOME FIXED TEXT and the first line of the Body is still about 450 px high.

Am I doing something wrong? I want he header to contract with the field and its not doing that, essentially the header is staying exactly the same height, all the time.

FM 11v03

Thanks for any tipps
Spongebob

Find a previous Year

Thu, 23 Feb 2012 00:43:34 +0000

I would like to have a pull down or even a selct list to click on to have the system go out and find previous year. I already have a script for current year. thanks in advance.

Many to many relationship (noob)

Thu, 23 Feb 2012 00:35:17 +0000

Ok, I guess this is a really basic question so sorry, but I'm not able to find it exactly.

I just want to have 2 tables.
STUDENTS with the typical personal data (name, address, phone, etc)
COURSES with the name of the course, the hours, teacher, etc.

A Student should be able to attend to multiple Courses and also, a Course can have multiple Students. The idea is to show a portal on a presentation for each table.

I know how to make it "one to many" but not both sides.

Thank you very much!

Validate Text in all Records by Checking Against a List

Thu, 23 Feb 2012 00:33:02 +0000

I have a report. One of the fields in this report is EmployeeName, which is auto-populated by the system which generates the report. This field contains user IDs pulled from employee accounts on other in-house systems. There may be some variety. For example, John Doe might sometimes appear in the report as "John Doe," and at other times "JD.." or "jdoe001".

I need a means of maintaining a list of employee names and their various aliases. I suspect a table is more appropriate than a list. This table would contain two fields: EmployeeName and __kp_Alias.

Then I need a script that will systematically check the contents of EmployeeName in all records, and substitute aliases with actual employee names.

I am relatively new to FM, enough that I have built a few simple scripts, but I have no idea where to begin with this challenge. Can someone point me in the right direction?

Another One to Many to Many conundrum-

Thu, 23 Feb 2012 00:19:08 +0000

If anyone can help shed light on these relationships I would be forever indebted to you. With the help of an FMP expert, I’ve been trying to sort out the best way to set up the relationships between 3-4 tables. But we’ve been going around in circles for a while, and it would be great to get fresh perspectives on how best to do this.

We are focusing on three tables: Content - Projects - Subprojects. Each piece of content can be associated with multiple Projects, some of which have multiple associated Sub-Projects. We currently have a join table connecting Content- Projects, and a direct relationship between Projects-Subprojects. So the set up is: Content - [Join-Content-Projects] - Projects – Subprojects. Additionally, we have second occurrences of Projects and Subprojects and a Join Table btw Content and Sub-projects, and the relationships are: Content – [Join-content-Subprojects] - Subprojects 2 – Projects 2.

This seems to be semi-functional, but it isn’t quite as streamlined as we would like it. We want to be able to A:) Find and Sort Content based on which Project or Subprojects it is associated with. Content will have a Project, but not always a Subproject. B:) We want to be able to set up fields such that when you search for a Project, you can then select Subproject from the related list of that Project’s Subprojects (not the overall list of Subprojects). C:) We want to be able to generate list of Content, and eventually contacts, based on the connection to Projects and Subprojects.

In the Content Layout we have portals to the Projects and Subprojects field, but the fact that we can’t put a portal to Subprojects inside of the portal to Subprojects seems to be making it difficult to tag our data properly.

We will replicate this relationship with our Contacts table as well, so we want to make sure everything is as solid as possible. It doesn’t seem like an unusual set of relationships, but for some reason I’m having a terrible time wrapping my mind around how to make it work. I would appreciate any and all advice anyone can provide!

Best Fonts to Use for Browselist and Data Entry Layouts

Thu, 23 Feb 2012 00:10:17 +0000

Hello all:

I was just wondering what others use for displaying their data on browseslists and data entry screens when building an application for both Windows and Mac clients?

I tend to use Arial, Helvetica or Tahoma.

Thoughts ?

Thanks.

Dom

Problem with emailConnectIMAP on serverSideScript

Thu, 23 Feb 2012 00:07:56 +0000

Script that runs perfectly on client side from a remote computer, or from fmkr client installed on the server, gives me an error every time at the emailConnectIMAP script step.

The error returned is "Login failed."
There is no firewall
The plugin is installed on the server
The emailRegister step is returning properly
I'm running the script with admin privileges

Folder Path Problem

Wed, 22 Feb 2012 23:31:16 +0000

I am trying to save a PDF to a user selected folder using the ScriptMaster Choose Folder but seem to run an issue if the volume name is not included.

ScriptMaster Choose Folder returns:
/Users/myUser/Desktop

Trying to save a PDF using the ScriptMaster supplied path to generate a $pathVariable = filemac:/Users/myUser/Desktop/myfile.pdf generates an error 800 "Can't write file".

To test my pdf path process I tried using FileMaker Get(DesktopPath) which returns:
/Volume/Users/myUser/Desktop/

Save a PDF using the this path to generate a $pathVariable = filemac:/Volume/Users/myUser/Desktop/myfile.pdf works fine.

Is it just the missing volume from the path that is causing the error and how do I get the volume using ScriptMaster?

So far I am working on a Mac but will need to run on Windows as well so I don't know if drive letters will be an issue.

CreateFolder() and abolute path

Wed, 22 Feb 2012 23:23:48 +0000

Hello,

working on Mac with FMP 11.

I'm developping a db to help creating MS Word documents we'll have to put in some specific subfolders. To create these subfolders I'm trying to use M CreateFolder().

The db will be hosted to be accessed by internet but folders (and documents) must be created on the local hd of each user.
So, I try to use absolute (instead of relative) paths in createfolder parameter but it doesn't work.
My hard disk is called 'HD 2' so i've tried :
- /hd 2/Users/pro/thedbase/thenewfolder
- /hd 2/Users/pro/thedbase/thenewfolder/
- hd 2/Users/pro/thedbase/thenewfolder
- hd 2/Users/pro/thedbase/thenewfolder/
- filemac:/hd 2/Users/pro/thedbase/thenewfolder
- filemac:/hd 2/Users/pro/thedbase/thenewfolder/
but none of them functions.

Where do i go wrong ?

thanks

Select File () path needs volumeName?

Wed, 22 Feb 2012 23:06:09 +0000

I have just DL'd v 4.

I got it working and have the file and path (OSX) assigned to a variable: $$SelectImportFile .

I try and use $$SelectImportFile as the File Source variable specified in the Specify data source dialog.

FM DOES NOT IMPORT / FIND the file? I thought perhaps I need to specify the volumeName in addition to the path and file name?

If so, how can I get the volumeName to append to the path? (concatination is the method I presume).

Thanks

Can't get FMSkipRecords to work correctly

Wed, 22 Feb 2012 22:48:38 +0000

I'm attempting to use a form to allow users to narrow/filter results when searching our tech request system because we have quiet a few entries in our database. I'm hoping to return 15-20 requests per page and allow the user to use the FMSkipRecord feature to navigate through their returned results sorting the returned results by date/time modified. However when I perform a search that yields more than 15 results and click "next" the page loads a records found: 0, Displaying Records 1 through 0 result.

Here is the code:

// Inialize session
session_start();

// Value(s) from search_request.php
$completed = $_POST['completed'];
$database = $_POST['database'];
$lastname = $_POST['lastname'];
$description = $_POST['description'];
$school = $_POST['school'];
$problem = $_POST['problem'];
$assigned = $_POST['assigned'];

//Find number of records to skip and set Groupsize
if (! isset($skip) || $skip == '') {$skip = 0;}
if (! isset($FXE_groupSize) || strlen(trim($FXE_groupSize)) == 0) $FXE_groupSize = 15;

$query = new FX($serverIP, $webCompanionPort, $dataSourceType);
$query->SetDBData ("$database", "Main", "$FXE_groupSize");
$query->FMSkipRecords($skip);
$query->SetDBUserPass ($webUN, $webPW);
$query->AddDBParam('Completed?', $completed,'eq');
$query->AddDBParam('Last', $lastname, 'cn');
$query->AddDBParam('Description', $description,'cn');
$query->AddDBParam('School', $school,'eq');
$query->AddDBParam('Type', $problem,'eq');
$query->AddDBParam('Assigned_to', $assigned,'eq');
$query->AddSortParam ('Date Modified','descending'); // Sort by Date Modified
$query->AddSortParam ('Time Modified','descending'); // Sort by Time Modified
$result = $query->FMFind();
$records = $result['data'];
?>

In the HTML body:

echo '

Records Found: ' .$result['foundCount'].'

';
echo '

Displaying Records ' . ($skip + 1) . ' through ' . min(($skip + $FXE_groupSize), $result['foundCount'].'

');
echo '
';

if (strlen($result['linkPrevious']) < 1) {echo "Prev\n";}
else {echo 'Prev\n";}

if (strlen($result['linkNext']) < 1) {echo "Next\n";}
else {echo 'Next\n";}

foreach ($result['data'] as $key => $value) {

// Begin the Search Table

echo '';
echo '';
echo '';
echo '';
echo '';
echo '';
echo '';
echo '';
echo '';

echo '';
echo '';
echo '';
echo '';
echo '';
echo '';
echo '';
echo '';
echo '';
echo '';
echo '';
echo '';
echo '';
echo '

';
}
echo '

Job Priority: '.$value['Priority'][0].'
Job #	Submitted By	School - Location	Type of Problem	Equipment
'.$value['Job_Code'][0].'	'.$value['First'][0].' '.$value['Last'][0]. ' - '.$value['Phone'][0].'	'.$value['School'][0]. ' - '.$value['Location'][0].'	'.$value['Type'][0].'	'.$value['Machine_Type'][0].'
On '.$value['Date submitted'][0].' '.$value['First'][0].' Wrote: '.$value['Description'][0].' Currently Assigned to: '.$value['Assigned_to'][0].'
'.nl2br($value['Comments'][0]).'

';
?>

It finds the right number of records to begin with i.e., it will state records found 20, displaying 1 through 15 records, however it just won't advance/backup any additional records. Thank you. Ken

$$Variable for Current Year

Wed, 22 Feb 2012 21:57:05 +0000

Hi, I have quite a few scripts that perform finds for "2011" as a text field.

Is it possible to make a global variable $$CurrentYear so that I don't have to manually go through all these scripts every year and update the year number to the current year.

Thanks,
jim

Problem starting/stoping

Wed, 22 Feb 2012 21:13:52 +0000

I have a FileMaker Server Advanced 11 installed on a Mac Mini with OSX Lion Server, after install the SuperContainer (in automatic and manual mode) I can`t get login to http://serverAddress/SuperContainer. I get this message: Problem starting/stoping: Couldn`t get lock for /Users/Shared/SuperContainer/SuperContainer.log
I need help with this problem, anybody help me?
I tried with the first and second option of installation what describes the SuperContainer Documentation.

Thanks so much
Alexander Chozo

Portal: open webviewer from Portal?

Wed, 22 Feb 2012 21:08:43 +0000

Hi,

I have a portal with PDF files (SC container as unstored calc) on Layout A . How do I show the PDF from the Portal in a webviewer on the same layout A?

PS: I only know the basics of scripting...

SC Installation problem - can't view images remotely

Wed, 22 Feb 2012 21:03:51 +0000

I've installed SC on numerous PCs and Macs, but am having a problem getting it to work at one client site. SC works fine in the office, but we just can't see images remotely.

The only thing that is different at this site is that SC is hosted on Mac Server. The host is running FileMaker Pro 11 v4. We have the latest version of SuperContainerserver.jar, we've opened port 80 and have verified that it is open via CanYouSeeMe.org. In System Preferences we have Web Sharing turned on.

Is there some special setting for Mac Server? What setup step have I possibly overlooked?

Thank you for your time and assistance,
Will

Refresh Image Thumbnails

Wed, 22 Feb 2012 20:56:09 +0000

Hi.
we have SC running in a mac only networked environment ( sc running on osx server with shared standard filemaker copy running on the server) and are using it for databasing images. All is working well, using the standard setup, within filemaker, using web viewer and plugin. When a user double clicks an image i have set their local mac osx to open the image in the preview App. From here they can make simple changes and hit save which saves the image back to the server. However the thumbnail displayed in the web-viewer does not show the changes, is there a way to refresh the thumbnail image?
thanks

Problem with SCMove

Wed, 22 Feb 2012 20:52:39 +0000

Hello,

I am trying to use the SCMove function to move a file from one directory to another inside my SuperContainer location. Currently my function call looks something like this:

SCMove("WorkingDirectory/UniqueResourceDirectory/","TargetDirectory/"&TABLE::ID)

When I run my script, I get an error, and the supercontainer server says:

Move operation failed: java.io.FileNotFoundException: No SuperContainer file for /WorkingDirectory/UniqueResourceDirectory
No SuperContainer file for /WorkingDirectory/UniqueResourceDirectory

I have also tried my function call like this:

SCMove("WorkingDirectory/UniqueResourceDirectory/file.pdf","TargetDirectory/"&TABLE::ID)

In which case I get the same error but like this:

Move operation failed: java.io.FileNotFoundException: No SuperContainer file for /WorkingDirectory/UniqueResourceDirectory/file.pdf
No SuperContainer file for /WorkingDirectory/UniqueResourceDirectory/file.pdf

I am stumped, as I have tried many variations on the above themes, putting slashes in different places, with and without the file name, etc.

Can someone help? Or possibly provide a working example of how to call SCMove, since the companion plugin documentation does not have one.

Thanks,
Mark

Short name or long name?

Wed, 22 Feb 2012 19:15:54 +0000

If I use external authentication with a Mac OS X Server, will users login to FileMaker with their short name or their long name, or both?

If I use Get ( AccountName ), will it return the short name, long name, or does it depend on which one they used to login?

One Contact Multiple Companies

Wed, 22 Feb 2012 16:47:51 +0000

Easy straight forward approach to managing contacts is to make Contacts a direct child of Company.
But many times ONE person/contact will be involved with multiple Companies.

So I'm looking for some tips how to set up a oneContact to ManyCompany solution.

I have made a "join" table to connect Contact to Many Companies.
But this makes for an awkward contact creation experience for the user.

i.e.
User is viewing CompanyCogs record and does NOT see Dexter in the related Contacts list/portal.
So User runs a "New Contact" script.
But Dexter ALREADY exist, just has not been tied to CoCogs.
So now system has TWO Dexters.

Any tips or example of this done well?
Thanks!

Clear the Clipboard

Wed, 22 Feb 2012 16:47:32 +0000

Little tip ...

It often happens that we wish to not allow pasting in a field.

It 's simple, just two steps of a script and the trigger OnObjectEnter

Set Selection [ Start Position:1 ]
Copy [ ]

Copyng an empty selection clears the clipboard.

Newbie - autoclose doc scripting conundrum

Wed, 22 Feb 2012 16:17:52 +0000

First off Hi! This is my first post here.

I'm new to database creation and have been working with FM8 pro on a venerable G4 mirror door Mac running Tiger to develop an estimating and works order solution for our small print business.

It took me a while but I found most of the logic quite straightforward and to be fair it still is a work in progress.

The estimator is reasonably versatile and seems to run really well, but occasionally when I'm out of the office there is a need for the document to run on another Mac via file sharing.

All well and good but really I'd like a script to autoclose the file when it's been idle for say 15mins thus allowing it to be opened on another Mac elsewhere in the building and equally when the file has been idle on the second machine for the same amount of time then it too should autoclose.

Bearing in mind I'm as green as they come when it comes to scripts any pointers would be gratefully received.

In return if anyone wants pointers in producing high quality Litho print just ask ;-))

Need Simple FMP Database Written

Wed, 22 Feb 2012 16:13:15 +0000

We need a simple FMP database put together for a small business.

We would provide designs as PSDs or AI files, and you write the database in FMP.

- 20-30 fields (we haven't designed it yet) that keep simple job records
- assign job number
- information on the job needed
- deadlines, whom it's assigned to
- notes and follow up fields
- priority
- list view that sorts in order of priority or deadline
- list view that sorts in order of whom it's assigned to

This will be hosted on a web server so that a few people will have access to it.

We know enough FMP here to be dangerous, and want someone to work on this so it works correctly without us fumbling around.

If your interested in taking on the project, please respond with your email and we will send you the design files.

Thanks,

David

Total Inventory

Wed, 22 Feb 2012 15:38:22 +0000

Hi,
I want to know qty in hand after sold qty according with my database.
I have this tables:
Board:Board_ID,Board_Name,FirstQty,Price,cStockLevel
Invoice:INV_ID,INV_Date,cTotalInvoice
InvoiceLineItem:INL_ID,INV_ID,Board_Name,Qty,Price,cLineTotal

cLineTotal=sum(FirstQty*Price) cTotalInvoice=sum(InvoiceLineItem::cLineTotal) cStockLevel=FirstQty-Sum(InvoiceLineItem::Qty)

I need to know after sold, qty in hand =?

thank you.

Fine tunning this solution

Wed, 22 Feb 2012 14:56:06 +0000

Hi

Attached is a demo containing three tables:

KEYWORDS
VALUES
KEYWORS_VALUES

where if you enter a number (in the KEWYWORDS table) into the fields "Keyword_1" or "Keyword_2", a new entry into a portal is created, when you click outside the fields. To delete an entry in the portal you delete the content of "Keyword_1" or "Keyword_2" and click outside. If you add to a fields content, a new portal is created, and you are no longer able to delete the previously entered portal entry.

Any other suggestions of how to do this? At the moment I'm just making demo files in order to learn some stuff in Filemaker.

Thanks

Attached Files

KEYWORDS.zip 8.68K 5 downloads

Compare records in chart

Wed, 22 Feb 2012 12:19:34 +0000

I have a newbie question. Hoping someone can help me out, or point me in the right direction.

I have a file with two main databases:
1. employees
2. how each employee does in sales per day.

So I have nice lists with a day-to-day sale overview for each employee.

Easy to make a chart for each employee - but I would like to do a graphical comparison as well.

Now I would like to make a layout where I can compare "Employee #1" and "Employee #2" in a "line chart". The chart would have one lines for each employe showing sales over time. The horizontal x-axis would show dates, and the vertical y-axis would show amounts.

The best solution would be a simple finished solution with two drop down menus for choosing two employees - and that this generates a chart. The chart should be look just simple like this:

Does anyone know how do I make this work?

Thanks,
Appleskrott