Prev
Next
Forums Infor / Lawson Platforms Infor CloudSuite

Spreadsheet Designer

 2 Replies
 0 Subscribed to this topic
 21 Subscribed to this forum
Sort:
Author
Messages
Bill Brennenstuhl
Basic Member
Posts: 16
Basic Member
4/12/2023 3:23 PM

    We are getting ready to move to Cloud Suite and trying to figure out what's the best way to replace some of our current spreadsheet tools we created using Power Query and VBA.  The biggest issue we've found is that after a query is created using Spreadsheet Designer, everytime the spreadsheet is opened, it prompts for the connection, login, and then displays the query properties pane.  Is there a way so that when an end user opens the spreadsheet they don't get all the prompts and can just click Refresh to update the spreadsheet?

    If anyone knows of a better way to create end user tools, I'm open for suggestions.  Can javascript be used to access cloudsuite data?

    Newbie looking for some direction.

    Thanks in advance.

    John Henley
    Posts: 3353
    4/12/2023 10:07 PM
      Hi Bill. I understand your pain. I’ve had discussions with the support and developers about being able to control ISD from macros/VBA. There are numerous limitations to using ISD and I would caution against trying to use it for anything programmatic. In particular, two things are a concern. One is multiple sheets. When I have more than a few sheets targeting different business classes, ISD and Excel hang a lot. Also you cannot target the same business class from two different sheets. So doing a multi-sheet upload to journal entries won’t work. Behind the scenes, ISD uses excel tables and keeps renaming the tables so if you try to access them from macros, you’re stuck.

      As for the login, that’s required and the only way I find around it is to disable or uninstall ISD. Quite annoying IMHO.

      You can hide/show the query pane.
      Thanks for using the LawsonGuru.com forums!
      John
      Bill Brennenstuhl
      Basic Member
      Posts: 16
      Basic Member
      4/13/2023 7:52 PM

        Hi John,

        Thanks for the information.  Most of our tools are separate workbooks with single sheets.  It's looking like we'll be either writing custom reports and personalizations if IT let's us or Birst reports.

        Thanks again