Hello I want to build a site audit app with the ability to create corrective actions from each inspection record. I have watched a few webinars to date but cannot find one to fit my request? I want each inspection to have a unique ID and have the ID referenced in any of the actions I create from that record?
Soโฆ you looking for related tables, correct?
i think so
@Tim_O_Neill if you are the only one who is using the app, then itโs doable. But if two users or more are using the app, you will have duplicate number one day or sooner. You can read more about from this articleโฆ help.appsheet.com - Sequential Keys Sequential Keys help.appsheet.com
Have you read the documentation?
Appsheet is perfect for what you want to do.
You can include photos,
GPS & Timestamps
for every step.
If I were you, I would build my own โuniqueโ IDs that are easier for you to make sense of, rather than use the UNIQUEID().
You can also go overboard and build IDs including things like timestamp, counter, etc, but this gets complicated and causes your IDs to be long and ugly.
Maybe you need this, maybe you donโt.
Iโd keep it simple.
The setup I use would probably work great for you.
I like to build my own IDs that are much easier for humans to discuss and refer to.
Mine are no where near as unique as UNIQUIID(), but with 6 digits I have about a million possibilities, and you can easily read and relate them.
I make the Key in my JobLog my Client + JobID, in my Invoices, the Key is Client + JobID + InvioceID.
Below is a look at what is recorded in my backend Sheet.
Not from same job, just an example of carrying an ID through every step like you want. Hereโs a copy of the formula I use in my JobLog Table [JobID] Initial Value to build my simple JobID. CONCATENATE(โJโ,RANDBETWEEN(10000,99999))
Hereโs the PDF Invoice my Customer receives automatically (in about 15 seconds) when I change my [Invoice Status] column/field to โSentโ.
You could do the same thing with an Inspection Report, or whatever. My JobLog has 10 before photos and 10 after photos, but I only send the first of each to the Invoice.
For really bad units like this one, I can also send off a full report with all photos that my Client can use to get Tenants to pay for damages without having to take them to court. Friendly request, add a nice Profile Image please, youโll get better interaction.
Where @Stephen_Mattison uses the ID for the client and shows it as well, I never do that. I always hide it and using it as internal use only. I believe itโs more better to show just client name and project name and some additional data like customerโs reference/order number. But as you can see, there isnโt just one way to do this and itโs good thing
Good points, yes some, maybe most will want a cleaner look for what the client will see.
The customer doesnโt need to see his customer number on his invoice, Iโve been meaning to pull that out of there. I built this carpet app solely to make the job of the owner/operator (me!) as efficient as I could, so seeing everything all the time really doesnโt bother me, and this was my first app, HAHA! Time for an upgrade!
With hundreds of invoices per year
for each client, I really have found it handy to have meaningfully succinct IDs linked together along the way, I can just glanced at something and know everything about it.
@Stephen_Mattison This is great informtion thanks Stephen. Is there a way to change it that the entries are numbered concurrently rather than randomly?
Yes, easy, see different ways,
but someone else will have to help with that, too complicated for me, and I donโr like sequential IDs.
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |