Matrix as a lookup table

  • Resolved Simon

    (@simonmaddox)


    4 years, 1 month ago

    My client has the prices for blinds supplied in a spreadsheet – columns show widths and rows height of the blind. Is it possible to use a hidden Matrix module to lookup the nearest price given 2 numeric input fields for width and height?

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author moomooagency

    (@moomooagency)

    Use NOV matrix.

    Thread Starter Simon

    (@simonmaddox)

    Thanks for the amazingly fast response. I’ll look into that.

    Also, I’m failing to import the price table. Should the CSV have a header row, or just a table of numbers?

    Plugin Author moomooagency

    (@moomooagency)

    Pls, check the example csv from the docs.

    Thread Starter Simon

    (@simonmaddox)

    Got it – the “Comma Separated Values” file not accepting commas was a ‘gotcha’ for me in the UK. It’s a real pain having to change my Windows Regional (advanced) settings to get this to work!

    It would be fantastic if you could make the separator configurable.

    Also, It would be much easier if for each matrix you could select the operation to be Nearest (as present), Round Up or Round Down. Would save having to create additional columns with duplicated values just to achieve this. I’m sure there will be other ways to do this (with other NOVs to do the rounding?) but it would be simpler to maintain if included in the Matrix NOV.

    The CSV file is no longer available for download is there a new link available?

    Plugin Author moomooagency

    (@moomooagency)

    Yes, there is: https://bit.ly/uni-cpo-csv-example

    csv sample link is not working – I am having similar issues getting the format just right

    Plugin Author moomooagency

    (@moomooagency)

    It works now, the new link. I posted it in the previous message. It is also in the docs now.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Matrix as a lookup table’ is closed to new replies.