Can a bot ignore a valid_if?

AppSheet AppSheet Q&A
1

I have a column that i need a valid_if on to prevent users from seeing certain data in a dropdown. I also have a bot that needs to insert data into the table that specifically violates that valid_if. Is it possible to have the bot ignore the valid_if logic?

2

Something like this:

IF(
  ("Server" = CONTEXT("Host")),
  LIST([_THIS]),
  ...user-facing Valid_if logic...
)
3 Likes
3

Hello @wangoandcash and welcome to the community!

How are you determining the data that users can see? is there a flag or a category-subcategory relationship?

@Steve thanks for the suggestion!

2 Likes
4

Thanks! The host context worked.

2 Likes
5

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.