Hello :) is there a way to make an automatic ...

(Stephane Grimaud) #1

Hello :slight_smile: is there a way to make an automatic description? Example with : “What’s your name?” and below description : “Type a short name, 20 letters max”

“Zip code?” and below

description : “5 digits max”

… Of course every questions is the header of each columns. And the description is in row number 2.

Any idea? Thanks !

(Aleksi Alkio) #2

What you mean by “Automatic description”?

#3

In the Editor there is a column called Description, you can put a description in there.

(Stephane Grimaud) #4

@Aleksi_Alkio

I mean: the Description field has to be filled with a formula. And the formula must find the text (for the description) in the row number 2.

(Aleksi Alkio) #5

Still not sure what your structure is. Do you have a separate question/description table where you have lot of columns. Each column has two rows… question and answer. Am I correct?

(Aleksi Alkio) #6

If yes, why don’t you have two columns (question, answer) and lot of rows?

(Stephane Grimaud) #7

Yes, two columns can be a solution. Thanks!

(Aleksi Alkio) #8

First column is a question field and 2nd one is a description. Then you can read the description with a formula as LOOKUP(“Question name”,TableName,Question,Description).

(Stephane Grimaud) #9

Perfect! :smiley: