Fill all items of a multivalued field

[Noél Dubau]

Hello,

First I don't know if I'm in the good section and hope you'll not be angry !!!

I have a multivalued field which receives through a script value 1 in the case I click on ; supposing that empty is represented by underscore I have a succession looking like 111_ _ 1 _ 11

In a second step I need to get the list of 1 and empty ; but the function List(myMuliValued) returns only 111111

How can I either :

• replace the empty values by 0 before calling List ?
  
• fill all the values with 0 when creating the record ?
  

Thanks for your ideas,

Noël

I know how to do wth a script, but I hoped in calculation....

[comment]

Note: rubrique multivaluée = repeating field

You could add a repeating calculation field =

GetAsBoolean ( MyRepeatingField )

and point the List() function to it.

Or you could use a custom function along the lines of:

http://www.briandunning.com/cf/173

Or you could initialize the repeating fields to 0, using a lookup from a global repeating field.

Or - and this could well be the best course to follow - do not use repeating fields to store data.

[Noél Dubau]

Thanks for your very complete answer.

The first proposition will be my choice ; so I haven't to use of external function. I don't undestand what you mean and how to "initialize the repeating fields to 0, using a lookup from a global repeating field".

Indeed repeating fields are not the best thing in FileMaker ; but I was inspired by an example which you can download here (it's in french).

Noël

[comment]

so I haven't to use of external function.

A custom function is not an external function. You have the Advanced version, so you shouldn't have any problems installing it (any version can use it).

I don't undestand what you mean and how to "initialize the repeating fields to 0, using a lookup from a global repeating field".

See the attached.

LookUpR.zip

I was inspired by an example which you can download here

I don't think I can - it says something about being désolé over my lack of accès?