Highlight Record on Table when a new report is added

Question

Hello,
I have tried every variation of this I can think of and can't get it to work. I have an app that is open to the public. When a record is added there, I have a report link field in my main application that displays the record that was added in the matching record. I would like the matching record in my main app to also highlight on the table tab so I can see that something was submitted without leaving my main app. My last attempt to do this was to turn on custom data rules and use this code&nbsp;&nbsp;
If(Count([CRP]) &gt; 0, "&lt;span style='color:red'&gt;" &amp; [Bill of Lading Number] &amp; "&lt;/span&gt;", [Bill of Lading Number])
CRP is the name of the report link that displays in my main app showing me what was entered in my open app and the Bill of Lading Number is the field that links the submission from the open app to the corresponding record in my main app.
I may be way over complicating this. Any thoughts? Thank you so much in advance.&nbsp;

------------------------------Rhonda Jones------------------------------

markshnier__you · Answer

I need a bit more information. &nbsp;Are these Everyone On The Internet records (EOTI) being added as children to a Parent record and you want to highlight the Parent &nbsp;Or are they just appearing as an embedded report on a record in your main app. If just on an embedded report, do you want them to highlight in color like for the day?

Either way we will be using "Row Colorization" on the embedded report, but I'm trying to understand the criteria to turn on the color.&nbsp;------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

markshnier__you · Answer

Assuming that you have a report specified on the firm to use as the embedded report, just find that report in you report list and make a row colonization formula.&nbsp;
For example, IF(Status]="Open", "yellow")------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

markshnier__you · Answer

Just to be clear, Row Colorization is a configuration on the table report setting.------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

rhondajones · Answer

My EOTI has no parent/child table relationships. I just created a report in that table and then display that report in my Claims app. When I close the request in my EOTI app, the report disappears from my Claims app as it only shows up there when the request is showing on the main table in my EOTI app and I have them set not to display once they are closed.&nbsp;
This is the report field properties in my Claims app

Match the values in thisfield from this table
to the values in this field

