grossd's Forum Posts

  • Hello,

    I am looking to hire someone to build a plugin for Google's authentication scheme in C3.

    developers.google.com/identity/protocols/OAuth2

    Apparently only with oAuth2 I can write to a google sheet from C3.

    Can you help me with that, how much would it cost?

    thank you,

    Dan

  • Hi,

    has anyone successfully implemented oAuth protocol in C3, to, say, access a google suite app such as a spreadsheet.

    Some google apps support key based authentication, but i am running into problems for PUT requests. Other google apps, such as the Google SQL database requires oauth.

    thanks,

    Dan

  • Try Construct 3

    Develop games in your browser. Powerful, performant & highly capable.

    Try Now Construct 3 users don't see these ads

  • Thank you.

    In my case (with the way JsonManager looping works), there is a sub-event under the loop to test for conditions within the loop, and a parent event, that for the loop itself.

    Placing an empty event underneave the jsonManager loop doesn't seem possible, but i can place it as a "sibling" underleave the top parent.

    Will try this out once google sheets api comes online again -- for some reason, the google sheets api suddently stops responding to ajax calls, and after some wait (30 min? an hour?) it suddenly works again.

    anyway, thanks, will give it a try

    Dan

  • Hello,

    I have a for loop that via a sub event / actions fills a listbox with values. During the filling, the listbox does not trigger any changed selection event.

    I want to select the first item in the listbox after the for loop completes and all values are filled in, so that the selection triggers additional processing in filling in items in the UI -- for depending items.

    I cant figure out how to add an action after a loop completed -- since the loop is within a subevent. and there is no way to add actions after the subevent at the level of the parent event.

    any thoughts how this could be done are much appreciated,

    thank you,

    Dan

  • Hi,

    Yes!

    That is the approach I did as well. Just yours is much cleaner -- to use loop index (instead of a local variable) in the subevent to identify the column.

    great.

    thank you,

    Dan

  • I solved it in a somewhat cumbersome way:

    Since the loop apparently goes through all values in the table "breadth first" -- across each row, i added two subevents with condition 0 and 1, respectively. i then have a counter that "flip flops" between 0 and 1 (by adding one to a counter and then taking modulu 2).

    Like this each subevent "knows" what column it handles.

    But, i think its is pretty cumbersome and better if there is a simple way to access each column in a received row -- via a simple expression.

    can this be done

  • Hi,

    Could i ask you how the loop would be changed if i am downloading a table rather than a column only. Something like below.

    Now, i would want to show Str1 to Str4 in the listbox, while storing in a dictionary Str1 ... Str4 as keys with the numbers "1" to "4" as the values ...

    (i.e. a mapping from the strings to their respective identifiers

    I tried to add the accessor [0] of [1], such as: trim(JsonManager.GetJsonValue("","[1]","Yes")), to access the strings, when building the listbox, but this didn't work.

    thank you!

    Daniel

    {

    "range": "Sheet1!A4:B7",

    "majorDimension": "ROWS",

    "values": [ [ "1", "Str1" ],

    [ "2", "Str2" ],

    [ "3", "Str3" ],

    [ "4", "Str4" ]

    ]

    }

  • thank you!

    this is very educational example, how to use the constructs together.

  • Hi,

    Below is a sample that doesnt seem to parse correctly.

    dropbox.com/s/apzz8j7qw4t3nl0/jsonSample.c3p

    if you can look at it,

    thank you,

    Daniel

  • Hello,

    I am trying to use google sheets as backend for storing data.

    Has anyone successfully implemented the oAuth authentication process in C3

    thank you,

    Dan

  • Hi

    Thank you.

    As mentioned in the plugin comments -- its a great plugin indeed, but for my purposes it would need to support reading in json from a string rather than a file only. If you could add this functionality that would be great.

    (or, alternatively, or in addition, to have the plugin submit a user provided ajax call, that expects a json string in return, which is then used to populated the json manager)

    Dan

  • Hello

    I am using an ajax call to access google sheets, to retrieve a range of values (e.g. sheet1!A1:A3)

    The reply format is in json such as follows.

    I want to insert value1 ... value3 into a listbox, but have difficulties accessing the items in the values array.

    How is this done in C2 or C3 ?

    thank you,

    Dan

    {

    "range": "sheet1!A1:A3",

    "majorDimension": "ROWS",

    "values": [ [ "value1" ],

    [ "value2" ],

    [ "value3" ],

    ]

    }

  • Good point ...

    I wouldn't know, since i haven't developed C2 nor C3 plugins.

    But, whoever would do some porting will likely quickly notice to what extent plugins could be automatically ported.

    Dan

  • Hello,

    C3 is awesome. However, its really great with lots of plugins extending its capabilities.

    Philip Deblonde put together a while back a long list of plugins for C2 on git, which would be great to port to C3.

    github.com/Pseudopode/construct2_plugins_behaviors

    Question:

    Could there be enough C2/C3 community members interested in crowd funding the porting of the plugins from C2 to C3?

    Are there plugin developers who would be willing to take on that paid job?

    looking forward to your responses,

    Dan

    p.s. Philip is not available for porting, but is happy to provide (from time to time) guidance

  • <insert dropbox logic>

    Bandwidth hog?

    :-)

    thanks,

    Dan