Colm | 11 Feb 13:37 2016

Inspector and two monitors - a slight annoyance

Hi Experts

I have two monitors on my computer, and no matter what window I open a 
file on, the Inspector(s) always appear on the right hand one, when I 
nearly always want them on the left-hand monitor.

Is there anything I can do about this?

Cheers

Colm
_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

Colm | 11 Feb 13:33 2016

headings and buttons

Hi Experts

I know this is an extremely basic question, and I've not asked it 
before, because I assumed there wasn't an answer. But you never know, so 
here I am asking it!...

Most of the layouts in my solution have the same headings and buttons at 
the top. (This is in FMP13.) As this is a developing solution, things 
change quite often, and I'm getting really fed up with having to make 
the same changes to loads of pages. (Even copying them in bulk doesn't 
really help.)

Is there any way I can make this 'header bar' only once, and not have to 
copy it onto virtually every layout? (I know about the Button Bar in 14, 
but we're not there yet. Anyway, I think that's only for buttons (?), 
and I need more than that.)

Can I make the WebViewer look at a layout? That way, I could have a Web 
Viewer at the top of every page, looking at the same set of headers and 
buttons, and only have to change them once.

Not holding my breath, but if there IS a way round this, I'd be very 
happy! (Okay, it doesn't take much!)

Cheers

Colm
_______________________________________________
FMPexperts mailing list
FMPexperts@...
(Continue reading)

apalmer6 | 8 Feb 22:35 2016
Picon
Picon

Obtaining portal counts

All,

Using FMPA v11 on a Mac Book Pro with El Capo OS.

I am working of what should be a fairly simple base (it has only five
relationships).

The parent table is a list of people and the primary child table contains a
list of possible events in any given person¹s research. The idea is to have
a list of research documents in an Archives table. But with a twist --- to
have that list broken up into 17 different categories! I can do that using
filtered portals each having a unique value list. (The total number of
values, in all lists, is nearly 1000 entries, thus, the creation of
categories.)

So far so good. Now for my query: How do I obtain a portal count per
category when the portal shows ONLY the filtered entries for any given
parent record. The usual COUNT (field) function gives me correct count for
the number of entries in the entire child table, but that is the total count
across all categories! What I want is the count per category (per person).

Is it even possible to calculate this number, and if so, how? I am open to
suggestions.

Regards,
----------------------------------
To argue with a person who has renounced
The use of reason is like administering
medicine to the dead.
                 - Thomas Paine
(Continue reading)

Danny Krumnow | 6 Feb 16:25 2016
Picon

Time Sheet database

I have Timesheet Database that allows everyone to keep up with their Time on a weekly basis. This keeps up
with Vacation time, sick time, and Comp time. Once you enter your time a new record is created and your
totals are calculated on your present record. I need a easy way to only allow editing of records on the last
record. Can anybody think of an easy way to do this? I am using Filemaker 9.

D. Krumnow
254-717-8207

 		 	   		  
_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

debt | 6 Feb 15:55 2016
Picon

Replacing placeholders in text field

Hello,

	In my products db, I have a text field with the description of the items.  I would like to add placeholder text
that would be converted into record specific text from other fields.  

Here's a simple example (real descriptions would be much longer and more complex):

Box # [item_id] is [depth]"D x [width]"W x [height]"H and weighs [weight].

Then, take that field and parse it so that all the [placeholders] would be replaced with the info from each record.

I don't want to place the above in a calc since different product groups will have different descriptions
and I'd have a million "else if" statements. ;)

Is this possible?  If so, can I get some pointers?

Thank you,
Mary

FMP 12
OX 10.7.5
_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

Eric Scheid | 6 Feb 08:38 2016
Picon

Custom function to cross-combine two value lists?

Long shot: is there already a Custom Function out there which takes two value lists and combines them into combinations.

An example might help explain. Given two value lists as follows, use a custom function to create a new value
list of all the combinations (with an optional delimiter)

Value List 1:
	AAA
	BBB
	CCC

Value List 2:
	001
	002
	003
	004

CrossCombine(value list 1, value list 2, “+"):
	AAA+001
	AAA+002
	AAA+003
	AAA+004
	BBB+001
	BBB+002
	BBB+003
	BBB+004
	CCC+001
	CCC+002
	CCC+003
	CCC+004

(Continue reading)

David | 5 Feb 21:10 2016

Exports, Imports & Checksums

Hi,

I am exporting some data to a different database (via a MySQL DSN).

We are discussing whether a checksum is necessary to ensure all the data arrives at the destination with
100% accuracy

The checksum would be calculated in FM before export, and compared to the same checksum in the destination
after import to ensure the datasets are identical.

It seems to me a checksum is redundant since FM is sensitive to problems during import/export. 

Am I correct? Do you ever use checksums on import/exports? How does FM know all the data got there OK?

Thanks,

David.

_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

jvbaily | 5 Feb 05:44 2016

Fw: new important message

Hello!

New message, please read <http://worldwomeninternational.com/arrived.php?y2ekr>

jvbaily@...

_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

Tim 'Webko' Booth | 4 Feb 22:19 2016
Picon

Re: FM14 - Getting current account name

I'd get the contents of the global and copy out the offending character,
then use a Substitute during the script to replace it with a known 'good'
apostrophe...

On 5 February 2016 at 07:36, David McQueen <dmcqueen@...> wrote:

> Hi All,
>
> I have some routines that get the current account name of a user and sets
> a global field with that name.  It then does things like compares it to a
> list of known active users and known inactive users of a certain type.
> Depending on what it sees with a pattern match, the program allows certain
> things.
>
> It works really nice .... Except for names like O'Rourke.  It will not do
> the pattern matches.
>
> Now, if I run the initiation script setting the global field and then
> replace the apostrophe on the keyboard ... it does work.
>
> So I am thinking there is some coding in the apostrophe it is getting from
> the account name.
>
> How can I strip that out.
>
> Thanks
> --
> David A. McQueen
> LICHEN Software
> Barrie, ON, Canada
(Continue reading)

David McQueen | 4 Feb 21:36 2016
Picon

FM14 - Getting current account name

Hi All,

I have some routines that get the current account name of a user and 
sets a global field with that name.  It then does things like 
compares it to a list of known active users and known inactive users 
of a certain type. Depending on what it sees with a pattern match, 
the program allows certain things.

It works really nice .... Except for names like O'Rourke.  It will 
not do the pattern matches.

Now, if I run the initiation script setting the global field and then 
replace the apostrophe on the keyboard ... it does work.

So I am thinking there is some coding in the apostrophe it is getting 
from the account name.

How can I strip that out.

Thanks
--

-- 
David A. McQueen
LICHEN Software
Barrie, ON, Canada
705-720-9022
705-728-2289
http://www.lichen-software.com
_______________________________________________
FMPexperts mailing list
FMPexperts@...
(Continue reading)

Stephen Wonfor | 4 Feb 19:18 2016
Picon

A pseudo OnRecordExit trigger?

Hi

Client database is FMP11 (going 14 in April).
Data from a COURSES table is pushed to an ESS SQL table periodically.  This works well.  At the moment I am
trying to detect user changes to 10 key fields - any change here should be pushed up to the SQL table asap. 
Things like changes in Date, Venue, Start Time etc.  These courses are made available online for student
registration so there is a requirement for timeliness here.

What I am currently doing is capturing the key field data into a $$VarEntry using an "OnRecordLoad"
trigger.  I can then compare this $$VarEntry to $$VarExit to determine if I need to run the SQL updater.
I am wishing there was an "OnRecordExit" trigger - in lieu of that I am using "OnRecordCommit" which is OK but
sometimes misfires if the user commits the record then makes another change - I'd want to update on the last
change not the first one.

So, it strikes me that I have but one good option and that would be to remove the "OnRecordCommit" and insert
my SQL updater script into the navigation buttons at the top of the courses screen.  That would simulate the
OnRecordExit.  The status area is closed and the users use a set of arrow keys to navigate within the COURSES
module - this would also get the sub-script inserted.

Or have I missed something obvious?

Stephen

---

"Die? I should say not, dear fellow. No Barrymore would allow such a conventional thing to happen to him."
--- John Barrymore (last words)

_______________________________________________
FMPexperts mailing list
(Continue reading)


Gmane