conditions of the workflow

[peterberlin]

Hello,
I would like to start a workflow when a certain dataset does not exist.
Therefore, I have entered this script in the conditions of the workflow.


'false' != record\exists(Anlage, anlagesNames=, anlagennummer);

But the syntax is wrong.
Does anyone have an idea?

peter

[item]

Hi,
record\exists('Lead', 'emailAddress=', fromAddress)

return true or false. You must quote too.

https://docs.espocrm.com/administration/formula/record/#recordexists

so if understand :
ifThen(
record\exists('Anlage', 'anlagesNames=', anlagennummer) ,
'blabla')

[peterberlin]

Hello Item,

thank you for pointing out the quote.
However, my task is far more complicated than I thought at the beginning.
The workflow is for entity B.
I have two entities (A and B). In the workflow, I need to test whether a record exists in entity A. However, the search value is in entity B, i.e. the entity that the workflow accesses.

I have now tried this formula without success:
record\exists('name of entity A', 'entity\attribute('A.fieldname')=', entity\attribute('B.fieldname')) != true;

(This code is in the workflow conditions, not in the workflow actions).

[item]

Hi,
i respond with iPad, not easy write :

record\exists('name of entity A', 'fieldNameA=', fieldNameB ) != true

1 param : entityName quoted : sample ‘Lead’
2 param : fieldName of entity A quoted : sample ‘name=‘
3 param : as it’s workflow on entity B, fieldNameB is available directly : sample : name

[peterberlin]

OK
Thank you.
I'll give it a try,

[rabii]

Hey peterberlin

Try this, let us suppose we have entity Account and field Name and entity Contact and field is accountName (workflow is based on Contact) :

record\exists('Account', 'name!=', entity\attribute('accountName')) 

The reason is that the condition is waiting for a truthy statement i guess and not false statement return. i could be wrong but jut give it a try.

i have tried this record\exists('name of entity A', 'entity\attribute('A.fieldname')=', entity\attribute('B.fieldname')) != false in the paste and kind didn't work all the time.

[peterberlin]

Thank you very much.
I will test it