Table Column Properties

roy-n · April 9, 2015, 11:53pm

I am able to request the entire Table schema to include data types, column names, etc. An example row returned is:

{“name”:“objectId”,“required”:false,“type”:“STRING_ID”,“defaultValue”:null,“relatedTable”:null,“customRegex”:null,“autoLoad”:null,“isPrimaryKey”:true},

The key “required” in this case is set to false and I can definitely see that this is modifiable within the Console under Users/User Properties. On the other custom Tables, I don’t see a way that this key required is modifiable for one or more columns. Is this key “required” modifiable within the Console and/or via the REST API?

Also are the following modifiable via the Console or REST API?

“defaultValue”
“relatedTable”:
“customRegex”
“autoLoad”:null

What does the “autoLoad” key do?

mark-piller · April 10, 2015, 1:16am

The “required” attribute can be configured only for the user properties. Table columns do not have a visual configurator of that attribute.

“defaultValue” can be modified in the schema editor. Here’s an example:
http://support.backendless.com/public/attachments/34fa804290d0f11da1e0bebf002c880a.jpg</img>
“relatedTable” can be established when you create a relationship column:
http://support.backendless.com/public/attachments/a3f981199a51be17138cc2ebcf082262.jpg</img>

“customRegex” is also available on the same form as the “defaultValue”. Read more about it here:

“autoLoad” is described here:

Regards,
Mark