really what i want is a databaseโฆ BUT,
iโd settle for taking info on different tabs on a spreadsheet and melding it together sort of, but readable in a mobile phone screen for sizeโฆ
Iโm a board member of an hoa and iโm trying to update the vehicle parking information as it relates to vehicle make, model, color, plate number, resident name, unit number, contact info, parking tag number, etc all in an effort to nail the parking scofflaws, also searchable by any information of the above categoriesโฆ
any helpful info ?
is it possible to add multiple picture(s) capability per license plate number for violation documentation as well ?
Yes, you can do this pretty easily. Have you given it a try? Just try something really simple โ a sheet with a subset of the information you want and see if you can build an app from it. Thatโs the starting point โ should be pretty quick.
ALso, Im not sure if you are using โdatabaseโ in the general sense
(in which case, a spreadsheet is a database) or in the technical sense of a relational database (which AppSheet also supports).
am using google sheets now, know basic stuff on M$ Excelโฆ aka โflat databaseโ vs. โrelational databaseโโฆ i can put data in tables in a relational database, just not versed in linking them, building dashboards, queries, reports, etcโฆ can do basic data entry on flat spreadsheets with tabsโฆ
@Board_Treasurer youโre going to enjoy this! The community is very active so just post work any questions.
So, for example. Multiple images, zero or a thousand, super easyโฆ Make a table/tab with the columns, key, ref, image Then in appsheet mark the key column as key, and hidden, and column type to text, and set itโs initial value to =UNIQUEID().
Set the Ref column as label, and itโs column type to REF, and select your other table.
Then set the image column to image, and mark it as a label.
Now automatically appsheet will create the reverse reference to your violation table. So now, when you create a violation your will have the option to add as many images as you want.
medium.freecodecamp.org - Get Sheet Done โ using Google Spreadsheets as your data backend Get Sheet Done โ using Google Spreadsheets as your data backend medium.freecodecamp.org
User | Count |
---|---|
42 | |
33 | |
24 | |
23 | |
14 |