Hi João,

It works fine. Now I have another problem:

Handset works but now I have another problem:

When I try to use the same formula, the dropdown widget disappears. I just wanted the logged-in user to disappear

Thanks

Hi SpiritFox,

If you want the user in session not to be displayed in the dropdown, you need to add a filter to the query binded to the dropdown "User ID Recebe". This filter should be User.Id <> GetUserId() 

In this way, the current user would not be in the dropdown possibilities.

Let me know if it works for you.

João

Thanks for the help João.

I am new to this world (I work in the health area) and although I have watched many videos, it is still difficult! (and my English is not very good!)

Thanks

Good year

I am answering in English since it is the language of the forum.

I'm glad I can help you, keep up with the will to learn and training, the experience will do the rest :)

Happy new year!
João

João, 

What I asked for previously doesn't work for what I want

I need that when choosing a user in one dropdown, it is not available in the other dropdown

I tried with a filter in the database:

Exchanges.UserID_Receives <> Exchanges.UserID_Envia 

Do I have to create a customer action? right?

I blocked

Hi SpiritFox,

You will need to have the query binded to the "other dropdown" with a filter like User.Id <> variable binded to the "first dropdown".

You will also have to have an action on the OnChange of the first dropdown that refreshes the query binded to the "other dropdown" so that the list of possibilities get refreshed. Something like this:

Regards,
João

João, 

I don't understand this part;

"You will need to have the query binded to the "other dropdown" with a filter like User.Id <> variable binded to the "first dropdown". "

I have to create a variable on my screen and then, I have to create a filter in the database "getUser" with User.Id <> "variable"?

Sorry i fill so bad :(

Hi SpiritFox,

No problem, see the OML example in attachment. I think it will help you understand better what I meant.

Regards,
João

João,

Works fine. Now i have another problem! :S

When I try to insert a new "devolução" an error appears.  When I edit a "devolução" already in the database it doesn't give an error bur do nothing

Can you take a look?

Hi SpiritFox,

From your error message it is understandable that you are trying to create a record in Trocas entity with a User id key which does not exist in User table or is null.

Looking at your code, this is confirmed since both User id keys are set as mandatory and have Protect as their Delete Rule.

Additionally, you might want to open a new post for other questions which are unrelated to this post original purpose.

Kind regards,
João