AUTOMATISATION UPDATE REQUEST

Jerome Szurubura · 03/02/21

Hi,

I try to automatically request an update when a row is add to my TEST SHEET

I have two entries

Sheet form
Other sheet with automation "When cells = "TEST" then move the row to sheet TEST)

On TEST SHEET, I set up the below automation

When a row is add, when TRIAL cell selection is empty then send update requirement to requestor (I am the requestor)

Nothing appear to mail mail box.

Can you help me to understand?

Thank for your support

Jerome

Bassam Khalil · 03/02/21

Hope you are fine, could you please translated to English so we can understand what is the configuration you do in your workflow

Jerome Szurubura · 03/02/21

Thank for your fast support, here below the translation

Best regards.

Jerome

Bassam Khalil · 03/02/21

Please try to add the condition window like the following screenshot:

Jerome Szurubura · 03/02/21

Where do you find 'any field' . I don't have it.

It ask me to choose something but I don't have 'any field'

For sure it is the solution but I don't understand. 'any field' is your first choice in the list?

Bassam Khalil · 03/02/21

when you create a new workflow it's the default value if you didn't change it or select something different, yes it's the first choice in the list.

Jerome Szurubura · 03/02/21

I see it but if I do not choose something I can not submit my request.

I find a solution which is not so simple:

I add a column in my sheet
I put an IF formula : If side cell = TEST then write 1, if no write 2. Then it make the TRIGGER

Jerome Szurubura · 03/02/21

I rather have a direct solution but it is better than nothing.

Best regards.

Jerome

Bassam Khalil · 03/02/21

perfect

Answers