Post by Swing Wren in Google Sheets for Unity comments

Viewing post in Google Sheets for Unity comments

Ieps! great tool.

I have two questions though. How do you properly import data with columns that have a formula like this '={OtherSheet!A:A}' ? right now importing that data causes to import all the spreadsheet rows, I can filter the ones that are valid but maybe there is a better solution. The second question is related on how to securely handle the password in the connection file that is only needed in the editor (not store it in the repository), do you have any recommended solution to that? right now I'm just using a file ignored in in git that contains the password.

Regards!

Novack4 years ago

Hello @Swing Wren. Sorry about the delay coming back to you. The dayjob has been very pressing and the time for GSFU support has been tight.

Im not sure I understand correctly the case. What you mean "importing that data causes to import all the spreadsheet rows"?

Regarding the password, your approach seems fine, however it may be limiting if the project uses any sort of CI/CD, so if you use for example Unity Cloud Build, you'll need to include the pass in the repo. Otherwise is good, just make sure that the file is included in the build. I dont have any particular recomendations, as usually the people involved in the project needs access to the service, and is unlikely to result feasible for the devs to not count with the pass.

Swing Wren4 years ago

Thanks for the reply!. What i mean is that using

ConfigRaw configRaw = JsonHelper.ArrayFromJson<ConfigRaw>

With '={OtherSheet!A:A}' it causes configRaw to have 999 elements (all rows).

Novack4 years ago

Thanks for the clarification. I'll have to try that! Have not seen behaviours like that before, but neither used that forumla, so I'll try and get back to you.

itch.io

Viewing post in Google Sheets for Unity comments