I am trying to make the LayoutNames function work without success.

I calculated the following (see attached screen shots) from Define Database. It creates an empty field; indexing brings up the index list box containing nothing; the database contains nearly 100 layouts.

Thanks in advance for wisdom and assistance.

Hi

first of all the calc must be unindexed, second must be:

LayoutNames ( Get( FileName ) )

Your English is very good.

I made the following (see attach) changes but results are the same.

Please, post a clone of your DB or a file with only that calc.

Hi,

Another spaghetti eater's answer then :

Daniele meant the "Do not store calculation results" from the 'Storage Option' button.

It has nothing to do with the "Do not Evaluate if all referenced fields are empty"

Ciao

Ugo

La ringrazio amici italiani! (I cheated with this translation (Google translator). I have been to your beautiful country three times.

Now to business at hand.

As requested, I prepared to send you the calc using a FMP template. The calc works fine in the template but not my solution.

I tried to add the table to my calc (which should be "from users,.. ) but could not figure out how to do it.

The only difference that I can see between the template and my solution is shown in the two screen shots.

Grazie per il vostro aiuto

Hi

when in:

File >> Define Database >> Fields

double click on your calculation field: LayNms

and check the box ( Top -Left ): Evaluate this calculation from the context of:.........

I don't see how the context would matter with the formula in question. My guess is the calculation is still stored.

It is odd that there's no reference to the context in the screen shot. But the screen shot also clearly does not say "Unstored" as well.

Edit: Ah, FM only shows context if there's more than 1 TO.

Edited May 2, 200817 yr by Guest

After being able to create a working LayoutNames field in the template, I went to a saved backup of my solution from several days ago and successfully created the calculation there.

I think I might have something corrupted in this file.

Does this sound plausible?

If so, is there any way to check to check for and fix a corrupted file?

In any case, "Grazie" to you all for helping me figure this out. I have learned a lot in the process. :

Anything is possible, but... This is getting quite ridiculous. You have been advised, several times, to turn on the option "Do not store calculation result..." in the field's Storage Options. I don't think you have done that, and it's not going to work until you do. I don't believe it works in your test file either: I predict* that if you change a layout's name, or add a new layout, the calculation will NOT reflect the change.

---

(*) My crystal ball is working overtime today.

Sorry for your frustration.

I can assure you I have followed the instructions to the letter, including checking the "do not store....," box in "storage options" dialogue.

The results are exactly as I described.

The instructions work in other solutions (see attached), just not the one I was requesting help with.

People_Management.zip

Perhaps one of your layouts is corrupt as you said earlier. If you dont have an issue with the backup copy then use that one and import your data into the working backup.

If it is indeed corrupt, trust me even though it looks like it is fine, it WILL EVENTUALLY bite you. If it crashes in a few months because of it, you will have lost a lot more than the work you will have to redo from your backup.