Announcements
I want to display attendance data in a nested collection.When I run it, only ID, user, and attachments are included.The other columns are blank.I can confirm that the original data contains other items.It seems that I entered maze.
↓code
hey @LostLamb
can u please copy/paste your code here so we do not need to retype?
thanks
@mmbr1606
OK!
ClearCollect(colDummyTable,AddColumns(
colTmpMonthTable As TMPCOL1,
AttendanceItem,LookUp(Attendancedata,Name.Email=varUser.Mail And date=TMPCOL1.date),
CalendarShift,LookUp(CalendarMaster,WorkCategory.Value=varUserMaster.CalendarShiftCategory.Value And date=TMPCOL1.date) ));
thank you
can u try this instead:
ClearCollect( colDummyTable, AddColumns( colTmpMonthTable, "AttendanceItem", LookUp(Attendancedata, Name.Email = varUser.Mail And date = date), "CalendarShift", LookUp(CalendarMaster, WorkCategory.Value = varUserMaster.CalendarShiftCategory.Value And date = date) ) );
Let me know if my answer helped solving your issue.If it did please accept as solution and give it a thumbs up so we can help others in the community.Greetings
Thank you for your positive response.addcolumns doesn't like double quotes.I'm still in the middle of the maze.
have u tried single quotes or even without?
The formula itself was fine, but it was the lookup that was causing the problem.
It's best to avoid the version currently recommended.
Thanks for your response.
I was able to escape from the maze.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 364 Most Valuable Professional
11manish 186
MS.Ragavendar 105 Super User 2026 Season 1
