denisg

Greetings, Thanks to your direction of using the Timestamp field, I am now able to find all records that were modified. I created a Timestamp field and selected Modification checkbox of time and date. Using this field I can do a find using the < symbol and inserting current time from the Insert menu. Manually this works perfect. Now I'm stuck on the next step of automating the find. I'm not sure how to automate the enter find mode, got to timestamp field, insert < symbol and insert time... Can someone help me script this using the Timestamp field? Once I script this, I can have file 2 do an import which I can script. Thanks...Denis

Greetings, This is FM 9 for Macintosh. I am new to FileMaker. I am trying to synch two exact files with each other. File 1 is always open on FM server and want to synch it with file 1 as needed with a button/script. The database has two tables: Master Database, secondly, Contact Names. In Master Database layout I view the Contact Names using a portal. The scenario is that File 1 and File 2 have new name, fax number, so forth. And when user opens file 2 (file 1 is always open on the server), they want to click on a button (scripted) to synch file 1 with file 2. As I'm a basic developer, I thought it best to enclose the two files. In account name enter "supersmile". I would prefer for someone to just do the scripts in the databases then to go back and forth via this post. Thank you very much for your help. Thanks, Denis 408-489-0970 Archive.zip

greetings, Thank you soo much. This was exactly what I wanted and I now understand the logic...Denis

Hello and thanks again for your reply. Clarification...I'm using Filemaker 8.5 Macintosh client. I've decided to enclose the two layouts and tables that I'm talking about. In summary, I have 1 company with 4 contact names and each contact name has 3 phone numbers associated with it. Again, my goal is-once the user enters the ID number, FM pulls 4 names in puts in Popup in second table and have user pick anyone name. Please see enclosed two PDF's and tell me what you think. I'm not clear when you say, "You should keep the multiple names in a separate Names table, related to your table one by the same ID." Does this mean because I have four contact names attached with one company, I need four tables. And how about, each contact name having three phone numbers...not sure here also? If this is over my head, I'm willing to hire you, please advise. My number is 408-489-0970 and my email is denis@gewargis.com ...thanks, Denis Table_1_feeds_table_2.pdf Table_2_pulling_from_table_1.pdf

Thanks for the reply. Because I'm a beginner, I didn't understand how to do what you stated. Can you please give me the steps in detail. Thanks, Denis

Can someone help as I'm a basic FM user. I have a lookup between two tables driven by ID number. In table one, I have four fields: Name 1, 2, 3, 4. Now in table two, when I enter the ID number, I want to see all four contacts in a Pop-up menu so I can select only one… Thanks, Denis

Can anybody help with my above problem? Thanks, Denis

Hello, I have below script. Allow User Abourt (off) Export Records [Restore, No dialog] In FM 5.5, the script would remember my previous export as "Merge" type as I wanted. However, in FM 8 the problem is the script keeps defaulting the "Type" to "Tab-Seperated Text." It keeps forgetting my last export of Type "Merge" and the user is forced to reselect the type each time. However, in FM 8, if I do "Output File Path List" I can get the script to create export file with specific name-but now the problme is that it can only be the same name and also keeps replacing the old one. In my case I want to keep the previous export of type Merge as well keep adding next export file to the specified folder. In summary, I want to run my script, be given the window to name the file each time, but not have to re-select the "Type" to merge each time. Thanks, Denis 408-489-0970

Hello, Can someone help with with this script. I have FM 8.0 Mac and want to write a script to export records of type merge. If I export manually, FM will remember last Type of "Merge". However, if I try to script it, the export keeps defaulting the Type popup to "Tab-Seperated Text". Simply, I want to write a script to export of Type "merge." Thanks, Denis

Greetings, Environment...Mac OS X 10.3 with FM 5.5 server with clients Mac 7.0. I need help with the following task. I have a DateField that the user enters date manually. Based on this field date, I want to create a script that will go to "layout 1" if DateField is > (greater) than "June 1, 2006", otherwise, go to layout 2.

The formula fails with the letter 'A' as I want it to because I have the field strict data type as "number" so it blocks the 'A' from passing as valid data type. Also, have maximum number set to 10. It works exactly like I want it. Maximum 10 integers and '0' are accepted at the beginning, middle and end but no alphabets. Thanks again for your help...Denis

