AvrioTech

Ive tried that and it works but theres one little issue... I sort the portal records by date and when the portal is shown, the order isnt correct.

I know this may seem odd to some people, but im trying to get a date field to be quicker for data entry.. Ex instead of typing 01/01/01 as a date you can type 010101 and Auto-Enter an auto enter calculation will format it to a correct date format of 01/01/01. My Calculated auto entry is: Case ( Length ( datetest )=6 ; Date ( Left ( datetest ;2 ) ;Middle ( datetest ; 3 ;2 ) ; Right ( datetest; 2 ) )) Pretty Simple and straightforward... but the problem is I always get errors of wrong date format. Any ideas how to do this?

Right now I have 2 tables 1) Company 2) Employees Im trying to make script that changes the field "active" to "No" in the company record and in the related employees records when someone trys to delete a record in the company table. I did a script that says Replace Field Contients [No dialog; RelCompanyEmployees::Active; "No"] This sounds like it would work great, but its replacing every single active field (even ones that arent related to the company) to "No". Both tables are related by the companyID Im I doing somethign wrong???

I have a layout where someone fills out 6 things CompanyName, Address, City, State, Zip and Phone I filemaker to require these fields to be filled in, so I went to define fields => Validate during data entry + Require Not empty + Desplay custom message. This doesnt work the way I would like. It pops up 6 pop up dialogs if nothings filled it. 1) Is there a way to make it one dialog box instead of 6 that says you must fill in xxxxx + xxxxx (based on a calculation). 2) Is there a way to validate it before it goes to the next field? Thanks

Believe it or not its in 1 file but different tables. The only things that seems to refresh instantly in this case are Aggregate Functions in a calculation field. Ex Sum, Count, List ect.. I had a portal for all contacts for a business so not every contact was related to the same location in my portal. So Count wouldnt work for me. So What I did was created a calculation field that used the list command then did a pattern count. PatternCount ( List ( CustomersEmployeesByCompanyID::LocationID ) ; CustomerLocationsMainAddress::RecordID) Hope that helps. It works great for me. If you have trouble try uploading your file somewhere and ill take a look at it.

Hello im having a valuelist + calculation field issue. When I change information in my valuelist field (in a portal) my calculation fields not updating unless I click on a blank spot on the record. As you can see in figure 1 (image below), I have a field that shows how many related contacts are per location (in blue and underlined). The formula im using for that is: TextColor ( TextStyleAdd ( "Related Contacts (" & Count ( CustomerEmployeesBYVendorIDLocationID::RecordID ) & ")"; Underline) ; RGB ( 0 ; 0 ; 255 ) ) and I have a portal where I can view All contacts (related of not) and I can chose what location by a pulldown menu that contact belongs to. My Issue is that my related contact calculation doesnt update when I change the location of the contact and go to the next field, unless I click somewhere on the record. Is there a way to make it update as soon as you leave the field? The image blow is showing this Figure 1 = before I change any information, notice only one record in the portal is related to the main address above so the related contacts shows "Related Contacts (1)" which is correct. Figure 2=Show me changing the 1st record in the portal so that 2 records will be related to the main address. Figure 3=Shows my issue.. Its showing that the Related contacts still shows 1 even though 2 records are related. Figure 4= Shows it working , but only after I click on a blank area of the record. CLICK HERE TO SEE BIGGER

For filemaker to know which repeated line to go to, is by a calculation based on the window number which is parsed from the title of the filemaker window. When you open a new window filemaker automatically adds a window number at the end of its title. Ex "name of your window - #" The number of the window never changes, that ive seen.

Im using a global for highlighting a portal row (container field) If ( RecordID = Vendors::SelectedVendor ; Graphics::SelectedPortal ; Graphics::NonSelectedPortal) My problem is when I open 2 windows I see both windows highlighting the same portal row. If I change the portal row in one window it changes both. A problem scenerio whould be Im filling in data (an order) into filemaker from an email or a fax , then I get a phone call for an order I would like to be able to enter it in with a new window without interupting the email or fax window.

Is there a way to make filemaker not share globals between different windows? The only thing I can think of is have example : Window #1 look at line 1 of a global repeated field and have window #2 look and repeated global field line 2. It just seems a little buggy to me because if you close window 2 and open it back up, then you have the old globals from the previous window 2. Any sugguestions? Thanks

Thanks. I would think that it would clear everytime you went into the field but it doesnt. It works perfect thanks.

how do you do that tho?

I got it to work the way I want I played around with different things and I got it to work perfectly with a lookup. Check out the file and tell me if you think this may cause any issues. locationstest3.fp7.zip

Ok I added Kmart to have cali for a location. I still have the problem of it keeping the old valuelist item. An Example is if I pick Sears then I pick NJ for its location, then I decided I picked the wrong company and picked Kmart instead, it still shows NJ in the location field.

Ive made a test file with 2 valuelist... One with a Company Name and one with The State of the companys location. I have 2 company names in my test app Kmart and Sears. Kmart has 0 locations in my test and Sears has 3 NY NJ and FL. Heres my issue... Lets say I pick Sears as the company and Pick Location NJ. Then I pick Kmart (which has no location) NJ is still picked in the valuelist.. Is there a way to somehow clear the Location value list if the company changes? I attached a file too. Thanks alot. locationstest_2.fp7.zip

Yes its a fix sorta, but to me, its alot faster to use pulldown menus instead of popups, Also the autocomplete is nice to : . Everytime ive tried popup menus people get mad at them because it takes alot more time entering them in vs pulldowns (especally when theres alot of options). Thanks for the information on them, I never knew you could do that with popups. thnx