I would like to show users a Form which has an option of either a) uploading an image or b) pasting in a URL
The sheet has two columns - Image 1 and Image 2 (then I have a Google Sheets formula to pick which image, transform them, etc)
In the Form I would like to have the user click on a Choice (or button) to therefore only display the method they choose. BUT the form has not been saved, so no row/column values have been set for me to use Visibility. I have made a screen recording to show what I meanā¦ and it may simply not be possible. Thanks! M
You have the right idea, but in order to use User Specific Columns in that way, you need to pass on the native Add Form, and create your own Form from a Details layout. Then the USC value will be written to the column as soon as it is selected.
So from your previous screen, do a Link to Screen ā This Item, and then build your form out from there.
Itās a little bit fiddly doing it this way, but in the end you have much greater control.
Edit: I guess I should add that when you build your own form in this way, there will be no āAddā option at the top (as you have with the native Add Form screen). So you need to create your own. But thatās usually just a standard button labeled with āSubmitā (or whatever), and you configure this with an Add Row action - and anything else that needs to be done. Usually - a notification indicating success, perhaps a Go Back action, and usually clearing the value of the User Specific Column (if appropriate).
Sadly this will not work for meā¦ I am using the card swipe interfaceā¦
and there is a bug when using the Floating Button (my ideal, but the button duplicates)
so I have to use the + and therefore the standard functionality
A little video of what I am trying to achieve, and the wider context - thanks!
Iāve not played with the Swipe layout yet, so best I donāt try to advise your there or Iāll surely wind up with my foot planted firmly in my mouth
But, regarding the magical duplicating floating buttonā¦ have you checked if the extra button persists if you navigate to another tab and then back again? And have you checked if the duplicated button appears outside the builder? Reason I ask is that Iāve noticed similar (but not exactly the same) behaviour with floating buttons - but only ever inside the builder.
@SantiagoPerez Iām sitting here scratching my head trying to figure out how that works. I just tried to replicate it, but I canāt. My understanding is that those boolean columns shouldnāt be set until the form is submitted - so how on earth are your visibility conditions working? (What are your visibility settings, btw - you didnāt show them in your video)
Hehe, well, I canāt fully explain it but Iāve been doing the same thing as @SantiagoPerez for quite awhile, so itās nothing new.
I understand the confusion, but I think you might be thinking more along the lines of filtering as opposed to visibility. It used to be the case that you couldnāt filter an inline list or choice componentā¦or set a value for a relation used for an inline list or choice component from within a form, because of the very reason that nothing has been written to the sheet yet. That led to the addition of Screen Values as an option to filter lists or choices based on values selected on a form screen.
Jeff, thanks. I think the thing thatās doing my head in is that even though the switch state is affecting the visibility of the other component, there is nothing being written to the underlying table. So itās like itās acting like a screen value even though it isnāt configured that way. It is, but it isnāt. A Schrƶdingerās screen component
Been doing the same thing as the others, without realising how little sense it makes.
I just assumed that it holds the data in a temporary format ready to be written on submit, and for some reason that data is readable. Didnāt think anything else about it.
Importantly for @Mark_Turrell it means that he should be good to get his switch/choice working
Works like a charm! It will really help to build more custom forms without having to have lots of sheets with lots of separate form info. I donāt mind how it worksā¦ it just works. Stellar share - thanks!
Hi @Darren_Murphy - I triedā¦ and it is a double button in the builder, on the desktop, and on the iPhone. And putting 2 buttons on gives me 4 buttonsā¦
wow, thatās impressive.
I think you mentioned that it is a Private Pro app, yes?
Iād be reaching out to Glide support with that one (support@glideapps.com)
Just one thingā¦ I see a Rich Text component in your components list. I donāt suppose that contains any funky CSS?
I think the double buttons are there because the underlying card is already rendered for whenever you swipe. The second button just happens to float to the top.
It would be complicated, but Iām sure you could set up some sort of logic to check which card is being displayed on top and conditionally hide or show the underlying button. I donāt have any ideas off the top of my head, but like I said, it would probably be overly complicated.
I am actually recreating an app I raised $120K for back in the dayā¦ and spent it on a sort of working mobile app that was then too expensive to keep upgraded (without customers). I had an offshore dev team, spent time in their offices, etcā¦
In the end, it was the normal thing to do but I did not get far. Already in just 10 days of playing around I have worked out how to build the MVP, and versions 1, 2, and 3.
For instance I made a prototype of a āDatingā cardā¦ card type = Dating - then a Compound Action for a Right Swipe - with a condition - if card type = Dating show this formā¦ BUT (and this is the clever bit) ā¦ it is ALWAYS the same form! And the same backend sheet. I use visibility on the form components so that it looks like they are all dif forms, but they are the same, and same to the same sheet (even making use of some of the same columns too).
So a Game card with an embedded HTML5 game
A Demotivation Card - that has these nice postersā¦ (using Cloudinary to rotate 90 degrees to it takes up the whole screen)ā¦
and a whole lot more to come
And I keep feeling like I have no idea what I am doing! Great fun and I am hugely appreciative of the community too I will share properly soon as I have decided to get better feedback with a working app (and then play behind the scenes, using Visibility settings, hidden tabs, etc to work on the new stuff)
Hey @Darren_Murphy thanks for the video. However, I am not able to see the option to āShow component whenā at all. All I can do is select columns from my data.
Any idea how to get this? Am on a Pro Private app.
I just tried to replicate it, but I canāt. My understanding is that those boolean columns shouldnāt be set until the form is submitted - so how on earth are your visibility conditions working? (What are your visibility settings, btw - you didnāt show them in your video)
(Did you get it working?)
