RightField with Google Sheets

[Mark Wilkinson]

Hi all!

I was sitting beside Carole in a meeting last week, and she indicated that there was support for Google Sheets in RightField.

I haven't been able to find this using Google-fu... can someone point me at the page that describes it?

Ta!

Mark

[Stuart Owen]

Hi Mark,

There is no direct support for Google sheets in RightField. However, since RightField is just based around basic validation tables in Excel (with no plugins), as well as LibreOffice, templates uploaded and converted to Google sheets should work.

I've not heard of this being done before, but I've just tested with a basic template from the FairdomHub, that contains rightfield elements. This appears to preserve the data validation after conversion (and work correctly as a google sheet), and then again when re-downloading as Excel.

After downloading again, all the hidden sheets were preserved, along with the ontology information, but for some reason RightField didn't detect and reload the ontologies, but I'm not quite sure why. I'll try and find some time to take a closer look into why.

e.g https://drive.google.com/file/d/1JqwG0XSs63T2f0ZCVj26_OiizgifGXvy/view?usp=sharing

regards,

Stuart

--
You received this message because you are subscribed to the Google Groups "RightField" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rightfield+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rightfield/16448985-a9b5-4be3-8ef2-e33a3282443e%40googlegroups.com.

[Stuart Owen]

On 14/02/2020 15:15, Stuart Owen wrote:

Hi Mark,

There is no direct support for Google sheets in RightField. However, since RightField is just based around basic validation tables in Excel (with no plugins), as well as LibreOffice, templates uploaded and converted to Google sheets should work.

I've not heard of this being done before, but I've just tested with a basic template from the FairdomHub, that contains rightfield elements. This appears to preserve the data validation after conversion (and work correctly as a google sheet), and then again when re-downloading as Excel.

After downloading again, all the hidden sheets were preserved, along with the ontology information, but for some reason RightField didn't detect and reload the ontologies, but I'm not quite sure why. I'll try and find some time to take a closer look into why.

e.g https://drive.google.com/file/d/1JqwG0XSs63T2f0ZCVj26_OiizgifGXvy/view?usp=sharing

Sorry, this is the full link to the version converted to Google Sheets: https://docs.google.com/spreadsheets/d/1JqwG0XSs63T2f0ZCVj26_OiizgifGXvy/edit#gid=2116434916

regards,

Stuart

On 12/02/2020 10:03, Mark Wilkinson wrote:

Hi all!

I was sitting beside Carole in a meeting last week, and she indicated that there was support for Google Sheets in RightField.

I haven't been able to find this using Google-fu... can someone point me at the page that describes it?

Ta!

Mark

--
You received this message because you are subscribed to the Google Groups "RightField" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rightfield+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rightfield/16448985-a9b5-4be3-8ef2-e33a3282443e%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "RightField" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rightfield+...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/rightfield/c9107171-c2ab-32d7-55e6-121d00c1f8c5%40manchester.ac.uk.

[Mark Wilkinson]

Thanks!!

--
Sent from my Android device with K-9 Mail. Please excuse my brevity.