How to update property of collection with value of record from another collection

Hello
I have 2 collections: Tasks and Status.
Both are linked with relationship ( A Task can only have one Status, A Status can have multiple Tasks).
I need to update Task’s Status depends on different actions. Status not as text property but as relation in collection. I can’t understand how to do this.
I Tried to create new Task via Form and to set Status as Automatic Field but there is no available value


Also I tried to do this with help of Update Action after pressin on Button

Hi @Igor,

I would advise to use a “single item list” approach: you convert button to a list of statuses, filtered by status name (set the one you need).
Then “current status” data will become available for button’s action, and you can change the Task’s status to Current status.

Best,
Victor

1 Like

@Victor thanks for response. In my case I’ve already used this magical approach to send other important data to the next step. So there is no possibility to use “single item list” for Statuses. Are there any ideas to solve my issue?

Hi @Igor,

Well this couldn’t be seen on your screenshots :wink:
In order to change the status for current task, you need to get an access to “current status” somehow. You can either get it via single-item list (by the way, you can have list inside another list, so I don’t quite see why can’t you use it in your case).
Or on a previous screen you can have list of statuses + filter, and send current status from there.

Best,
Victor

1 Like

@Victor Giving out information little by little :grin:
“…by the way, you can have list inside another list, so I don’t quite see why can’t you use it in your case” - It’s a great trick, didn’t know it.
Thank you:)

1 Like

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.