Use formulas in automation actions?

ā“ Questions & help š‘“x Formulas
1

Is it possible to use formulas in automation actions?

For example, when a row is added from a new form submission, Iā€™d like to populate the Client ID via a simple formula. Something like ā€“ MAX([Client ID]) + 1

image

2

@Megan_Wolfe - Welcome to the community!

Formulas are not supported in automation actions - However, I think that it is a great idea & we may add support for it in the future.

For what you are trying to do however, I suggest that you use AutoNumber data type for the Client ID column.

1 Like
3

Fantastic! Thank you so much for this easy solution to my problem.

I do think formulas in automated actions could be super powerful, but I am also glad to utilize the AutoNumber data type.

1 Like