&nbsp;
# of Items
# of Items &lt; 500
# of Items between $501 - $1000
# of Items over $1001
1.25 Agent Chargeback
3 Zip
50% Chargeback
AAFES
ALR EFP
ALR File
ALR Invoice
ALR Invoice EFP
ALR Invoice File
ALR Invoice Reduction
ALR Invoice Sent
ALR Letter
ALR Sent
AW Setup
Add Claim Doc
Add Email
Add Inspection2
Add Item
Additional Docs
Additional Docs 3
Additional Docs2
Additional Notes to Member
Address
Address verified? Yes
Address2
Address: City
Address: Country
Address: Postal Code
Address: State/Region
Address: Street 1
Address: Street 2
Adj. By
Adjuster Email
Agent - Dom. Comp Agreement
Agent - Dom. Maximum Chargeback
Agent - Int. Comp Agreement
Agent - Int. Maximum Chargeback
Agent - SCAC
Agent Address: City
Agent Address: Postal Code
Agent Address: State/Region
Agent Address: Street 1
Agent Liability
Agent Name
Agent Subro
Amazon
Amount Offered
Assign Ins. by
Assigned to:
Average Adjusted chargeback
Average Amount Offered
Average Claimed Amount
BCC email field
Bill of Lading Number
Bill to SCAC
Billable
Billing Manager
C.D. Sent
Change to Ack. Sent
Change to Offer Sent
Change to Rebuttal Answered
Change to Received
Change to Waiting on Inspection
Check by Mail
Claim #
Claim Docs
Claim File Date
Claim Number
Closing Summary
Closing Summary EFP Date
Closing Summary Notes to TSP
Code of Service
Comments by Member
Contact Email
Contact First Name
Contact Last Name
Contact Number
Create Closing Summary
Create ECM Offer Letter
Create Insurance Subrogation
Creation Date
DA
DA Invoice
DA Invoice Attachment
DA Invoice EFP
DA Liability
Date Created
Date Due
Date Modified
Days to File
Days to adjudicate
Destination Agent
Destination Location
Docs to Customer Button
Domestic Agent EFP Date
ECM Offer Letter
ECM Offer Letter EFP Date
ECM Receive Date
ECM Receive Date Calc
ECM member email address
ERF
ERF EFP
ERF File
Email
ExportID
Formal Name
Full Name
H
Hauler Invoice
Hauler Invoice Attachment
Hauler Invoice EFP
Hauler Liability
Icon Status
Import
Insurance Subro
Insurance Subrogation
Insurance Subrogation EFP Date
Intrastate
Invoice #
Invoice Date
Invoice total
Invoiced
Item Count
Last Modified By
Last Name
Liability Limit
Liability Limit2
Liability Notes
Maximum Record ID#
Maximum Record ID# - EFP Date
Maximum Record ID# - Invoice Sent to TSP?
Maximum Record ID# - Invoice sent to TSP Date
Maximum Record ID# - Repair Firm - Company Name
Maximum Record ID# - Request Sent
Maximum Record ID# - Status
Member Email
NTS Liability
Name
No
Notes
OA
OA Invoice
OA Invoice EFP
OA Invoice File
OA Liability
Offer File Attachment
Offer File Attachment2
Offer Sent Date
Origin 1.25 Agent Invoice
Origin 1.25 Agent Invoice2
Origin Agent
Partial TSP Credit
Phone Number
Pick-up Location
Print Closing Summary
Priority
Rank
Record ID#
Record Owner
Related Agent
Related Agent2
Related Agent2 - Agent Address: City
Related Agent2 - Agent Address: Postal Code
Related Agent2 - Agent Address: State/Region
Related Agent2 - Agent Address: Street 1
Related Agent2 - Agent Name
Related Agent2 - Comp Agreement
Related Agent2 - Maximum Chargeback
Related Agent2 - SCAC
Related Agent3
Related Agent3 - Agent Address: City
Related Agent3 - Agent Address: Postal Code
Related Agent3 - Agent Address: State/Region
Related Agent3 - Agent Address: Street 1
Related Agent3 - Agent Name
Related Agent3 - Comp Agreement
Related Agent3 - Maximum Chargeback
Related Agent3 - SCAC
Related Customer2
Related Customer2 - Address
Related Customer2 - BCC
Related Customer2 - CC
Related Customer2 - Name
Related Customer2 - Primary email
Related Customer2 - SCAC
Related Inspection
Related Inspection2
Related Request
Related TSP
Repair Firms
Reviewed
SCAC
Sal
Save Button
Send Member Email
Shipment Delivery Date
Shipment Liability
Shipment Pickup Date
Status
Submitted by
Survey Pending?
TSP - Company Name
TSP - Email
TSP - Mailing Address
TSP - Phone Number
TSP - SCAC
TSP Action Required?
TSP Claim Savings
TSP ECM Email
TSP File Attachment
TSP File Attachment2
Target
Total Adjusted chargeback
Total Amount Claimed
Total Amount Offered
Total Claimed Amount
Total Claimed Amount &gt; 500 &lt; 1001
Total Claimed Amount &lt; 500
Total DA Liability
Total Hauler Liability
Total Line Items
Total OA Liability
Total Weight
Total to Member
Weight
Yes

App&nbsp;Customer Request Portal
Field&nbsp;Requests: Bill of Lading Number

This is what it looks like in my Claims app.

Full Report&nbsp;&nbsp;Grid Edit&nbsp;&nbsp;Email&nbsp;&nbsp;More&nbsp;1 Request

&nbsp;

Created

TSP

Request Type

Bill of Lading Number

Name

Days Open

&nbsp;

02-26-2023
All-American Forwarding, Inc.
General Question
Removed
Removed
1

AVG
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
1

------------------------------Rhonda Jones------------------------------

Forum Discussion

Highlight Record on Table when a new report is added