To_Do_List, Done button!


    Sponsored Links


  • 1. Parsing phone numbers from notes field?
    I am fairly new to FMP and can't figure out how to parse phone numbers from notes field into a separate field. If only the phone number was in the same position or even on the same line. But the phone number always follows either home: or home: BUT it might have 1 or 2 spaces before the actual number. home: 123-456-7891 (1 space after : ) home: 123-456-7891 (2 spaces after : ) phone: 123-456-7891 (1 space after : ) phone: 123-456-7891 (2 spaces after : ) If anyone could point me in the right direction I would be very grateful! Thanks in advance! XXXX@XXXXX.COM
  • 2. Help: Show fields under condition of the input in another field
    Hi, Have been trying to implement following functionality: Radio buton with two choises: A and B If the choise is A then show field X in the same form If the choise is B then show field Y in the same form Sounds simple, but I can't get it to work. Any help would be welcome Thanks John
  • 3. Help Extract Address Newbie
    I am trying to figure out how to parse address information from an HTML file. I have a folder full of aboutus.htm pages that contain information about a companies address. Some look like this ABC Company 123 Main Street Anywhere, FL 81022 and some look like this ABC Company * 123 Main Street * Anywhere * FL * 81022 etc ... they all look a little different. I would like to be able to grab the data and parse it into useful information that I can use to generate a mailing label so that I can send a survey to these companies via regular mail. Is this possible ? This is unstrutured text, it isn't like I am trying to grab e-mail addresses where I could use Middle, Left and Right looking for an "@" sign. How do you do this ? Otherwise I have to do this all by hand and there are 200 of them ! -Squeed

To_Do_List, Done button!

Postby vaggelis » Fri, 23 Oct 2009 23:08:48 GMT

i have a To_DO_ table related with the a Preference table ( key field
in the relationship between these tables is : id_constant)
In my homepage i put a portal that allows me to edit the do_list
without having to go the specific navigation tab button but i cannot
make the Done button work properly. The records i put in my portal
appear in the To_Do list except the Done field( check_icon ). I can
only modify it from the To_Do navigation tab, and not from the portal
in my homepage.. can i do it both ways???

Re: To_Do_List, Done button!

Postby 105 » Sat, 24 Oct 2009 08:06:41 GMT

So you have  a todo portal on two layouts?
the relationship is todo to preference.

are the two layouts defined to the same TOC (table occurance)? If not 
then the relationship will not be valid on both.

Re: To_Do_List, Done button!

Postby Your Name » Sat, 24 Oct 2009 09:41:30 GMT

Yes you can. Make sure the Done field in the Portal is using the correct
Value List and / or running the correct Script.

Helpfull Harry  :o)

Similar Threads:

1.FM buttons, progress bars, icons, menu bars, and vertical buttons

2.Please stop me from doing this!

Hi all.

I'm a drycleaner.  

For the last few months, we have been using a point-of-sale (POS) system 
based on Windows (XP Pro), touchscreens, barcode scanners, thermal 
printers and cash drawers.  We make minimal use of the keyboard and 

The equipment is modern, industry-standard and works well.

The software is a package built on an archaic database and only 
satisfies about 75% of our requirements.  The developer is not very 
responsive and I do not have access to the source code and can't modify 
the application myself.

I'm contemplating writing my own application, using FileMaker Pro.  I've 
been using FM for over 15 years and am confident that I (and other 
resources I have access to) have the knowledge to do this.  Also, I like 
the fact that we could use (existing) Macintosh computers for the 
development work, although the production environment is Windows-based.

The main functions are:  order entry, tracking, billing, etc.  We also 
want to accumulate statistics on customers and services and use the 
system as a basis for marketing activities.  Of course.

HOWEVER, I wonder if FM is really suited to this type of application.  
Does anyone have experience in using FM for this type of application?  
Am I guilty of "a solution looking for a problem"-itis?

If not FM, what other (simple) development environment would you suggest?

All thoughts, suggestions, comments are welcome!



3.Comparing two dates -- What am I doing wrong?

I have a date field "Expiration Date" and a computed value "Current Date". 
Expiration Date is a date field with a value entered by the user. Current 
Date is derived by Get (CurrentDate).

What I want to do is to produce a text value, either "Active" or "Expired" 
depending on whether the value in Current Date is or is not equal to or 
subsequent to the value in Expiration Date.

But strange things are happening in the containing case statement which has 
two conditions, one specified if the result should be Active and one if the 
result should be Expired. I get one of the two wanted text values, but they 
don't match the expectations of the deriving expression, a case statement.

Here is the case statement....

Case (

Expiration Date > Current Date;

Expiration Date < Current Date;


Substitute the FileMaker less/equal symbol for the less-than in the above.

So where is it that I am being stupid?

-- James L. Ryan -- TaliesinSoft

4.Doing A Find On A Relational Field

Is there a way to allow Find to work on a relational field that is in a
form? Currently I have the address fields in the Order database form (which
are from my related Customer database) set to NOT "Allow entry into field".
However, I would like to be able to search on these fields. However, I do
not want the address lines to be editable from the Order form.



5.Please help, relationship doing my head in


struggling to get this to work

In the same file I have two tables, my contacts DB and a control DB. 
The Control DB stores, per user, various settings to be applied to the 
Contacts Db.  What I do is this:

    Open Contacts DB
    Open Control DB
    Step throgh Control DB until I find the record I want
    Set the window geometry of the Contacts DB widdow based on data read 
from Control DB

But it doesn't work.
I can tell that the data used to set my window geometry is taken from 
the FIRST record of control DB.  But I can still see Control DB's 
window, aand it is still positioned where I expected it to be.  So it 
looks like I am referringg to the wrong insstance off Control DB.  If I 
bring the Control DB wwindow to the foreground I DO get the correct 
data.  But I can't beelievee I have to keep selecting that window every 
time I wwant ot get some data out of it - surely not??????????

There must be some way of referring to Control DB that, once I have 
foundd the record I am interested in, will retreivee the data from that 
ecord without me havingg to keep selecting tht winddow.

I didn't say, the layout is set to show records from Contacts DB.  The 
relationsship between the two is based on maatching aa global field that 
is set to "1" in both DBs.

I am really, really struggling with this and would be VERY grateful for 
some help!


6. Can this be done in FileMaker?

7. I am doing somthing wrong ......

8. Can this be done?

Return to filemaker


Who is online

Users browsing this forum: No registered users and 68 guest