ContributionsMost RecentMost LikesSolutionsRe: Aggregate data from multiple fields into one Thanks Mark! I went with that assumption and it worked great, Here's what I did for anyone wondering: This was helpful to add the "NONE" option because sometimes a Unit name is not available. If( [Distinct Count UNIT NAME - UNIT TABLE] > 0, [UNIT NAME - UNIT TABLE], [Distinct Count UNIT NAME - WELLS TABLE] > 0, [UNIT NAME - WELLS TABLE], [Distinct Count QRA - CALC TABLE] > 0, [UNIT NAME - CALC TABLE], [Distinct Count UNIT NAME - UNIT TABLE] < 1, "NONE", [Distinct Count UNIT NAME - WELLS TABLE] < 1, "NONE", [Distinct Count QRA - CALC TABLE] < 1, "NONE") ------------------------------ Renee Hansen ------------------------------ Re: Aggregate data from multiple fields into oneThanks Mark! Do I need to have a count so the formula works? and then would those be numeric formulas? and what if there is a txt field ------------------------------ Renee Hansen ------------------------------ Aggregate data from multiple fields into one Hi! I have a notes table setup where a user can add a note from different tables and relate it to that record, but since it's pulling from multiple different relationships (EX: QRA# is coming from the Units table, the Wells table, or the Calculations table, I want a field that will pull that QRA# into one field, instead of it being in one of the others. Does that make sense? ------------------------------ Renee Hansen ------------------------------ Re: Random "number assignment"I'm trying really hard to stay out of excel. ------------------------------ Renee Hansen ------------------------------ Re: Random "number assignment"It seems to be working, however, I am getting repeated numbers. Is there a way to not have that happen? ------------------------------ Renee Hansen ------------------------------ Re: Random "number assignment"Thanks! I'll give that a try! ------------------------------ Renee Hansen ------------------------------ Re: Random "number assignment"That's a workable option! How would this work? ------------------------------ Renee Hansen ------------------------------ Re: Random "number assignment"Actually I mean, how would I set it up? ------------------------------ Renee Hansen ------------------------------ Random "number assignment" Hi! I built a junior rodeo app and I'm wondering if there's a way I can do a "random draw" for scorecards. We have to generate a random sequence of numbers depending on how many players are in that event. Right now we're using a random number generator, and just taking whatever number order they generate and assigning it manually for over 1,000 scorecards. We have a report, and it's okay to type the number down the list, but it would be great if QB could generate a random draw for us! Here's how it works: The "draw" determines when they come out of the gate - when it's their turn. Event A has 14 players, they need to be assigned random numbers. Event B has 12 players and need a random number assigned. etc and so on. Does anyone have any ideas? ------------------------------ Renee Hansen ------------------------------ Using the Action Link Template for Email NotificationsHello, Does anyone have any videos, or training on how to customize the Action Link Template in the "Multiple Record Version" in the Email Notifications? ------------------------------ Renee Hansen ------------------------------