Step 1 desing your table as below
Main table what data your want to keep in this tutorial I am going to make this
Id
items
sorial no
brand
model
image
date of receiving
doc
item location
item qrcode
status
------------
create 2 ref.tables for the item location and the items
for the items
id
items list
for the item location
id
location name
-------------------------
now go to the appsheet
create the new app
name the app as computer app
and import all the table into the app
for each table go to the column view and select the column type that relate to the data we want to store.
-----------------------------------------
That all for the 1st ep.
Next ep.2 will be about how to make a dropdown menu for the column items and the items location by using the Valid_if function
and a step of UX view ,form view and input some data in order to show how to app.
this step will cover how to link to google qrcode service which later we can print out and stick to the computer case for scanning purpose.
