Question

Forms collection populate current user (task)

Forms

Updated February 26

asked on February 26

Hi, I am trying to populate only the first field in a single line/collection with the current user assigned to a particular user task. I set the default value of this field to this: {/dataset/_task_assigned_to[@_step_id=24]}

This populates the user for all added fields in the collection:

I will be populating this field with a lookup (all fields after the first).

Is there a better way to do this? I am using Forms Designer.

0 0

Answer

SELECTED ANSWER

replied on February 26

You can populate just the first row with a formula instead of a default value using IF(ROW() = 0, . . .)

But because you want to populate remaining rows via lookup, there isn't a way for a lookup to skip the first row. All rows are always targeted by the lookup. Small caveat here being if you have a lookup filling based on a rows values, it would only trigger for the row being changed. It doesn't look like you table has more than one column so this wouldn't be the case.

I'd either:

Creating two sets of fields, one for the "primary" or however you'd call it that fills based on the user assigned the task, and the others filled by lookup.
Adding the user assigned the task to the lookup before they're assigned the task so it loads with the others via the lookup

0 0

Replies

replied on February 26

Thanks Zachary, I went with option 1. This is a great workaround!

1 0

You are not allowed to follow up in this post.

Question

Question

Forms collection populate current user (task)

Answer

Replies

Sign in to reply to this post.