FREE Chrome Extension that enhances the Expression Assistant

Gotcha!

It seems the editor changes have not reached my AppSheet account yet. Once they do, I will investigate the break and respond with an ETA on the fix

3 Likes

Thank you!
It is easy get attached to the QREW Editor.
Let me know if you need remote access to my Chrome browser?

Haha Right? Im especially missing the auto closing parenthesis and brackets!

@Stefan_Quartemont interesting catch: The extension shows on a lot of my older apps. Tried updating version in the Manage-Version Tabs and after doing that it disappeared for that app.

Mainly confirming some sort of change in the appsheet’s editor that the extension show/hides based on.

Looks like the crash is from this function in the extension code that looks for the App ID in the page.

function scrapeAppId() {
    return (
        document.querySelector("#appPreviewLink")
            .href
            .match(/appId=([a-z0-9\-]+)/)
            [1]
    );
}

We made some changes to how the editor loads, which seems to have removed that link in so The extension runs just fine if I attach the debugger at the return statement and run this:

$(document.body).append(
  $('<a id="appPreviewLink" href="appId=deadbeef">bar</a>'))

Scraping code is always going to be kind of brittle, though we’re certainly not trying to break stuff! We do have a window.getId() function, which is similarly an internal API but is less likely to change in the immediate future.

1 Like

Steve,

Thanks for looking into that and reaching out! I suspected that could be the culprit based on the screenshot posted previously. I knew our method of extracting the Apps GUID from the HTML for the API call to return the app schema was kinda sketchy and would be likely broken based on an AppSheet editor update.

I will get that updated based on your feedback.

Thanks :slight_smile:

Stefan

3 Likes

Hey Everyone,

We’ve just uploaded a patch for the issue. It has to go through a review process (0-3days) by Google and then it will appear automatically for everyone.

Thanks to everyone for flagging the issue and helping the debug process.

Keep Calm and AppSheet on!! :stuck_out_tongue_winking_eye:

6 Likes

Hy
Is back again. Thank you :crazy_face:

1 Like

Hi Qrew, nice work with the feature. I just noticed with a long Snippet name it cuts the top row in half.
image

Thank you for all of your hard work! This is a great addition to the AppSheet developer community.

This add a lot of important features that we were missing from the editor. But the 6-line limit is too small for many of my formulas.

I end up having to write my formulas in a text editor so I can see everything, then paste into the expression editor in AppSheet. This removes most of the benefits of the extension and adds a step-- making the original editor still a better choice for my regular work.

Are there any plans of adding a resizable editor? The regular AppSheet expression editor allows you to resize the window. And I have seen others request the same feature here:
https://community.appsheet.com/t/free-chrome-extension-that-enhances-the-expression-assistant/13313/16

I think you’ve added a lot of great features, and I would love to use them, but you’ve also removed a very important feature. Please consider adding a resizable window. Thanks!

1 Like

@GreenFlux - We don’t have a “Resizable” solution for the editor at this point. Some easier options are Pop-Out (Think nearly 3/4 full screen size editing area) or Collapsing some or all of the expression library below.

Which would you prefer?

@Craig_Clancy1 - Thanks for pointing that out. I will get a fix out for that in the near future

This.

1 Like

Seconded.

2 Likes

Agree with @Steve and @Bahbus. A toggle button to collapse the library and give the extra space to the editor would be ideal.

Thanks, @Stefan_Quartemont ! I don’t think the drag-to-expand feature is necessary if you can just toggle to a much larger view box with the library hidden.

3 Likes

Agreed with collapse. Your add-on makes it unnecessary anyway.

2 Likes

Well, The collapsers have it!

I’ll get working on that fix and let you guys know when it’s ready.

Thanks for the feedback - @Steve @Grant_Stead @GreenFlux @Bahbus

6 Likes