How can I make the status item dynamic?

[jweinreder]

How can I make the status item dynamic? The user has to change “Open” to ‘Closed’. How can I set this up?

The status field is now a group with two text fields, 1 open and 1 closed.

[davidb]

It sounds like you’re using conditions to govern the visibility of each of two text elements. Use the same condition on a single text element to govern not the element’s visibility but instead other properties, such as its text and color.

[pattokane]

Hi @jweinreder , how are you?

Have you got the “satus” field setup as an optionSet that changes when you user changes from open to closed?

[jweinreder]

Hi @pattokane,

I made a table, added a group, added 2 text items ‘Open’ (Open) and ‘Afgerond’ (Closed), added a dropdown element. See screenshots below:

[jweinreder]

@davidb

It sounds like you’re using conditions to govern the visibility of each of two text elements. Use the same condition on a single text element to govern not the element’s visibility but instead other properties, such as its text and color.

@davidb I think your right. I added a conditional like: When Current row’s Order’s Status is Open. This I aso added for the close text" When Current row’s Order’s Status is Closed.

What need I change so the user can change the status from open to closed?

Thanks

[davidb]

@jweinreder

I added a conditional like: When Current row’s Order’s Status is Open. This I aso added for the close text" When Current row’s Order’s Status is Closed.

This is what I was referencing. You have mirror-image conditionals on separate elements. I thought you were asking how to collapse all that into a single element. You can do so as I explained, although it’s also fine to leave your current implementation using separate elements.

@jweinreder

What need I change so the user can change the status from open to closed?

This is a separate question. One typical approach would be to add an element, such as a button or icon, for the user to select. Then, create a workflow that is triggered when the user selects that element. In the workflow, include an action that changes the database value that you want to modify.

[jweinreder]

@davidb thanks for you reply.

I have now added a dropdown that displays the status of the order (see attachment 1).
I also added an Update button, which should save the status change (see attachment 2). However, I’m not sure how to set up the workflow to update the database value (see attachment 3).

Could you help me set this up correctly? Or would you recommend a different approach?

What I like most is that the user changes the status in the dropdown and that it automatically saves the status, but I don’t think that’s possible.

Thanks again!

[jweinreder]

I fixed it with ChatGPT

[davidb]

ICYMI: Autobinding