gaqreader.blogg.se - How to use a text box online application form

Use Text (64000) when you need users to input up to 64,000 characters.

Use Text (255) when storing a maximum of 255 characters in a field.

Use Random_ID, or other ID data types, to uniquely identify each record inside the table.

Take note of the following with regards to the data types used: Then under Options to the right, enable Stamp On Update and disable Stamp On Insert.

Date_Updated – Select Timestamp as the DataType.

Date_Submitted – Select Timestamp as the DataType.

Request Status – Select Text (255) as the DataType.

Attachment – Select File as the DataType.

Permission_to_Enter – Select Text (255) as the DataType.

Access_Instructions – Select Text (255) as the DataType.

Full_Desc – Select Text (64000) as the DataType.

Location – Select Text (255) as the DataType.

Category – Select Text (255) as the DataType.

Request_ID – Select Random_ID as the DataType.

For this use case, you’ll be creating four:īegin by clicking the Tables object on the left-hand panel.Ĭlick the New Table link on top and list the following fields with their corresponding DataType: Tables are the foundation or backbone of any app you develop.

The most important thing you should build first is your database table.