Foreign field with another foreign field's value

[jj.payally]

Hi,
We have entity 'Accounts' and it has foreign field 'Assigned User' from entity 'Users' (client and assigned manager).
Also we have entity 'Debit Cards', which has foreign field 'Assigned User' too, but additionally it has foreign field 'Account' (debit card, manager who responsible for card, client - card's owner).
How can i display in 'Debit card' information from 'Accounts'->'Assigned User' entity?

[victor]

You can do as follows:
- In Administration > Entity Manager > Debit Card > Fields create a field assignedUserFromAccount with type Varchar.
- In Administration > Entity Manager > Debit Card > Formula > Before Save Custom Script add a simple formula:

assignedUserFromAccount = account.assignedUserName;

Thus, the field assignedUserFromAccount will display the name of Assigned User from the account with which this Debit Card is related.

[jj.payally]

Ok, i created new field and formula. Now to get values into that field, i need to update all Debit Card records. Is it possible to do it in simple way?

[victor]

Ok, i created new field and formula. Now to get values into that field, i need to update all Debit Card records. Is it possible to do it in simple way?

1)

2)

[jj.payally]

Yes, I found that method. It is ok when you have <1000 records, but if there is >10000 ? In my situation i had 1700, so it took some time to load all of them on one screen, mark and recalculate. But i have another similar task from CRM managers to create additional calculated field for entity with 100000 records...

[victor]

jj.payally,

Look closely at the second screenshot. On this screenshot, you need to click on the small triangle to select absolutely all records of your entity by 1 click.

[jj.payally]

Beg my pardon, you mean 'Select All Result' selects complete all records (with not displayed on page) ?

[victor]

That's right: absolutely all records (both those displayed on the page and those not).