Show value of only a specific cell?

  • Resolved pforpho

    (@pforpho)


    7 years, 6 months ago

    I’m at a lost and I’ve been trying to get this working for hours with no luck.

    What I want to do is just show the value of a specific cell

    [gdoc key=”X query=”select F” class=”no-datatables”[/gdoc]

    I’ve tried
    “query=select F2” “query=select &F2&” and all other variations, but can’t seem to get it working.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Meitar

    (@meitar)

    That isn’t how select works; select choose a single column. offset skips rows. limit stops the selection after a certain number of rows. Maybe you want select F offset 1 limit 1, which would return the value of the single cell at column F row 2.

    Thread Starter pforpho

    (@pforpho)

    Using this I get an error [gdoc key="x" query="select F offset 1 limit 1" class="no-datatables" [/gdoc]

    status:"error"
errors:[{"reason":"invalid_query"
message:"INVALID_QUERY"
detailed_message:"Invalid query: PARSE_ERROR: Encountered \u0022limit\u0022 at line 1
column 19.\nWas expecting one of:\n \u003cEOF\u003e \n \u0022label\u0022 ...\n \u0022format\u0022 ...\n \u0022options\u0022 ...\n "}]}

    Did I format wrong?

    • This reply was modified 7 years, 6 months ago by pforpho.
    Plugin Author Meitar

    (@meitar)

    ˉ\_(ツ)_/ˉ Try it with limit before offset? I dunno.

    Thread Starter pforpho

    (@pforpho)

    That worked! Thanks!!!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Show value of only a specific cell?’ is closed to new replies.