Trying to adapt my ongoing equipment rental project for which I use Google Spreadsheets. The biggest challenge I face now is the inability (or is it so?) for CODA to have frozen rows/columns. Maybe there is a clever way to overcome that? The idea is the following: I have a complex table where I r…

Dear @Vytenis , I suggest to study the below template for some inspiration :bulb: [image] Equipment Inventory Management Real-time management of store inventory 🏬 Instead of frozen rows, in Code you can create different views from one and the same table to focus…

You will find Coda much easier than spreadsheets for this use case scenario, but it will need some getting used to. :slight_smile: As Jean_Pierre_Traets suggested, check the templates and guides, they answer most of your questions. As a snapshot of what you could do, you can create separate tables…

@Jean_Pierre_Traets and @Michael_RnW . Thanks for the insights. After having read the guides and seeing the examples, I do see that I need to build a schema first for my problem understanding. I will revert back with my draft once I make it. It hopefully should not take long. At the same time I wond…

@Michael_RnW , @Jean_Pierre_Traets and anyone else, who wishes to help. I have followed your advice and have built something to start with: https://coda.io/d/Company-operations_dBxZ1QWhApg/_sukGJ Master view (Bookings) is the Section where I would like my magic to take place but I am stuck at equipm…

@Vytenis [image] Vytenis: For example: I have two events planned for 2019-02-13. When I select equipment, I have now selected CUBE for both. But since there is only one CUBE, I should be able to do one of the following: not be able to select the CUBE once it is already selected for another ev…

@Vytenis I played with this some more for my own purposes. [image] [equip_select-1_2019-02-06_1825] [equip_select-2_2019-02-06_1829]

@Ander - what is the formula in the “row with matching dates”? I briefly saw this [image] , but when I tried to replicate - I could not write “CurrentValue” - it said to me this: [image] . Any comments?

Dear @Vytenis , [image] As you can see I added a date column from when the “value” will be available and an “available column” with the following formula If(Avail_Date<=Today(),true,false). Then create a view of the “select value” table, where you filter Available=true [image] IMPORTANT: selec…

Dear @Ander , @Jean_Pierre_Traets , @Michael_RnW - thank you very much for your inputs. Those are great. Got me on some good track. But I believe they will be helpful at the stage where equipment reservation will need to be compared against what is available and what is not. However, at this stage I a…

Table with multiple rows and columns that are frozen

Ander February 6, 2019, 9:29pm 6

@Vytenis

Would something like this help you at all?

Topic		Replies	Views
Equipment status table / matrix with two rows of column headings	51	6246	March 7, 2019
Launched: Frozen columns News from Superhuman	24	3683	February 9, 2022
Frozen rows/columns	3	1018	April 25, 2019
Lock columns in view Product Feedback	26	4404	February 22, 2023
Is there a way to freeze rows and columns in a Coda table?	1	1529	May 10, 2020

Table with multiple rows and columns that are frozen

Related topics