SOLVED
Get value of field defined in another field
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
cjames728
7 - Meteor
‎04-16-2018
07:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Each row of my data has 6 fields for each weekday of the week.
Name | Mon | Tue | Wed | Thu | Fri |
Person a | 9:00 AM | 8:30 AM | 9:00 AM | 9:00 AM | 8:30 AM |
Person b | 8:30 AM | 8:00 AM | 8:30 AM | 9:00 AM | 8:00 AM |
Let's say this represents the time someone should be coming in each day.
On each row (From another source) is the Weekday a report was run. So the data is now:
Name | Mon | Tue | Wed | Thu | Fri | Day |
Person a | 9:00 AM | 8:30 AM | 9:00 AM | 9:00 AM | 8:30 AM | Tue |
Person b | 8:30 AM | 8:00 AM | 8:30 AM | 9:00 AM | 8:00 AM | Tue |
Every "Day" value will be the same on the report for any given report.
I want to be able to retrieve the value of the field defined in "Day" so we'd add another column.....
Name | Mon | Tue | Wed | Thu | Fri | Day | Should be in at |
Person a | 9:00 AM | 8:30 AM | 9:00 AM | 9:00 AM | 8:30 AM | Tue | 8:30 AM |
Person b | 8:30 AM | 8:00 AM | 8:30 AM | 9:00 AM | 8:00 AM | Tue | 8:00 AM |
I could construct a monster "IF" statement in a formula tool, but that seems messy and excessive to me. Is there a better way to get the value of a field specified in another field?
Solved! Go to Solution.
Labels:
- Labels:
- Developer Tools
- Dynamic Processing
2 REPLIES 2
LordNeilLord
15 - Aurora
‎04-16-2018
07:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
fevizcaino
5 - Atom
‎04-16-2018
07:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator