Dislplay in Calculation field and formula
My app hat 1 reference field, which 5 related multi App A, B, C, D, E hat. Please see Image
I want to create one Field - Name = Name of one item of App A or B or C or D or E.
But @mention can not search App A, B, C, D, E…
Can you help me.
And what is formula in this calculation, when i want display Name = 1 of items of App A or B or C or D or E.
Thank you very much
as I understand you, your App X has a relationship field which references the 5 Apps A,B,C,D,E. If to an item in your App X always only one item from one of these 5 apps is related (e.g. item X1 has a relation to item A1, but no relation to item A2 and no relation to an item in B,C,D and E) you can use this
var A = @all of title field App A.join();
var B = @all of title field App B.join();
var C = @all of title field App C.join();
var D = @all of title field App D.join();
var E = @all of title field App E.join();
A + B + C + D + E
For getting the variable token in the popup list type after the @ the whole name of the field you want to reference. (Btw: .join() isn't really necessary in this case).
Please sign in to leave a comment.