Hello Gliders, I am wondering if there is a way to enable fields based on inputs to other fields. So for e.g. show field Color only if the entry in the Product field is Tshirt. Thanks much!

This presents new difficulties. I’m going to go ahead and say it’s not possible to do the yes/no lookups in add/edit mode. Potentially it might be possible in detail view when using entry fields, but the record would already need to be added at that point. I had already attempted something like this with no luck and included a thread link below. Maybe if you could somehow encode 4 unique character combinations into your location name. So your location Choice Component would look like “Location 1 E-W-”. You could set you Visibility condition to use the Contains operator. If the location contains “E-” then show the Employees component and so on. That’s kind of the best idea I have for now. [image] Visibility based on more that one condition Feature Requests @Mark Looking at @Gerard_Fernandez question again, I may have misunderstood his question. I didn’t realize he was in an Add/Edit situation, so I don’t think I have a solution for him. As for a Visibility condition based on Relation/Lookup I think I may have set it up wrong. I was using a Multiple relation with a Lookup column against that Relation. I changed the Relation to be a non-Multiple single relation. The Lookup column I created against that relation now shows up under the list of co…

Are you talking about adding/editing records, or just viewing them? I don’t think you can control fields showing or hiding when adding/editing, but when viewing a record, column values that are empty will not display.

I was hoping to use such a feature for adding/editing records. Certain columns only apply to certain product types and it makes the layout really clunky to have all columns display for all products irrespective of whether they apply or not. Having a feature to enable/disable columns would be great.

This feature is now available in case you weren’t aware. [image] Conditional visibility of components usage question Bravo on this feature release @Mark . Saw the announcement in app but haven’t seen in mentioned in the forums yet. Quick question about implementation, is there a way this can be used which bases it on a condition of the signed in user? Basically i’m trying to accomplish user roles where if the user has a role assigned of “x” they would be able to see the component.

I am not sure how to use this. I only want the user to see items where the date (which is a column) is equal to today(). I can’t do this with the math column. I can’t do this in the google spreadsheet either since the formula would have to be copied into the new item row manually for every new item added.

What are you trying to control, a list or other components? You can control a list using a filter with the Within operator. For your spreadsheet formula, you can auto populate rows using an arrayformula. https://docs.glideapps.com/all/guides/quick-starts/intermediate-techniques/calculating-columns

Thankyou Jeff. The arrayformula worked for one of the issues I was having. The feature of controlling ‘visibility’ of components for existing items is awesome. But how would it work for adding new items?

Same way it works with existing items. Just add a condition to the component. [image] Conditional visibility of components usage question @mark Seems to be working in Add/Edit mode @yinon_raviv You can now add conditions to show or hide components based on other component or column values. Here are some screen shots that show how to do it. Select a component to edit it’s details: [Capture] Select the Features tab: [Capture2] Add the condition you want: [Capture3]

I’m certainly am missing something. Let me explain. I have the following 5 components in my sheet Location of employees 3 # of desks 4. # of machines 5. # of widgets For Location 1, I only want to show the components # of employees and # of desks For Location 2, I only want to show # of machines and # of widgets For Location 3, it should show all components How would I accomplish this? Visibility feature is tied to only one component right now.

Can you create 2 of each employee, desk, machine and widget components? Then set conditions accordingly. Location 1 will show first employee and first desk components Location 2 will show first machine and first widget componets Location 3 will show second employee, second desk, second machine and second widget components

Enable fields based on other fields

Ask for Help

Jeff_Hager November 21, 2019, 4:25am 9

Same way it works with existing items. Just add a condition to the component.

Topic		Replies	Views
Conditional visibility of components usage question Ask for Help	17	3350	April 24, 2020
Visibility! Hello Glide Family. I can't see some of my Text Components Ask for Help	14	150	August 5, 2024
Enable/ Disable Columns Feature Requests	1	755	November 20, 2019
Choose which fields to display Ask for Help	5	370	December 18, 2022
Viability based on another component Feature Requests	0	313	December 23, 2021

Enable fields based on other fields

Related topics