Between automation and Formula

User Talk Automations
1

Your Setup:

  • SeaTable Cloud, Dedicated or Self-hosted? Cloud
  • SeaTable Version (only necessary for self-hosted): No self-hosted
    You can find your SeaTable Server version at https://your-server-url/server-info

Describe the Problem/Error/Question:

Please describe your issue as precise as possible. If helpful, you can also provide:

Hi everybody, it’s my pleasure to join in this community. I have a little issue with SeaTable concerning the automations. Please find attached the automation I used that allow me to understand if some changes are made on existing rows (column task and Inizio). I want to maintain this functionality but when I added a new row, this feature cannot be considered. How can I modify the settings in order to avoid the automation when it’s a new row and not an update?

Here the Formula for Task ID:

“TSK-” &
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
SUBSTITUTE(
UPPER(LEFT({Task}, SEARCH(" ", {Task} & " ") - 1)),
“'”, “”),
“À”, “A”),
“È”, “E”),
“É”, “E”),
“Ì”, “I”),
“Ò”, “O”),
“Ù”, “U”),
“.”, “”),
“,”, “”)
& “-” &
REPT(“0”, 2 - LEN(TEXT(DAY({Inizio})))) & TEXT(DAY({Inizio})) &
REPT(“0”, 2 - LEN(TEXT(MONTH({Inizio})))) & TEXT(MONTH({Inizio})) &
RIGHT(TEXT(YEAR({Inizio})), 2)

Thanks,

2

Could you provide some more context?

  • What is it that you try to accomplish?
  • Why this rather complex formula?
3

The table is a list of project tasks. The column task ID is a formula “first part of task name”+“task starting date”.

The formula is not complex and justify what I explain above and avoid , . ’ ecc. that are not allowed as ID number.