Change the value of a column if in another column is uploaded a file

[Espegg]

I would create a bot that change the value of the column "stato" in "done" when in the column "pdf" is uploaded a file.

How could I proceed?

[baba_sawane]

Hi Espegg,

If you only need to check if a file has been uploaded , use IF() :

if(not(isblank([pdf], "done"; "")))

OR

if([pdf]<>"",done,"")

[Espegg]

HI @baba_sawane thanks for your reply,
but the problem is that the column "stato" is an ENUM column, so when the column "pdf" is not populated, I would to choose the other options in the ENUM list, only when the column "pdf" is populated, the value of the enum must be "done", but then I would be able to change the options as I want in the "stato" column.

How could I proceed?

[lynchk21 · Accepted solution]

I think you can:

1. Create a New Bot
2. When this EVENT occurs:
   1. Event Type:Data Change:
   2. Table: Select table 
   3. Data Change Type: Updates
   4. Condition: AND(ISBLANK([_thisRow_Before].[pdf]),ISNOTBLANK([_thisRow_after].[pdf]))
3. Run this PROCESS
   1. Run a data action
   2. Set row values
   3. Set these column(s)
      1. [stato] = "done"

[Espegg]

@lynchk21 Thanks!