I get “Glide cannot make this change because it would introduce the following cycle of dependencies in your columns:” but i think it should be possible because i am not creating an infinite loop, just a loop that starts at the start of my table and the cycle finished to the end of the table
just like you would do with an excel spreadsheet that would have a value that would carry into the next row.
So i have queries that filter orders by date that way it knows which order is previous and next (two separate queries, previous and next) there are calculations inside that order, that i carry the value to the order that is next (that next order has a single value from previous order).
I understand that Glide doesn’t actually check if i create infinite loop or not but just doesn’t allow this because it would create and infinite loop if the value wasn’t from “previous row”. So what would be and effective work around to this problem?
I understand that this might not be detailed enough i will provide more details if needed. This is just General description of the problem for now.