adrain

Can I import data from excel directly into a particular part of a repeating field. Example, a rainfall field defined as a repeating field with 365 repetitions. I want to import the 3rd days rainfall into the third part of the rainfall field, the 4th days rainfall into the 4th part of rainfall field and so on. Is this possible. Seems a simple thing to do, but no option appears when I try and import data to identify which element to place the data into in the repeating field.

Your second option works a treat. Thank you for your time. It's much appreciated.

I forgot to update my profile. I am using FM 8.5 if that is any help. I can't see how to disable design functions.

I have a text field in each record for users to enter comments into. I want it to be a certain font/size. How can I stop users from selecting another font/size so when I print it all out, all the comments are my choice of font and size. Seems a simple thing to do, yet I have searched and not found the answer. can it be done ?

Works perfectly now, I misunderstood your suggestion to use the GET(FILENAME) function. I took you to mean I was to use the actual filename in inverted commas as in GET("S1andS2PI"), which is why it did not work. Many thanks Comment for your assistance, it is much appreciated. Allan

Here it is. The account name and password are both [color:red]add Thanks _Clone.fp7.zip

Calc is unstored and result set to text. Using your suggested syntax LayoutNames ( Get (FileName) ) produces an invalid Get function parameter. No joy with cloning the file either...same result, blank field. Thanks for your suggestions, any more worth trying ? Allan

Here is the calculation: LayoutNames ( "S1andS2PI" ) File is called S1andS2PI. I have set calculation result as text and for storage options tried every possible combination.

Simple problem baffling me. Have a file with 20 layouts. I have a field called "View all layout names" and it is a calculated field which uses the LAYOUTNAMES(fieldname) function. It is blank and is not showing the layoutnames. I have tried every combination of indexing (on, minimal, all), I just can't get it to carry out an index and display the layout names. This was originally a FM6 file. When I create a small test file from scratch in FM8 the layout names do appear. Yet when I do the same in my other file....blank field. Is there any way of forcing an index to be made of the layout names ? I have tried deleting the field and re-defining it, to no avail. Am I missing something obvious ? Thanks for any help offered. Allan

I seemed to have managed to solve my problem. Hope it helps with yours. Locate the files on the server, don't open them but Get Info about file (command + I on mac) then change the permissions for Group access to read and write. I can now open the files using FM admin.

I have the same problem. I have updated some files from FM6 to FM8. I put them into the FMserver7 folder and tried to use the FMadmin to open the files. Again for a millisecond they open but then close. I have checked over everything I can think of. If I make a new file in FM8 I can open it with FMadmin no problem. Its only with the files I have moved from FM6 to 8. So the problem is not limited to Windows but exists with Mac OSX as well.

Doing a school reporting database. In one particular layout each pupil has normal data ( forename, surname, subject, class etc) but also has 3 strategies fields which staff can use to choose strategies an individual pupil may use to help them with a particular subject. The 3 strategies fields are formated to use a pop-up menu from a related database, which has only 2 fields: subject and strategy. For example "Music" and "Practise your instrument more". The problem is when I do a find for a particular class the records take about 2 seconds each to appear in list view. I know its got something to do with the strategies fields being relational, because when I delete only these fields from the layout the whole class's records appears almost at once. There are 16 school subjects each with 20 different strategies. Should it take so long to find and display the pupils data, or is it simply because each of the 3 strategy fields needs to individually link to the related database file. Thus slowing down the find. I am using FM6.

Excellent, many thanks my friend.

I have written an online system for doing pupil reports in a Scottish Secondary school. Each 4th year student studies 8 school subjects. I have a script which looks at each subject (Maths, English etc.) layout for one particular pupil. I can pause between each subject layout for the same set time by setting a number of seconds in pause script option. Some layouts require more reading than others, any way to pause the script until say, the mouse is clicked, which then moves onto the next subject layout and then again waits for a mouse click?