Hey there! The only way to have this is to have all dates occupying their own row. There are two ways to go about this
1 Change your table architecture
Instead of having one big table with many columns, where each row represents a rental
Have two tables
- Orders
- Order Dates
The orders table will have top level data like person, equipment rented, etc. while the Order Dates table will be related to the orders table and hold all the dates.
It will have four main columns:
- Parent Order to which it’s related
- Type (rental, ship out, ship start)
- Start date
- End date
If you’re newer to coda, this would be creating the Order dates as a sub table of the orders table. Here’s a concise yet thorough walkthrough of how to set that up!
2 Custom Pack
If you do not want to change How your tables are architected, you could create a custom pack to queries all those different columns, and generates a new table, similar to what it described with order dates.
This wouldn’t be my recommended method, but it’s definitely possible. If you know how to code and you know Codas api it’s an hours worth of work to get it up and running! So not too bad