Currently, I am using the expression below to enter USEREMAIL() if [Confirm Closed]=“Yes”.
if([Confirm Closed]=“Yes”,USEREMAIL(),“”)
I now want to only enter the value USEREMAIL() if [Confirm Closed]=“Yes” and [Resend]=“”.
Any ideas? Thank you in advance.
Please try
IF(AND([Confirm Closed]=“Yes”, ISBLANK([Resend])), USEREMAIL(),“”)
Problem with that is if [Resend] is not blank, it will enter the value “”. Effectively, I only want it to enter the value USEREMAIL() once. If the row is updated, I don’t want the value changed. Does that make sense.
So If [Confirm closed] =“Yes” but the value for [Resend] is not blank, I don’t want it to change the value at all.
In the editable_if of the column, please try
ISNOTBLANK([_THIS])
Didn’t work.
So I have this in the formula: if([Confirm Closed]=“Yes”,USEREMAIL(),“”)
and put this in Editable?: ISNOTBLANK([_THIS])
It came up with the above error.
Yes, sorry my bad to have missed that elementary point.
Please try
IF(
OR( AND([Confirm Closed]=“Yes”, ISBLANK([Resend])),
AND([Confirm Closed]=“Yes”, ISNOTBLANK([_THIS]))
)
, USEREMAIL(),“”)
Unfortunately that does not work either.
I must add, that this data has already been saved. This only occurs when I running a behaviour. That behaviour is adding the value “Resend” to the [Resend] column. This behaviour only occurs if an icon is selected. So that behaviour is updating the row of data which in turn is changing the [Closed By?] column to the person who selects the icon. This person will not necessarily be the person who closed the DOB so I don’t want that to happen. Hope that makes sense.
So perhaps having that expression in the App formula may not be the best place for it:
Thank you for these additional details. My request will be in future ,please mention such peculiar conditions to start with if possible so that we can format a better approach in a faster manner.
We started with a simple expression and we later added two additional requirements.
May I respond tomorrow as I need to retire for the day as it is late night at my place.
My apologies. I should have yes. Any help, when ever you can, I appreciate it very much.
Could you update if you mean a data change action by this behavior. If so, is only the action updating this column [Resend] or some other condition edits, resets or changes that column or something else because you also mentioned.
If you could share appropriate details of that action and in how many ways the [Resend] column gets updated, the community could suggest better.
The action is called “Send out DOB”. It is simply Activated when the “Printer” icon is pressed (As shown below).
It then performs the following:
Thank you.
Maybe this
IFS(
AND([Confirm Closed]=“Yes”, ISBLANK([Resend])), USEREMAIL(),
AND([Confirm Closed]=“Yes”, ISNOTBLANK([_THIS]),ISNOTBLANK([Resend]) ), [_THIS],
TRUE, “”
)
That does work yes but when the row is first saved after being “Closed”, the [resend] column is blank so when the first person activates the “Send Out DOB” behaviour, unfortunately it does change the [Closed By?] column again. All subsequent activation’s do not.
I am sorry, I am unable to understand this sequence.
In general, it sounds that there is a process flow and a resultant sequence of changing values between the three or four columns you have mentioned, which in turn will impact the expression result. A correct expression can be built only after understanding that entire process flow.
It’s ok. Thanks for your help. I’ve tried various options. To make it easier I have made the closing of the DOB a manual process. Thanks for you attempts to help.
You are welcome. Just for a last try, could you update, if the above operation of the first time row save happens through a form save?
If so, please try
IFS(
AND([Confirm Closed]=“Yes”, ISBLANK([Resend]), NOT(IN([_ROWNUMBER], Table Name[_ROWNUMBER])) ), USEREMAIL(),
AND([Confirm Closed]=“Yes”, ISNOTBLANK([_THIS]), ISNOTBLANK([Resend]), IN([_ROWNUMBER], Table Name[_ROWNUMBER]) ), [_THIS],
TRUE, “”
)
Please replace Table Name with actual table name you have.
