Solution to create table same data type

[Nadhirah]

I have multiple table with same data type to be set manually and in it in about 200 tables. I would like to know does appsheet have a solution or function in which I can set a column in multiple table with same name to have the same data type? This is because it would took me a lot of time, previously I took 2 months to set 200 tables. 

Or if appsheet does not have this feature, does anyone have any idea or suggestion for me to make my work more easier and not time consuming?

[Aurelien]

Hi @Nadhirah 

As faar as i know, there is no such feature.

However, you could take advantage of the ability of AppSheet in recognizing key-words and then setting appropriate types.

For example:

- using the exact table name in one column name will enable a Ref type toward this table

- using key-words such as icon, image, photo, picture....will set the type Image

- using key-word id will set the initial value with UNIQUEID() and set the key property

- using date or datetime on the beginning of the column name will set the column with type date or datetime, along with setting an initial value with NOW() or TODAY()

and many more.

Hope that helps!

[Nadhirah]

This is new, can I know where I can see how all this keywords would work and if there is a lists of the keywords, it would help me so much thank you!