When and when not to display an action

[Glaiza_Victorin]

Hello. I am struggling to figure out how I can set an action to show an existing data slice to update that row when a certain column is equal to that of the column in another table, and show another action to add data when this certain edited column is not equal to the existing value of the column in another table?? I need help, please. It worked before, but then it’s not working now.

[1minManager]

Hi @Glaiza_Victorino Give us some more info on the specifics RE the table names and relevant column names. Screenshots help alot

[Glaiza_Victorin]

Okii. Here you go.

So, this is my setup.

First, I have these two actions

And this what is in them

Let’s start with the first action

Next, the Start Service 2

I hope you guys can tell me what is wrong with this.

[Glaiza_Victorin]

What I want to happen is this

Both of the actions have the same format rules, so you wouldn’t know the difference until you open a form.

So, when the value of the ASSIGNEE is the same. After clicking the action, It will give me a form view to edit that existing row below, with the same REPORT ID.

But, if the value of the ASSIGNEE is not equal to the existing value of ASSIGNEE. Upon clicking the action it will open a new form, to add new data, with a different REPORT ID. Which could be 321780-442.

[1minManager]

Which bit isn’t working, the LINKTOFORM or LINKTOROW?

[Glaiza_Victorin]

The LINKTOROW

[1minManager]

Ok, set it up so that each action has a seperate button. Just to check if its the Linktoform formula thats at fault or ‘Condition is true’ formula.

[Glaiza_Victorin]

Ok.

So I removed the ‘condition is true’ formula, and put in ‘true’

This is the output

This is the action and form that I want to see when the ASSIGNEE is equal

This is the action and form that I want to see when the ASSIGNEE is not equal

[Glaiza_Victorin · Accepted solution]

Ok. I think I got it already. Thanks. Just used “_ROWNUMBER” instead of “SR_NO” I don’t think MAX() is working when there is no other number than 1