FileMaker Standardfelder

August 16, 2018 Kladde

Beim Anlegen einer neuen Tabelle kann man Standardfelder automatisch erstellen lassen. Die Felder definiert man in einer xml-Datei und legt die xml auf seinem Mac in den Ordner /Users/Shared/FileMaker/Shared/ (ab FileMaker 17)

Quelle: https://community.filemaker.com/thread/186421?commentID=763794&et=watches.email.thread#comment-773664

/Users/Shared/FileMaker/Shared/DefaultFields.xml

<?xml version="1.0" encoding="utf-8"?>
<FMDefaultItems version="1" source="17.0.1" membercount="1">
<DefaultFields membercount="6">

<Field id="1" name="UUID" fieldtype="Normal" datatype="Text" comment="primary key">
<AutoEnter type="Calculated" prohibitModification="True" overwriteExisting="True" alwaysEvaluate="True">
<Calculated>
<Calculation>
<Text><![CDATA[Get( UUID )]]></Text>
</Calculation>
</Calculated>
</AutoEnter>
<Validation type="OnlyDuringDataEntry" allowOverride="True" notEmpty="False" unique="False" existing="False">
</Validation>
<Storage autoIndex="True" index="None" global="False" maxRepetitions="1"></Storage>
<TagList primary="True">#_FMI_0 </TagList>
</Field>

<Field id="2" name="DS_erstellt_von" fieldtype="Normal" datatype="Text" comment="">
<AutoEnter type="CreationAccountName" prohibitModification="True">
</AutoEnter>
<Validation type="OnlyDuringDataEntry" allowOverride="True" notEmpty="False" unique="False" existing="False">
</Validation>
<Storage autoIndex="True" index="None" global="False" maxRepetitions="1"></Storage>
<TagList>#_FMI_0 </TagList>
</Field>

<Field id="3" name="DS_erstellt_am" fieldtype="Normal" datatype="Timestamp" comment="">
<AutoEnter type="CreationTimestamp" prohibitModification="True">
</AutoEnter>
<Validation type="OnlyDuringDataEntry" allowOverride="True" notEmpty="False" unique="False" existing="False">
</Validation>
<Storage autoIndex="True" index="None" global="False" maxRepetitions="1"></Storage>
<TagList>#_FMI_0 </TagList>
</Field>

<Field id="2" name="DS_geändert_von" fieldtype="Normal" datatype="Text" comment="">
<AutoEnter type="ModificationAccountName" prohibitModification="True">
</AutoEnter>
<Validation type="OnlyDuringDataEntry" allowOverride="True" notEmpty="False" unique="False" existing="False">
</Validation>
<Storage autoIndex="True" index="None" global="False" maxRepetitions="1"></Storage>
<TagList>#_FMI_0 </TagList>
</Field>

<Field id="3" name="DS_geändert_am" fieldtype="Normal" datatype="Timestamp" comment="">
<AutoEnter type="ModificationTimestamp" prohibitModification="True">
</AutoEnter>
<Validation type="OnlyDuringDataEntry" allowOverride="True" notEmpty="False" unique="False" existing="False">
</Validation>
<Storage autoIndex="True" index="None" global="False" maxRepetitions="1"></Storage>
<TagList>#_FMI_0 </TagList>
</Field>

</DefaultFields>
</FMDefaultItems>

Mac FileMaker