Why can't I move these formula fields?
I'm using formula fields to display an image stored in another table, based on what is selected in the table reference popup field. The problem I'm having is that the formula fields are being forced to the far left of the form. I am unable to move them to the right at all. When I move the one with the blue image in this screenshot between the two other fields, it shows the grey box where it should end up, but as soon as I let go of the mouse button, it snaps back to the left. What am I missing here?
34 replies
-
Here are a few more screen shots to show how it is set up:
-
at the moment Ninox prhrammers (for some unknown reason!) only allow and image field to be on the extreme left.
Frustrating it is too! Thet are looking at it (but have been for last 2 years)
-
argh that should read "programmers"!
and applies either when the image field is direct placed on the form (image field) or called via a from another table via formula
-
Man, that's obnoxious. This software can do some great things, but UI layout freedom is absolutely lacking with forms. You should be able to freely build the forms and other "display" type things without restriction. Especially since it's so drag-and-drop focused as it is. I guess I'll start migrating this new database I made over to Microsoft Access. I made it for fun in Ninox because Ninox is easy, but I should be able to design the form like I'm working in MS Publisher.
-
The database I made works exactly how I want, however, this limitation definitely keeps me from designing it how I want. Why on earth would I build a database for a business when I can't freely move form elements around?
-
There is at least one workaround. Are you using the browser version or one of the apps?
-
The Mac app, purchased from the Mac app store.
-
Jess,
This is another CSS hack. It's the second workaround that I know of and is actually easier than the one I was thinking about when I posted earlier. You need to put this in a Formula field on all forms where you want it to be active. You can't hide the Formula field using "Display field only, if:". Instead you have to hide the label and set the background color of the Formula field to the background color of the form. Here's the code for the Formula field...
html("<style>.form .editor-file {float: none;}</style>")Take a look at this thread if you want more UI options, https://ninox.com/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/fonts-colors-and-borders-61285d0639e48338717bcd64
-
Hi Sean
One question. The Info / Albums is a Formula field and I like to align on vertical the other fórmulas field's (Album CD's, Albums CD's2 .........)
Is posible?
The formula don't work for me
-
I won’t be able to look at it until this evening
-
no problem Sean -
It's not looking good. I'll have to spend more time checking other options. This only partially works.
html(" <style> .form .editor-html {float: left;} </style> ")They are all Formula fields with html, correct?
-
yes Sean all are formulas
-
They are all Formula fields with html, correct?
I am unable to stack Formula fields with HTML vertically next to another Formula field with HTML similar to your screenshot by modifying CSS on existing Ninox classes.
I think you will have to combine those 4 formulas into a single Formula field with HTML.
-
OK Thanks for your time
-
I found an ugly solution, but it might work for you. You will need to fiddle with the top and left values in the CSS formula to make it work for your layout. I attached a simple database.
-
I forgot to mention that you will need to change the nth-of-type numbers to match the field's position on your form. I had to add a line break as well.
I have attached an updated example.
-
-
Works but is too sensitive is difucult move field
Thanks Sean
-
Yeah, it removes those elements from the document flow. No worries
-
Hello Sean, I was reading your post from 2 years ago. This post was referred by
I was facing problem with the alignment of Image element on the form. I know that you have written a few posts about hacking the UI designer using CSS. Just wanted to understand that is there a CSS like that can we can make only work on the Image fields instead of all the elements on the designer. This one looks like will work for all the elements.
Also does this script means that the elements will be placed where we place them on the form and will not auto align anymore?
-
-
Sean
I'm on thr brower version. It would be helpful to know wht the first hack is.
Jess. I agree there a few things in Ninox that they need to play catch up on. However there are so many advantages to this software that it makes the odd flaw - somewhat palatable !
Howver as Sean has shown - there are often non official workaroounds that can be employed. Thus I have learned anoher new thing today !
-
Mel,
This version works in the context of Jess' application, but I see that it doesn't allow multiple fields to stack up beside the Image or Formula field with an image. I'm not sure why as I used similar CSS code for the Theme Helper database app. Fields are stacked to the left of the "Contact" header in the upper right of the "CSS View" tab. I'll look at it tonight.
Here is the link for the other workaround, https://ninox.com/en/forum/use-cases-5abd0b9c4da2d77b6ebfa395/photo-field-alignment-5ff9b5ecfa464c2d2a46c35f
-
Thanks for the insight, both of you.
Sean, I'll give the CSS a go and see how it does. I guess I'll finally be using that CSS3 Certification I earned in University while working on my Bachelor's degree. =)
Mel, I agree. It's such a good database app for people who don't need / want to learn the intricacies of something like MS Access aseems that it can be just as powerful with some slight annoyances. I mean, I made a database to track the paint colors and schemes for Warhammer 40k Miniatures. I'm not using it for any serious application. Even if it were, It's still a fantastic program that just needs some love in certain areas from the Devs. -
Sean,
I do remember seeing your post in the above link for photo field alignment. I remember discounting it immediately because this particular database has hundreds of individual images and didn't want to have to go through that manually for each one in each application of it.
Content aside
- 4 mths agoLast active
- 34Replies
- 1564Views
-
3
Following