emncwundy

Thanks so much @Wim Decorte, changing the coding as suggested has fixed the problem!!! cheers, Ellen

I have two iPads connected to FM server. For some reason one ipad (5th Gen running 13.5) will not complete the navigation scripts and shows error messages (no records match this find criteria), however the 7th Gen running on 13.1.1 works fine..... Issue has only begun after purchasing the second, newer iPad. I cannot for the life of me work out what is wrong, or how to troubleshoot and would love some guidance please!! Here is a screengrab of one of the scripts and related layout: fm go script issue.tiff Orders iPad layout.tiff

Thanks again for your help and suggestions. I have solved with the use of an auto enter calculation (as suggested), which is triggered by a script when moving from a form to list view of all active orders.

Thanks so much for your advice @rwoods. I get the first suggestion. But I’m a bit confused by the second. What do you mean by ‘maintain the value’? Do you mean manually maintain?? Cheers Ellen

Hi there I'm trying to set up a self join portal to show active orders only on an iPad (those classified as either overdue or ordered). I created a global value of 1 for the parent side g.ActiveStatus is set to = 1 and then on the child side I matched to a calculation field c.OrderStatus where records with "ordered" = 1 or "overdue" = 1. Calculation result is a number (global also is a number). However the related records will not show in the portal. To check my thought process, I removed the calculation on the child side and manually entered 1's, and the portal works. But with the calculation it does not. I tried to activate indexing, thinking maybe this has something to do with it but get an error message about the field not being index-able because it references a related field, a summary field, an unstored calculation field or a field with a global storage. So now I'm feeling stuck. Does anyone have any suggestions?

Ok thanks Webko, ill give that a go. cheers.

Thanks for your advice. The script was created with the assistance of members of fmforums because it was just a bit over my head. It has worked ok for the last 12 months because there was only one year of data. But its obviously not working now because there is more than one year of data. I think i need to find a simpler way to find the records i want to view. I was thinking of creating two global fields - a start date field and endDate field into which i could type the range of dates I want to view. Do you think this would work in a script which ends in showing data in the report layout?

WeekOfYear ( WeekStartDate )

We have a script which runs a report showing all time card entries posted for this week (for payroll purposes). See the attached screen shot showing the script as it currently stands. This script was created a year ago, and I have just discovered that the insert calculated result line is not only finding the current years entries, but all entries with the current week number. Hence why last years records are also being included now. Can someone please help me to tweak this calculation to find only this years records for this current week. I am not sure whether or not I should be inserting the following somewhere into the current script: Year (Get (CurrentDate)) Thanks in anticipation! timecard_script.tiff

Hi there I was having trouble with the formula above - so tried the following: Case (Client_CONTACTS::IsCompany ; Let ( [ unique = ValueListItems ( Get ( FileName ) ; "ContactSurname" ) ] ; Case ( ValueCount ( unique ) > 1 ; Substitute ( unique ; ¶ ; "&" ) ; Client_CONTACTS::ContactSurname & "_" & Substitute ( List ( Client_CONTACTS::c.FirstInitial ) ; ¶ ; "&" ) ) ) ) // end case) // end let) // end case But for some reason the above does not calculate for two individuals with differing surnames (not a company). Please help! What am I doing wrong?

aha! its working perfectly now thank you. one more question - we have a very small number of clients who aren't individuals as such but companies with individuals who work for them. I would like to be able to differentiate the c.ClientCODE for businesses or companies to reflect the business name instead of a combination of the individuals names. Could i do this using a boolean style check box for Company, and then another field for the CompanyName, and have another line in the calculation that checks this parameter first, and if company is checked then it takes the company name as the code instead?

Hi Lee and LaRetta Thanks for your suggestions. No i'm definitely not using it as a relationship key. That is set as a unique auto enter serial number. This field will be used as LaRetta suggests, just as a short cut for finds. LaRetta ive followed your instructions to create the c.FirstInitial in the contact table. Ive also created another version of the contacts table and related it in the same way as the sample. However I am having some trouble with the result for those individuals with different surnames. It seems to be calculating the same was as for people with the same surname. Perhaps ive got the context wrong? could you have a look at the attached screen shot to see if there are any glaring omissions? thank you c.ClientCODE.tiff

Hi Lee and LaRetta Thanks for your suggestions. No i'm definitely not using it as a relationship key. That is set as a unique auto enter serial number. This field will be used as LaRetta suggests, just as a short cut for finds, so ill have a sqiz at the sample file. thanks again

I have a client database which is related to the contacts database by __pkClientID Clients can be one or more individuals with the same last name (eg Gemma and Ben Smith) OR two or more individuals with different surnames (eg Gemma Kay and Ben Smith) I want to have a calculation that automatically creates a ClientCODE eg: Smith_G&B (in the case of individuals with the same last name) OR Kay&Smith (in the case of indviduals with different surnames). Can anyone help me with such a calculation, where filemaker needs to firstly determine if the surnames in the related contact records are the same, and if so, then to go with Smith_G&B and if they are different, then to go with the second option, ie Kay&Smith??

thanks Lee, the Set Field : Get (CurrentDate) seems to be working ok. Is it preferable to use one over the other, ie Insert Current Date vs Get (CurrentDate)?