Either column required but

#1

I have been playing around with this but cannot get it to work. A user suggested that either a field should be keyed in or an image uploaded, but not to require BOTH. My first inclination was to make two edit fields, one visible (and required) if the image is empty, and the other visible (and not required) if there is an image. But Glide didn’t like the conflict that two objects were writing to the same column. Then I tried to make a computed column to test either one containing data, but you cannot make a computed column “required”. I know I can make a custom form and make my own save and cancel buttons, but … is there any simple way around this?

#2

“My first inclination was to make two edit fields, one visible (and required) if the image is empty, and the other visible (and not required) if there is an image. But Glide didn’t like the conflict that two objects were writing to the same column. “

The message you see is just a warning. If I understand you correctly and you only need one or none then that should work.

3 Likes
#3

Thanks. Trying it again (never actually saved a record…)

1 Like
#4

That worked for the add screen. On the update screen the visibility flags didn’t work right. I ended up just making the data not required on the modify screen.

1 Like
#5

You can use external CSS to do that.

<pre><span><style>

[data-test="nav-button-Done"] {
opacity: 0.4;
pointer-events: none;
}

Then make that visible whenever both of your fields are empty. When one of them is filled the CSS will be deactivated.

3 Likes
#6

Excuse my ignorance, but where do I place that code? In an object? In a column? I tried on another post using some CSS, and it just showed in the object like “I’m here! I am CSS!”

#7

CSS needs be placed in a Rich Text component, and it needs the proper HTML tags included.

<pre><span><style>

I like to close those tags afterwards but many people don’t and it still works.

#8

So the user will see the CSS? I’m confused…

#9

No, they won’t see it. It’s CSS wrapped in html tags, so it doesn’t render as visible text.

Instead you control the visibility of the rich text component.

5 Likes
#11

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