Hi,
I have the 2 modules below and did a lookup function but it returns blank values.
Am i missing something?
@joky1980- Create 1 line item in SYS01 with name of Accounts code, Format - list, Accounts code, Formula - Finditem(Accounts code list, Code)-In mapping to countries line item use this formula - SYS05. distributor[lookup: New line item(Accounts code)]Thanks,Manjunath
Hi @joky1980 ,Code is Line item in sys01 but a list item in Sys05. I think it must be different list, if so, do a finditem in SYS01 to derive the list of sys05 list in sys01. Lookup or firstnonblank should work here.Thanks,Manjunath
Hi @ManjunathKN ,
The code from SYS01 is code that was from the list.
Can you kindly advise how i can get the value (Distributor) from SYS05?
Hi @joky1980,Cant really relate by this. Can you show me the blueprint view of Sys01 and sys05. SS should have "applies to".Thanks,Manjunath
As below blue prints;
@ManjunathKN, it works! thank you very much!
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context andβ¦
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-yearβ¦
