Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Need to Update Table on dashboard without active field

Primm
Tera Contributor

‎04-02-2024 12:47 PM

Hello,

 

I have a excel file that needs to be imported to a table and be reflected with the updates from this on a dashboard. The excel file shows updated positions that are no longer active in white and the ones that are still active in green. See the screenshot. 

Primm_0-1712086818769.png

 

As you can see there is no column that shows an active is true/false. This all needs to be reflective on a dashboard that shows only the active positions. Do I make a script? How do I pull this off? 

 

Any script and all script help would be great. Thank you.

0 Helpfuls
  • 289 Views
1 REPLY 1

SanjivMeher
Mega Patron
Mega Patron

‎04-02-2024 12:58 PM

Add a column active to the sheet and then import the data.


Please mark this response as correct or helpful if it assisted you with your question.
0 Helpfuls