Some helpful hints when creating field names for your tables:
- when naming your table fields keep the name short (15 characters or less)
- no spaces in field names, you can use ‘_’ character instead, if you need to space the words of the name
- only alphanumeric characters in the field name, with the exception of ‘_’ and use it, only if absolutely needed
- enter the field name all in lowercase if possible, makes it easier when using the names in your velo code. Wix changes some of the uppercase characters to lowercase, which can cause you grief and your code won’t work. (Look at ‘Field Key’) to see what Wix did to your field name and always use that to refer to the field name in your code.
As well once you have created the field name, the ‘Field Key’ stays permanently. Even if you rename the field, you will notice the ‘Field Key’ will not change. The only way to get the ‘Field Key’ to change to a new name, is to create a new field with the new name. Once you have the new field created, then cut/paste the contents from the old field into the new field. Once you have moved the data into the new field, then delete the old field.