Report advice
We have a table that had all of our trucks. All trucks are supposed to be inspected each day and the results logged. We import a report showing which trucks have had their inspection each day. The num...
Forum Discussion
If I save this as a spreadsheet, sort date from newest to oldest, remove duplicates, it accomplishes what I need. Now I just need to know how to translate that in to Quickbase code.
------------------------------
Steve Pearson
------------------------------
------------------------------
Steve Pearson
------------------------------
If you have to build a new table, there should be a unique value that all your Trucks have. If you make that unique value the Key field of your Trucks table; when when you import your Truck Inspections from a spreadsheet, you can import the [Related Truck] unique key value at the same time because you should already know the unique value of each truck. Otherwise, your key will be [Record ID#] and that will be harder to connect your records when importing, unless the place you compile your spreadsheet from has that Record ID# stored in it somewhere for your export-import process.
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------