How can I put a table within a survey?

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?

collect

asked 28 Jul '22, 09:25

Rajkumar
104●2●28●57
accept rate: 3%

3 Answers:

active answers oldest answers newest answers popular answers

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 (OF) ♦♦
4.8k●1●1●9
accept rate: 19%

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 (OF) ♦♦
4.8k●1●1●9
accept rate: 19%

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
104●2●28●57
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

learn more about Markdown

Question tags:

collect ×494

question asked: 28 Jul '22, 09:25

question was seen: 795 times

last updated: 01 Aug '22, 10:24

How can I put a table within a survey?

Follow this question

Related questions