Why can't I move these formula fields?

J

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?

Screen Shot 2021-09-12 at 18.37.47

J

Here are a few more screen shots to show how it is set up:

 

Screen Shot 2021-09-12 at 18.56.16

Screen Shot 2021-09-12 at 18.56.33

M

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)

M

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

J

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.

J

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?

Ninox Profile

There is at least one workaround. Are you using the browser version or one of the apps?

J

The Mac app, purchased from the Mac app store.

Ninox Profile

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

 

M

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 !

Reply