ContributionsMost RecentMost LikesSolutionsRe: Table to Table Relationships Criteria I think Report Link is the solution i was looking for. Having the tasks copied would be a dissatisfier for my staff. But I do want a way to see that information at the location level. I will build that out and go from there. Thanks for the recommendation. ------------------------------ Nick Bellows ------------------------------ Table to Table Relationships Criteria I have two Tables. Table 1 is a list of locations. Table 2 is a list of tasks. Some tasks apply to a specific location and some tasks apply to all locations. I have a table to table relationship set up (1 Location can have many tasks) and can view the Location Specific tasks under the location record in Table 1. I am not sure how to get the tasks that apply to ALL Locations to show up under each Location record in table 1. ------------------------------ Nick Bellows ------------------------------ Field Help Text ExportHello, Novice API user, Pipelines only has access to Quickbase Channel. I have 3 tables that began as copies of an original table. 250 fields each. Over time they have been modified and are now slightly different from each other. I have been asked to review the Field Help Text Values of the fields that are named the same across all 3 tables. I am trying to pull the Field Name and Field Help Text into a CSV for the purposes of comparing values. Any guidance would be greatly appreciated. ------------------------------ Nick Bellows ------------------------------ Re: Conditional Look Ups across Tables in 1 AppMy concern is scale. My example is a much scaled down version of my actual situation. In reality I have something like 50 positions and will eventually have dozens of cohorts. I don't want to the field to be selectable from a list of Managers to choose. I want it to populate with the name for that position in Table 1. I am starting to think that because of the conditional nature i.e. Task 2 is assigned to Cohort B and the owner of that task is Manager, I need to create a query to the First Table. Not sure I know how to do that. ------------------------------ Nick Bellows ------------------------------ Conditional Look Ups across Tables in 1 AppI have a table with a record for each Cohort. Within a Cohort Record are fields for identifying the Director, Manager, Analyst assigned to that Cohort. For example: Cohort A; Director=Tom, Manager=Jane, Analyst=Mary Cohort B; Director=Angela, Manager=Glen, Analyst=Stef I have a second table with tasks by position. For example: Task 1; create kickoff presentation; Director Task 2; Schedule presentation; Manager Task 3; Present; Analyst In the second Table, when I select the Cohort for a task, I want to pull in the appropriate person based on the Position that owns the task. For example: I assign Cohort A on Task 1. Since the Position is Director I want to pull in Tom. I assign Cohort B on Task 2. Since the Position is Manager I want to Pull in Glen. I have created a table to table relationship that allows me to Choose the Cohort for the task in Table 2 from Table 1. But I can't figure out how to make the person field populate based on the combination of Cohort and Position. In reality I will have more than 50 positions and the people in those positions can change from Cohort to Cohort. I suspect there is some sort of Get Values type formula needed here but I am stumped. Any guidance would be appreciated. ------------------------------ Nick Bellows ------------------------------ Create Field to Show Status of Another Record in DatabaseI have field that is used as a predecessor field that contains the Record ID of the predecessor record. I would like to create a field, or a color highlight of the predecessor field to show the status of that predecessor record. Record ID 10 has predecessor of Record ID 5. I would like to display the Status Field of Record ID 5 on Record ID 10. ------------------------------ Nicholas Bellows ------------------------------ Copy Button For Rich Text Formula Source FieldHello, I am trying to create a Copy Button field in my report based on the code below that was found in this thread. The issue I am running into is the source field is a Rich Text Formula field. When I use the code below it copies to the clipboard but in plain text with the HTML tags. For example the field I want to Copy contains: Begin TaskXXX Description Text Here Start Time:MMDDYY HHMM but what ends up on the clipboard is <b>Begin</b><br><b>Task</b> XXX<br>Description Text Here<br><b>Start Time:</b> MMDDYY HHMM Here is the code for the button: var text CB= URLEncode([Teams]); var text Alert= URLEncode("Activity Details" & " were Copied to the Clipboard"); "<a class='Vibrant Success' style=\"border:0px solid green; background-color:green; text-align: center;\"href=" & "javascript:{" & "navigator.clipboard.writeText('" & $CB & "').then(function(){" & "},function(){" & "});" & "$.jGrowl('" & $Alert & "',{theme:'jGrowl-green'});" & "};" & ">Copy to the Clipboard</a>" Is the problem the Button Code? Or is the problem my simplistic coding of the Rich Text Formula field to make it look the way I need it to look? Not a coder, just looking for a quicker way to copy this data instead of highlighting, right click, copy, paste in the browser. ------------------------------ Nicholas Bellows ------------------------------