Thanks so much to all. This formula "Length( TextToNum( "1" & Account Number) ) = 11" did the job...it's works exactly like I want it... Thanks again...Denis

thanks to all. I have to have 10 integers ONLY...A zero at beginning of the integers is a must and at times a zero at the end of the 10 integers is also needed for the user to enter. Example "0123456789" and "0012340500" both example where zero is in beginning, middle and end must test and be valid...but can not exceed 10 integers and especiall characters of 'abc' can not be accepted and want the test to fail and prompt the user as error. Remember, my big problem is the user enters 'opqrst' where they start with an alphabet 'o' instead of zero.

Hello, Mac 5.5 server with Mac OS X clients environment. I am using this forumula "Length(TextToNum( Account Number) ) = 10" to validate if the user entered 10 integers and prompt if they have not with a message window. Formula works fine, except that this formula fails to recognize starting with zero "0" as a first valid integar. Example, if I enter "1234567890" formula works fine. But if I start with a zero "0123456789" the formula does not accept the starting zero as a valid number and fails as if the user has not entered 10 integers. All is well if the zero is in the middle and/or the end of the 10 integars. How can I modify this formula so a starting zero '0' can be accepted as a valid integer within the 10 integars... Thanks, Denis

Hello Daniele, Thank you so much. It is working now. Yes, the problem was in english the functions name is 'TextToNum'. Denis

Hello Daniele, Thanks for your reply to my post. I tried the formulas in the 'Validate by calculation' and am getting this same error when using either of the two formulas: "Either an operator was omitted, this function cannot be found, or "(" was not expected here." When I hit OK, FM highlights the 'TextToNumber. Thanks to you and all those helping, Denis

Hello, I am still not sure how to check if field < 10 integars. Prompt user if < 10 integars with a message window but still allow as sometimes they enter 8 integars. Can someone give me the script to test the field? FileMaker 5.5 server Macintosh Thanks, Denis

I just got in town and read the thread. Both of you thanks so much. I got the strict numbers, maximum of characters = 10 and prompting the user. But I still need help with the validation if <10 integers. I am Macintosh FM 5.5 and could not use LaRetta's "Filter" formula, as well, I don't know how to script using function TextToNum(). Can you please give me the formula and I'll put in "Validate by calculation." Thanks so much...Denis

I'm a new FM and need help. I have a client who has a database with a text field where users enter normally 10 integers. Now I want to: 1) test for 10 integers, and if less, prompt the user and yet still allow them to enter 1-10 integars. 2) make a test to force users to enter integers only becuase sometimes they mistakenly enter/mix letters with the integers. 3) I cannot lose old data from this field. Thanks, Denis

I have a number field that the user just enters 8-10 integars. Now I want to 1. test for 10 integars; if not equal to 10 integars, the user is promted yet allowed to enter less than 10 integars. 2. I also want to preserve the data in the original field-I don't want to loose it-I understand if I change the field to a calculation, etc...the previous data is lost-need to preserve. Mac OS X server running FM 5.5 can someone help...Thanks, Denis

John...thanks for your help. I was able to fix my problem based on your help...thanks a million-Denis

Hello John, Thanks for the reply. But I need help as I made a mistake. My field is not a repeating field, instead, it's a text field formatted with vertical scroll bar using Format fields. I have a header and footer at bottom. And in the body section, I have a few fields in addition to this one big field that is currently displaying 10 lines. As the user enters more date, the scroll bar becomes active and they scroll down to bottom and continue adding data. So, with some records, the print out might be simple 1-10 lines(which fit within 8 x 11 paper), and for other records it may grow to 11+ and need to have this print out. In summary, when I print all records, some with be one pager and others 2+ pending how big that field has grown...thanks a million...Denis

hello, I have a repeating field that is 20 lines. I display 10 lines on my layout and have a scroll bar to scroll down to the rest of the lines. My problem is when I print, I only get what is displayed on the screen...the bottom part does not print out. Can someone help me?...thanks, Denis ...

hello, I have a repeating field that is 20 lines. I display 10 lines on my layout and have a scroll bar to scroll down to the rest of the lines. My problem is when I print, I only get what is displayed on the screen...the bottom part does not print out. Can someone help me?...thanks, Denis