Hello OFT, I am trying to develop a survey that will be used by foresters to estimate timber and firewood based on directive of authority. There is a table containing values that will be used to calculate different aspect of tree analysis. Now I want to use the table (like VLOOKUP in excel) but not figuring out where to put readymade table in the survey. How can I implement this on collect survey?

asked 28 Jul '22, 09:25

Rajkumar's gravatar image

Rajkumar
10422353
accept rate: 3%


Dear user,
You can create a new Species List (named "trees" for example) in the Species List tab of the Survey Designer, importing a CSV or Excel file with these (mandatory) columns: code, family, scientific_name.
All the other columns (use only lowercase letters and avoid special characters, e.g. a, b, c, a_1, a_2, etc) will be considered as "extra" info columns and you can retrieve that information with the expression: idm:speciesListData('trees', 'a_1', 'AFZ/QUA')
The first parameter is the species list name, the 2nd is the "extra" column name, the 3rd one is the code of the species. If you want it to be extracted from the value of a taxon attribute, in the 3rd parameter you can specify the name of the taxon attribute, e.g. idm:speciesListData('trees', 'a_1', taxon_attribute_name).
I hope it is a bit more clear now.
Many thanks.
Open Foris Team

permanent link

answered 01 Aug '22, 10:24

Stefano%20%28OF%29's gravatar image

Stefano (OF) ♦♦
4.7k19
accept rate: 20%

Dear user,
Can you associate that information to the species list? In that case you could add some "extra" value to every species and extract that information with the function idm:speciesListData, e.g.:
idm:speciesListData('trees', 'max_dbh', 'AFZ/QUA')
Let us know, many thanks.
Open Foris Team

permanent link

answered 28 Jul '22, 10:39

Stefano%20%28OF%29's gravatar image

Stefano (OF) ♦♦
4.7k19
accept rate: 20%

Hi OFT, Thank you very much for your response. I just want to put these information as shown in below table in any form but should be able to retrieve during calculation. Does collect give permission to put these numbers of column? if it is possible I will do rest of the task as you suggested in your previous answer. can I create such columns? Thank you very much. alt text .

permanent link

answered 30 Jul '22, 18:41

Rajkumar's gravatar image

Rajkumar
10422353
accept rate: 3%

edited 30 Jul '22, 18:44

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×493

question asked: 28 Jul '22, 09:25

question was seen: 677 times

last updated: 01 Aug '22, 10:24