Condition Formula Error

[sapyantuk]

How to write a condition formula

i want to test if a field is linked with any records for certain entity or not linked



If File management is Not Linked or emply the avaiable status should be Availabe and if file management is linked or not emply the available status should be not available

[sapyantuk]

Someone Please Respond

[eymen-elkum]

This must be easy, just make sure to use the correct field name in the ifThen function:

https://docs.espocrm.com/administration/formula/#ifthen

I think the field name is filesManagementsId, you can easily pick it from the + button

ifThen(filesManagementsId, do any thing here);

[sapyantuk]

I tried with this code:



ifThenElse(
fileManagementsIds != null,
status = 'Not Available');
ifThen(
fileManagementsIds == null,
status = 'Available');



But it is only producing Not Available Option

[sapyantuk]

I tried but its not working

ifThenElse(
fileManagementsNames != null,
status = 'Not Available'
ifThen(
fileManagementsNames == null,
status = 'Available')
)

[eymen-elkum]

In condition use == instead of =
This is important!!

[eymen-elkum]

what is the link type
one to many or many to many ?

[sapyantuk]

I tried with This one
I tied with This one



ifThenElse(
fileManagementsIds != null,
status = 'Not Available';
ifThen(
fileManagementsIds == null,
status = 'Available')
)

Link Type Is One to Many

[sapyantuk]

I tried with This one
I tied with This one



ifThenElse(
fileManagementsIds != null,
status = 'Not Available';
ifThen(
fileManagementsIds == null,
status = 'Available')
)

Link Type Is One to Many

[eymen-elkum]

sapyantuk please share here the worked formula, so other users can get benifit

[sapyantuk]

eymen-elkum Thank you so much for helping me ..

Working Formulas

ifThen(
array\length(fileManagementsIds) == 0,
status = 'Available'
);

ifThen(
array\length(fileManagementsIds) > 0,
status = 'Not Available'
);

// status = entity\countRelated('fileManagements');