Brian Dunning's FileMaker Custom Functions

FieldAndContentList ( TypeField ; AddFieldList ; Contain ; NotContain ; TagField ; TagValue ; EmptyValue )

returns field names and contents of all the field are on a layout (repeatingField and related records included)

  Average rating: 4.4 (31 votes) Log in to vote

Agnes Barouh   Agnes Barouh - Show more from this author
Tic Tac
http://www.tictac.fr/CoinFileMaker/Page.html

Share on Facebook Share on Twitter

  Sample input:
FieldAndContentList ( "" ; "" ; "" ; "::" ; "Field" ; "Value" ; 1 )







--------

FieldAndContentList ( "" ; "" ; "" ; "" ; "Field" ; "Value" ; 0 )
  Sample output:
Contact::NomDurand
Contact::PrenomFrançoise
Contact::Photosil-female.png
Contact::Societe

-------
Contact::NomDurand
Contact::PrenomFrançoise
Coordonnee::Libelle [NthRecord_1]Bureau
Coordonnee::Libelle [NthRecord_2]Mobile
Coordonnee::Coordonnee [NthRecord_1]02.70.27.55.09
Coordonnee::Coordonnee [NthRecord_2]06.28.96.21.48
Adresse::Adresse82, place Maurice-Charretier
Adresse::CodePostal28000
Adresse::VilleCHARTRES
Adresse::LibelleBureau
Coordonnee::Type [NthRecord_1]Téléphone
Coordonnee::Type [NthRecord_2]Téléphone
GLO_Globale::zkv_CompteCompte
GLO_Globale::Picture[3]Repeat.png
GLO_Globale::Picture[4]all.png

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

** Do not use on a layout with a lot of related records.

FieldAndContentList ( TypeField ; AddFieldList ; Contain ; NotContain ; TagField ; TagValue ; EmptyValue ) V_1.0
FieldAndContentList () requires CustomList ( Start ; End ; Function )
----------------------------------

retourne les noms de rubrique et le contenu de l'ensemble des rubriques posées sur un modèle ( multivaluées et tables liées incluses )
à ne pas mettre dans une rubrique calcul, utilisation par script conseillée !

returns field names and contents of all the field are on a layout (repeatingField and related records included)
not to put in a section calculation, use script recommended!

FieldAndContentList ( "" ; "" ; "" ; "::" ; "Field" ; "Value" ; 0 ) pour uniquement les rubriques de la table source
FieldAndContentList ( "" ; "" ; "::" ; "" ; "Field" ; "Value" ; 1 ) pour uniquement les rubriques liées à la table source
FieldAndContentList ( "" ; "" ; "" ; "glo_¶z" ; "Field" ; "Value" ; 0 ) ne prends pas en compte la table ou les rubrique avec Glo_ et z_
FieldAndContentList ( "Standard" ; "" ; "" ; "" ; "Field" ; "Value" ; 0 ) uniquement les rubriques "Standard"

TypeField : "Standard¶StoredCalc¶Summary¶UnstoredCalc¶Global" - keep type - Default are "Standard¶Global"
AddFieldList : permet d'ajouter des rubriques qui ne sont pas sur le modèle / Add field are not on the layout
Contain ; NotContain : keep or exclude field or table name
TagField ; TagValue : xml result
EmptyValue : 1 - keep or 0 - exclude empty value

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: