Hi, I am looking at creating an app that is l...

[Simone_Stoove]

Hi, I am looking at creating an app that is logging mileage from car users in a business. I was wondering if it is possible to have the app access the database at work to look up a job number that the mileage is being used for so the mileage can be charged to that job. Is this possible with this type of software? Thanks

[tony1]

@Simone_Stoove AppSheet can access databases. Right now we support common database types, like MySQL, Postgres, and SQL Server. See these docs for more info: appsheet.com - Customer Support - AppSheet

In terms of designing your app, you’d have a Jobs table (backed by your database) and then a Log table. Each log entry would have a reference to a particular row in the job table.

https://help.appsheet.com/data/references/references-between-tables

Here’s a sample app that’s similar to your situation. It demonstrates how to log information about different properties. For your app, you’d have jobs instead of properties, though. https://www.appsheet.com/samples/An-App-to-Run-Inspections-Across-Several-Properties?appGuidString=7... Customer Support - AppSheet appsheet.com