Hello !!
I have a shared view where a column has a formula…
@if(@IsMember(@Text(@Username);contactUserlist);“Active”;“Inactive”);
contactUserlist is a field where the usernames are stored.
This formula is not getting calculated for each user when he logs into the application.
I have already indexed the database.
Situation:
A particular user changes the status of the doc to “Active” and closes the database. The another user logs into this database and access the view, the doc still shows “Active” as the status of the document, while the status should be “Inactive” for that user because his name is not in the “contactUserlist” field.
please let me know how to recalculate the formula every time the user access the view.
I had used notesuiworkspace.viewrebuild, it was working fine but the performance of the application drastically dropped and the appliaction crashed for more than 5 users.
A liitle nudge towards the problem would be highly appreciated.
Thanks in Advance…
Sanhita Ray