curtacircuitos / octopart-google-app Goto Github PK

I wrote a function to add the ability to sum the number of parts available on the market and would love to commit to the project. I'm new to github though - and it appears I don't have valid permission to do so.

Using the example from the screenshots, enter the formula:
=OCTOPART_DISTRIBUTOR_PRICE("ADA870")
Result is "No offer found". The result is the same for all functions that return part details, and for all part numbers that I've tried.

When attempting to add this Add-On, there is a window with a message stating the following:

Sign in with Google temporarily disabled for this app

This app has not been verified yet by Google in order to use Google Sign In.

Hi all,

First, thank you so much for creating this script and distributing. This is so helpful to my team and saves us hours of work. Unfortunately, we ran into an issue where this script is no longer functioning and everything is showing as no offer found. There appear to be two potential reasons. The first error that we get is that the webpage https://octopart.com/bom-lookup/upload is showing up as no longer available. The second potential issue is that octopart recently switched to v4 version. Is this script going to be updated to work with the new version?

Hi,

I'd like to view thumbnails with a link to a larger image.

I'm not experienced coding addons, so I'm not sure the best way to do it.

I'm thinking:

1. Load jQuery when the addon is enabled. I don't know the best way to do this.
2. When =OCTOPART_IMAGE('foo') is used, ask the API for include[]=imagesets
3. Return the first ImageSet result with a non-empty value. Use URLs from swatch_image and large_image; insert following HTML fragment:
   html <a href="{large_image}"><img src="{swatch_image}" title="{mpn_or_sku}"/></a>
4. I think that's about it.

I'm sure this is pretty trivial, but I don't know about 1., which is why I didn't just do it.

Attempting to log in to the app then installing the add-on gives the following error:

From what I can tell, the app needs to be verified, according to this:

https://stackoverflow.com/questions/50509667/sign-in-with-google-temporarily-disabled-for-this-app

The process is outlined here:

https://developers.google.com/apps-script/guides/client-verification

Was having an issue with functions in cells loading indefinitely ... fixed it by deleting semicolons that trail end brackets in the code per: https://stackoverflow.com/questions/20718931/new-google-sheets-custom-functions-sometimes-display-loading-indefinitely