Use VSCode or Np++ to edit long XLSForm notes/formulas with syntax highlighting

[nmambre]

This is more a tip/trick but I still want to know if someone has similar tricks to make it easier to create forms.

I was editing a long label for a note, with a a couple of instance()'s and it was getting difficult to edit in the cell in Excel.

Copied to VS Code, it automatically identified it as "coffee script" so now I have the benefit of finding matching parentheses, brackets, etc. In the screenshot I've deleted a closing parenthesis (line 5) and it shows the other one in red because there is no match.

I tried with other extensions, md, js, html, ts, but for this case the coffee seems the best solution, to get strings highlighted and brackets, parentheses and curly braces matched and highlighted.

[Faisal_Amani]

Please Share the Xlsform of this file i want to try

[nmambre]

I've made changes to the form that I can't share the current one, but basically I was working on the form that was originally in

Pulldata for complete row + exclude variable for upload to Central

Hi, I'm using a select_multiple_from_file, and then I have to use different pulldata to get the other data from the CSV. Pullrow Does something like pullrow() exist or can it be implemented? It would get the whole row in a single variable and then you would be able to use something like ${data}[0] to access the first item. [image] So my task1 (see attached form) would change from pulldata('tasks', 'label', 'name',${selwtask0}) to pullrow('tasks', 'label', 'name',${selwtask0}) and then in m…

Also for the record, any form would work, I'm not actually opening the form in VSCode or something like that, just copying the content of the cells in Excel with long formulas, like in this case where you want to present a summary to the user.