Is there a way of changing a single selection based on if another col contains a file?

[aszwoeins]

I try to change the value of a single select cell based on another cell that contains a pdf file. If the cell contains the pdf file the status cell should be option “generated” if not “not generated” how can i achieve that?

[AkDk7]

HI @aszwoeins.

Interesting question. You can do something like this with a formula column:

if(countItems("File") = 0, 'not ') & 'generated'

[aszwoeins]

yeah that works. But now its not a select item but plain text. Can i do something similar with select items? @AkDk7

[AkDk7]

What do you mean by select item?

[aszwoeins]

I mean a single select.

[AkDk7]

Sorry, I don’t get it. You got an example?

[AkDk7]

Oh, do you mean the formatting like a single select?

[aszwoeins]

The column type should be a single select. Where theres rather “generated” or “not generated” selected

[AkDk7]

Nah, I don’t think SeaTable can do this.

[aszwoeins]

Ohh Okey but for now i think the plain text solution should be fine… Thanks for your support

[AkDk7]

You could colorize it based on the value though.

[aszwoeins]

that’s smart. I will do that thanks

[AkDk7]

Hey.

I’ve a solution for you.

You can use the automation rules to select the correct single select value.

If you already have the columns File and Formel you have to add a third column Checked or whatever you wanna call it. That is the column with the single select items.

If you have the option to add automation rules you can add two rules for each select option like that. It’s in german but you should understand the trick.

1. Put the trigger on the first option of the events
2. Select the file column to be watched
3. Add a filter that checks if the column Formel is generated or not generated
4. The automated action is changing the single select to the generated or not generated value

So you have to create two automation rules for each option.

[aszwoeins]

Thanks for your effort to help me. Where exactly do i find the automations section? I never used it before.

EDIT:
I found it. But i think i am not able to use it bc we are on the Plus Plan right now

[AkDk7]

Ah okay. I’m running my own instance, so I can use it… Sad thing

[AkDk7]

Btw. I’ve just had another idea. You could use services like make or n8n to create workflows. Have you thought about that?