ASullivanFFRASu
Qrew Trainee
Joined 5 years ago
User Profile
User Widgets
Contributions
Simpler solution for multiple Checkboxes, with conditional text boxes?
I have 30+ fields to indicate a Product, with QTY and Notes textboxes that will show/hide if the Product box is Checked, using Conditional Formats. I know you can use the Multi-text option to turn on different options (multiple checkboxes), but this solution won't allow for the additional QTY and Notes? Unless someone knows of a better, simpler way to do this?Re: I would like to list the attachments in a single field, to be referenced using a relationship in another form?
Sorry, *without* the dbid(_DBID_Publication_Tracking) Error says there are extra characters beyond the formula: var text Words = ToText([FFSP Top 5 Cover Sheet]); var text URL = URLRoot() & "up/" & dbid() & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([Publication Submission: Fleet & Family Support]); var text URL = URLRoot() & "up/" & dbid() & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([CYP Top 5 Cover Sheet]); var text URL = URLRoot() & "up/" & dbid() & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([Publication Submission: Child & Youth]); var text URL = URLRoot() & "up/" & dbid() & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([Housing, Lodging, Navy Getaways Top 5 Cover Sheet]); var text URL = URLRoot() & "up/" & dbid() & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([Publication Submission: Housing, Lodging & Navy Getaways]); var text URL = URLRoot() & "up/" & dbid() & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([SFA Top 5 Cover Sheet]); var text URL = URLRoot() & "up/" & dbid() & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([Publication Submission: Sports, Fitness & Aquatics]); var text URL = URLRoot() & "up/" & dbid() & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([REC Top 5 Cover Sheet]); var text URL = URLRoot() & "up/" & dbid() & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([Publication Submission: Recreation Programs]); var text URL = URLRoot() & "up/" & dbid() & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([LIB Top 5 Cover Sheet]); var text URL = URLRoot() & "up/" & dbid() & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([Publication Submission: LIBERTY Programs]); var text URL = URLRoot() & "up/" & dbid() & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([FBE Top 5 Cover Sheet]); var text URL = URLRoot() & "up/" & dbid() & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([Publication Submission: Entertainment & Dining]); var text URL = URLRoot() & "up/" & dbid() & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" List(", ", [FFSP Top 5 Cover Sheet], [Publication Submission: Fleet & Family Support], [CYP Top 5 Cover Sheet], [Publication Submission: Child & Youth], [Housing, Lodging, Navy Getaways Top 5 Cover Sheet], [Publication Submission: Housing, Lodging & Navy Getaways], [SFA Top 5 Cover Sheet], [Publication Submission: Sports, Fitness & Aquatics], [REC Top 5 Cover Sheet], [Publication Submission: Recreation Programs], [LIB Top 5 Cover Sheet], [Publication Submission: LIBERTY Programs], [FBE Top 5 Cover Sheet], [Publication Submission: Entertainment & Dining])Re: I would like to list the attachments in a single field, to be referenced using a relationship in another form?
I am missing something, I am sure: var text Words = ToText([FFSP Top 5 Cover Sheet]); var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([Publication Submission: Fleet & Family Support]); var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([CYP Top 5 Cover Sheet]); var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([Publication Submission: Child & Youth]); var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([Housing, Lodging, Navy Getaways Top 5 Cover Sheet]); var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([Publication Submission: Housing, Lodging & Navy Getaways]); var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([SFA Top 5 Cover Sheet]); var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([Publication Submission: Sports, Fitness & Aquatics]); var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([REC Top 5 Cover Sheet]); var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([Publication Submission: Recreation Programs]); var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([LIB Top 5 Cover Sheet]); var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([Publication Submission: LIBERTY Programs]); var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([FBE Top 5 Cover Sheet]); var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" var text Words = ToText([Publication Submission: Entertainment & Dining]); var text URL = URLRoot() & "up/" & dbid(_DBID_PUBLICATION_TRACKING) & "/a/r" & [Publication Submission#] & "/e30/v0"; "<a href=" & $URL & ">" & $Words & "</a>" List(", ", [FFSP Top 5 Cover Sheet], [Publication Submission: Fleet & Family Support], [CYP Top 5 Cover Sheet], [Publication Submission: Child & Youth], [Housing, Lodging, Navy Getaways Top 5 Cover Sheet], [Publication Submission: Housing, Lodging & Navy Getaways], [SFA Top 5 Cover Sheet], [Publication Submission: Sports, Fitness & Aquatics], [REC Top 5 Cover Sheet], [Publication Submission: Recreation Programs], [LIB Top 5 Cover Sheet], [Publication Submission: LIBERTY Programs], [FBE Top 5 Cover Sheet], [Publication Submission: Entertainment & Dining])I would like to list the attachments in a single field, to be referenced using a relationship in another form?
I have attachments within Table A, called Publication Tracker, and I would like to quickly access these attachments via single field, both for a report and so I can ideally pull this info into another Table B, called Project Tracker. I have used the List formula field which would be perfect except it just lists the attachments from the selected fields as text, rather than links to the documents. Is this possible to do, and how?Re: Summary List of Checkboxes, and related fields. if ""true""?
OK, I tried to do this, but I am coming up with an error; what am I missing?: List("\n", If([E-flyer Requested], List(" ", "E-flyer","Qty: " & Totext([E-flyer QTY]), [E-flyer Notes])), If([8.5x11 Poster Requested], List(" ", "8.5x11 Poster","Qty: " & Totext([8.5x11 Poster Qty]), [8.5x11 Poster Notes])), If([1/2 Page Flyers Requested], List(" ", "1/2 Page Flyers","Qty: " & Totext([1/2 Page Flyers Qty]), [1/2 Page Flyers Notes])), If([11x17 Poster Requested], List(" ", "11x17 Posters","Qty: " & Totext([11x17 Poster Qty]), [11x17 Poster Notes])), If([22x28 Poster Requested], List(" ", "22x28 Posters","Qty: " & Totext([22x28 Poster Qty]), [22x28 Poster Notes])), If([24x36 Poster Requested], List(" ", "24x36 Poster","Qty: " & Totext([24x36 Poster Qty]), [24x36 Poster Notes])), If([30x40 Poster Requested], List(" ", "30x40 Poster","Qty: " & Totext([30x40 Poster Qty]), [30x40 Poster Notes])), If([3x5 Banner Requested], List(" ", "3x5 Banner","Qty: " & Totext([3x5 Banner Qty]), [3x5 Banner Notes])), If([3x6 Banner Requested], List(" ", "3x6 Banner","Qty: " & Totext([3x6 Banner Qty]), [3x6 Banner Notes])), If([3x8 Banner Requested], List(" ", "3x8 Banner","Qty: " & Totext([3x8 Banner Qty]), [3x8 Banner Notes])), If([Napkin Holder Ads Requested], List(" ", "Napkin Ads","Qty: " & Totext([Napkin Holder Ads Requested Qty]), [Napkin Holder Ads Requested Notes])), If([4x6 Table Tent Ads Requested], List(" ", "4x6 Table Tent Ads ","Qty: " & Totext([4x6 Table Tent Ads Qty]), [4x6 Table Tent Ads Notes])), If([Brochure Requested], List(" ", "Brochures","Qty: " & Totext([Brochure Qty]), [Brochure Notes])), If([2-sided Tabletent Requested], List(" ", "2-sided Tabletents","Qty: " & Totext([2-sided Tabletent Qty]), [2-sided Tabletent Notes])), If([3-sided Tabletent Requested], List(" ", "3-sided Tabletents","Qty: " & Totext([3-sided Tabletent Qty]), [3-sided Tabletent Notes])), If([Business or Punch Card Requested], List(" ", "Business or Punch Cards","Qty: " & Totext([Business or Punch Card Qty]), [Business or Punch Card Notes])), If([Publication Ad Requested], List(" ", "Publication Ad Requested", [Publication Ad Notes])), If([Web Ad Requested], List(" ", "Web Ad Requested")), If([Facebook Cover Ad Requested], List(" ", "Facebook Cover Ad Requested")), If([Facebook Event Cover Ad Requested], List(" ", "Facebook Event Cover Ad Requested")), If([Instagram Ad Requested], List(" ", "Instagram Ad Requested")), If([Mobile App Ad Requested], List(" ", "Mobile App Ad Requested")), If([Email Newsletter Ad Requested], List(" ", "Email Newsletter Ad Requested")), If([Newspaper Ad Requested], List(" ", "Newspaper Ad Requested")), If([Bowling Ad Requested], List(" ", "Bowling Ad Requested")), If([Theater Ad Requested], List(" ", "Theater Ad Requested")), If([Facility Kiosk Vertical Requested], List(" ", "Facility Kiosk Vertical Requested", [Facility Kiosk Vertical Notes])), If([Facility Kiosk Horizontal Requested], List(" ", "Facility Kiosk Horizontal Requested", [Facility Kiosk Horizontal Notes])), If([Custom Request], List(" ", "Custom Request ", [Custom Notes])), If([Outsourced/Billable Request], List(" ", "Outsourced/Billable Request�, [E-flyer Notes])), If([Foam Core/Mounting Requested], List(" ", "Foam Core/Mounting Requested", [Foam Core/Mounting Notes])), If([Lamination Requested], List(" ", "Lamination Requested", [Lamination Notes])) )Summary List of Checkboxes, and related fields. if ""true""?
I have quite a few checkboxes on a form, some of which if checked will expand to include additional fields like Quantity and Notes. I have seen the formula where you can display a list of checkboxes if marked true but would require a line of code for each checkbox and doesn't show how to display the following text in the fields if marked true. (Conversion/syntax error?); I am also getting errors on the code: List(",", If([E-flyer Requested],"E-flyer", If([Napkin Holder Ads Requested], "Napkin Holder Ads Requested", If([4x6 Table Tent Ads Requested],"4x6 Table Tent Ads Requested")))) _ Is there a simple formula to list all checkboxes within a section, only if checked? (I have 39 checkbox fields, and would prefer not to have a line of code for each) and if possible, also include the following fields, "Quantity" and "Notes"?Embed a record within a form in ""view
Would like to embed a record *within* a form. I.e., we have a "Client Request" form that is submitted to us. I have a separate table called Project Tracker, where it pulls data from different tables, including the Client Request. I have a reference link to the Client Request, but would like to conveniently view the full record within the Project Tracker table. I understand you can create a relationship and pull fields into another table, but this Client Request form/table has 172 fields, majority of which may not have data (e.g., checkboxes). I expect this is a formula, but not sure what that is. Can someone assist with this?In a report, my filters don't seem to be working. What am I missing?
I created a report/table so that only Projects/Project Tasks display those pertainable to the current user. Now I want to modify that report so only projects that are NOT Completed or Cancelled show up. I have set my filters to the following: Show ALL - Any condition: Field is the Current User, or Field is the Current User, etc. AND - Task Status IS NOT EQUAL TO Completed, or Task Status is NOT EQUAL TO Cancelled. Report is still showing Projects/Project Tasks that are Completed or Cancelled. What am I missing?I have tables with relationships setup, but the reports seem to be missing data?
Below are the relationship diagrams, how I have it set up. I've created a Sample Project, with the intent of that being the general overview, pulling data/reports from other tables, such as the Project Tasks. So the problem is, the report is generating nothing there, when I have already created a Project Task tied to this Project; and vice versa, if you go into the Project Task, there's a field supposed to pull the Project Due Date, but shows up blank, even when that field is populated in the Project Form. Any ideas?
