For newbie to code like me, Which data source is the best should i start to use to build app with Appsheet , eg Goolesheet, Excel, Air table … And if when my data are grown larger and larger, should i learn SQL or something else? and which data sourc...

Hello, I tried to create system-versioned temporal tables (SCD Type 2) for auditing all data changes in appsheet. The idea is every data has a pair of current table (only a current record) and historic table (all previous records) using google sheet ...

Hello All, I usually have image field for many of my data tables. But sometime I don’t have image to store in every record, for example, 90% have image and 10% doesn’t have image. And there is no shared image between table. Should I create image tabl...

Hello All, I have a recursive relationship table of item_group data which have foreign key to refer to another record as parent_id to create subgroup and hierachy. For example, car is a subgroup of vehicle group. My question is how to create view in ...

Hello, I want to link invoice table which contain list of product and service. The product data and the serice data share most common fields, eg. price, tax , but there also a few difference fields, eg. service_team_id for service data. I want to put...