Data Validation

data
expressions
(Natalia Lemoyne) #1

Hi there!
My app has data validation on each column for each of the tables I have ( total of 1000+ columns) I applied data validation to the original Google sheet but when I regenerate the structure the data validation doesn’t transfer (I followed the documentation on how to do this- mind you, it is not Dropdown data validation)
I found that in order for me to make sure the data validation happens, I have to go to into the Appsheet editor>data>Columns> open each column editor and apply data validation there. Since I have 1000+ columns, I was hoping I didn’t have to do this 1000+ times.

Does anybody have an idea on how to do this?

Thank you,

(Steve Coile) #2

I recommend contacting support@appsheet.com directly for this. It sounds like a bug.

1 Like
(Natalia Lemoyne) #3

Thank you very much!

1 Like
(John Baer) #4

It is my understanding that AppSheet will apply Data Validation from a Google sheet into the AppSheet app. So yes, contact AppSheet to see why it is not happening your case.

However, I am curious what kind of data validation you might be doing that would require it on EVERY column? That would be highly unusual. And I assume you are speaking of the conditions that would appear in the Valid_If section of the column? Maybe you have a very unique use case? Maybe there is a way to simplify your app?

1 Like
(Natalia Lemoyne) #5

Agreed. This is an assessment (quiz) app. This assessment needs to be taken by hundreds of students. students are divided into groups and they can take the assessment in groups. There is a total of 40 groups. Each group is given a number and each group has a variation of the same assessment. In essence, the assessment is comprised of 8 questionnaires with 6 to 9 questions each. Each group will go through the 8 questionnaires in a different order (so that they can’t cheat) Therefore there is a total of 40 different assessments x 8 questionnaires with 6-9 questions each. Since each question needs a valid answer to continue, that’s why I need to add validation to each column because each column is a question. Hope this makes sense.
I thought of a way to randomize the questionnaires so that, let’s say group 1 starts the assessment and they are presented with questionnaires 3,7,4,2,1,6,8,7 in that order but when you choose "group 2’ you may get questionnaires 4,6,5,2,8,1,3,7- does that make sense? But I couldn’t figure out how to do that in App sheet. So I ended up making 40 unique combinations of the 8 questionnaires…sigh. that’s why the 1000+ columns…
I’m so open for suggestions, though! and thanks for replying to my message!

(John Baer) #6

I believe I get the gist. If I understand correctly, you basically have about 48-72 UNIQUE questions but because they appear in different assessments they are replicated about 40 times each as their own column in each assessment. If I am right then I say OUCH!

There would be a much simpler way to build your app. It would require basically starting from scratch but the end result would something that is a LOT easier to maintain and MUCH easier to change if needed. I think we can even work in the random feature you suggested. It would probably take a week or so to build it - I’m padding for unknowns.

For example, imagine if you now needed the questionnaires to be 10-12 questions each. That would be a lot of work to add those 3-4 questions into each assessment! A lot of work, even if you just needed to replace questions!

If the app was restructured in the way I have in mind, you could add, update, remove questions and have them apply to all your assessments in less than an hour!

If you are interested, I’d be happy to help. No business or monetary angle. I’d help just because! Just send me a private message if you want and we can figure it out from there.

1 Like