Data Change Tasks (calling an Action to create a record) are not picking up Initial Value Formulas

AppSheet AppSheet Q&A
,
1

If I’ve got a table with a Key column that’s utilizing UNIQUEID() for it’s initial value:

3X_8_1_812441bd485fed20cef1821b82644c846f2cd561.png
3X_8_1_812441bd485fed20cef1821b82644c846f2cd561.png826×837 45.6 KB

When I create an action to create a row in that table, no errors are thrown…

3X_7_5_7558ce15abaafc8dea97998945c2875685536fdc.png
3X_7_5_7558ce15abaafc8dea97998945c2875685536fdc.png897×648 39 KB

In the image above, you can see I’ve set only two columns’ values - I did not include the (KEY) column

But when I try and use that same action inside a Task - the initial value formula is not being “seen” or “understood” or what-have-you by the system and it’s requiring me to enter something for the value to be set to.

3X_0_5_0502797a8e7af0d7eb5dca882dd8d08e706e0c2f.png
3X_0_5_0502797a8e7af0d7eb5dca882dd8d08e706e0c2f.png452×894 43.3 KB

2 Likes
2

Thanks for bringing this up and the very detailed report. This seems to be a bug and we will fix it.

2 Likes
3

I’m going to begin a serious digest of these new elements in preparation for some videos, I’m sure I’ll come up with tons of other things.

@Dan_Bahir Would you like them reported here (in the community), or directly to support@appsheet.com?

4

We’ve released a fix for this.

2 Likes
5

I am still experiencing this issue: Automation Actions fail on Required columns relying on an Initial Value to fill them

It actually works fine with the row’s Key (set using UNIQUEID() as above) but not other columns with Initial Value set. It works fine if I call the Action directly, or if I define the values for the columns directly inside the action.