Okay, pushing Seatable to the limits I think and it would be fully understandable if you don’t have a solution for this (like many others), I’ll give it a try anyway.
I want to reference to previous records in my table, I can do that with the Link to other records field type. But I actually want to use a value of a linked record which had the Formula field type. As far as I know I cant use the value of a formula field with linked records, is that correct?
What I am trying to accomplish:
I want to create a runbook (a table where each row is an action to be executed at a certain time) in Seatable. Each row has a stepnumber, dependency, starttime, duration and an action to execute at that time. When creating the runbook I create a new row, enter the duration and optional the dependency. When there is no dependency, the starttime of the new action is the previous step’s starttime+duration.
==> how do I do this in Seatable?
When there is a dependency, the starttime of the new action is the starttime+duration of the dependent stap. In Excel this is easy accomplished by using the vlookup function. See screenshot below.
But in Seatable it cant be done I think. I can indicate the dependencies by linking fields of the same table, but I cant use a different formula field value in my formula, can I?
I hope this makes sense, again it is no standard use of seatable I think, so if this is not possible I won’t be disappointed