Table per user or instance tables

I have some controls in the cavas that are used to construct a price quotation. Each time a button is pressed, information is moved to a temporary table below, where each line is a quoted item in the price quotation. When all items are complete, another button moves the information from the temporary table to a permanent one that holds items for all quotations, and the temporary table is emptied.
Everything works as designed. Nevertheless, I thing that I will get bad problems when two different persons try to make a price quotation at the same time, since both will be using the same temporary table. Is there a way to make this an instance table (or something like that) and make it unique for each user?

1 Like

I really don’t know the exact answer to your question, but I am thinking, perhaps you can filter that temporary table with who created the row, and then you will always get your row, because you filter the table with your (the logged in) user…? I don’t know if this is a solution that works or not.
Still not that familiar with Coda, but I am working on learning more more or less every day.

3 Likes

I wanted to avoid that approach, if possible. Controls can be set up to perform in personal or collaborative mode and I would like to do the same with the table.
Nevertheless, I think the idea you are proposing would do the job. It’s a lot more work, but if I can’t find a better way, I’ll try it.

1 Like

Hi Giovanni,

Not sure why you say that it will be a lot more work than Christian’s solution? The canvas control is just one way of filtering a table.

What I am more concerned about is what happens at the time of deletion - you will need to make sure that you only delete the correct person’s rows.

Regards
Rambling Pete

1 Like

That is an excellent point. There are many pitfalls in a multi-user environment :slight_smile:

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.