About Jason73

Jason73 · 04-15-2018

I'm trying to create a budget view for maintenance on items. Below is an example of the spreadsheet that I currently use to do this. The goal would be to create this: However, it seems I can't create a time-based report given ServiceNow is looking...

Jason73 · 04-24-2018

Actually, I figured it out... the table name should have been x_mahe2_bnf_monthlyspend, which is the full table name, not just the scoped application table name. Moving forward 

Jason73 · 04-24-2018

I had no idea those logs were there, this is awesome. They should have this for scoped applications in a log like the "JavaScript Log" window. Parent table is: operatingExpenses Shadow table is: monthlySpend I just added a new record to the paren...

Jason73 · 04-23-2018

The "spend_item" is in reference to the parent record, which I've updated to try both current and current.sys_id. The other should be a date, so I've added the GlideDateTime() function. Still no dice however...Can you confirm the GlideRecord('month...

Jason73 · 04-23-2018

So I'm not having any luck creating the record in the shadow table. Here is what I have: (function executeRule(current, previous /*null when async*/) { // January record var shadowTable = new GlideRecord('monthlySpend'); shadowTable.initialize()...

Jason73 · 04-22-2018

Thanks Adam so far for the help. I've decided to go down path #2 so as to maintain the user experience. To do this, I think adding a BR to insert / update / delete records when the "parent record" is created / modified / deleted is how I'm thinking...

User Activity

How do I create a summary report using time-based (months) as columns

Re: How do I create a summary report using time-based (months) as columns

Re: How do I create a summary report using time-based (months) as columns

Re: How do I create a summary report using time-based (months) as columns

Re: How do I create a summary report using time-based (months) as columns

Re: How do I create a summary report using time-based (months) as columns