Syntax for [condition] in 'link functions' in formula column

[Bela]

Your Setup:

• SeaTable Cloud

Describe the Problem/Error/Question:

I would like to know the syntax that I am allowed to use within the [condition] argument for the countlinks() or rollup() functions within a normal formula column which is described as such: countlinks(“Column”, [condition])

I would like to use the formula as such: countlinks(“Schule”, “{SKZ} !== undefined”). However javascript syntax is not permitted and all the examples I can find online only show > or < comparisons for the filter.

For context: I am in a table that lists contacts and these contacts have a link to a table of Schools. Schools have a text column called SKZ which is basically an ID. I now want to check whether my contact has a link to a school which has data in the SKZ column.

In the future I might want to use different conditions so It would be really helpful to understand the allowed syntax of the condition in general not particular to my current dilemma.

I do not want to use the formula for links column type because I am performing more actions on those counted links. And I would prefer to handle the formula in one column without creating one column for the counted links and another that performs more formula action on that.

Thank you for your help.

[bha]

Hi @Bela,

You should actually use the syntax of SeaTable formulas. For your use case, countlinks(“Schule”,“not(isempty(‘SKZ’))”) should do the trick.

Bests,
Benjamin

[Bela]

Thank you very much. That works well. I thought I had tried it, but apparently not.