Help

Multiple date records

Solved
Jump to Solution
2041 6
cancel
Showing results for 
Search instead for 
Did you mean: 
Dan_Long
4 - Data Explorer
4 - Data Explorer

I’m a happy new user! I’ve built a simple table to record Name, location and type of an object and want to record various conditions across inspection dates. I see how to record the conditions I want and how to enter a date in fields but I want to have an ongoing set of records for each item. There will be around 50 items. How can I do this without making a table for each item? (In my mind it looks like a portion of the table will be 3 dimensional)

1 Solution

Accepted Solutions

:slightly_smiling_face: So happy you’ve found it helpful! I modified the base at the same link to include the most recent condition - let me know if you have any questions about how it works!

See Solution in Thread

6 Replies 6
Dan_Long
4 - Data Explorer
4 - Data Explorer

If I could just have a button that copies the field to a new line in another table, that would work.

AlliAlosa
10 - Mercury
10 - Mercury

You have a couple of options, but what I would do is create at least two tables. One called [Items], and one called [Inspections].

Use a linked record field to link each record on the [Inspection] table to an {Item} on the [Items] table.

Here’s a sample base to demonstrate what I’m talking about :slightly_smiling_face:

Hope this helps to get you started!

That is really helpful, thanks!

The more I look at your example, the more I like the little details!! Cheers! May I ask how to bring the condition listed on the most recent inspection over to the Items table?

:slightly_smiling_face: So happy you’ve found it helpful! I modified the base at the same link to include the most recent condition - let me know if you have any questions about how it works!

Very kind of you, thanks again!!