LesterBird
Qrew Member
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Report showing how many times a user appears in a list-user field
Thank you both. I'm a noob to formula queries and I've tried to put one together. I've created a new table called "employees" with a user field called "team member" and a formula-numeric field called "number of teams". I'm trying to query field number 13 in my activities table which is the list-user field called "activity team". For some reason when I try this formula, it's always returning 0. Any suggestions on what I might be doing wrong? var Text QUERY="{13.HAS.[Team Member]}"; Size(GetRecords($QUERY,[_DBID_ACTIVITIES])) ------------------------------ Lester Bird ------------------------------28Views0likes2CommentsReport showing how many times a user appears in a list-user field
Hi, Apologies if this is already asked and answered but I didn't find it. I have a table called activities. Each activity in the table has a list-user field called activity team. I'd like to be able to have a report showing every user in my app and how many times they appear in the activity team field. So the output would look like user a shows up in 3 activity teams, user b shows up in 2 activity teams, user c shows up in 7 activity teams, etc. Any suggestions on how to do this? ------------------------------ Lester Bird ------------------------------35Views0likes5CommentsMatching multi-select field in one table to a field in another table
Hi, I have two tables - projects and states. Each project occurs in at least one state, but sometimes in more than one state. So I created a multi-select field called Project States in the project table. I have another table called states which houses information about each state and where I want to be able to match a project to the state it occurs in. So for example, if a project is in both Florida and Georgia, I want to have the project appear in the states table under both Florida and Georgia. Does that makes sense? I've tried converting the multi-select field to a formula-text field, then tried matching the text in states to the formula field but it doesn't seem to be working. Is this a possible solution? Any ideas about other solutions to the problem? Thanks in advance for any help!