Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Filter on hidden columns
Just to be sure, you are talking about a view like a new table view or form view or chart view. Or are you talking about a view element?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Related table field reference
Are you creating this new sum formula in Table2 or Table1? John's formula works if you are in Table1. If you are in Table2 then you have to use the select function.…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Help with wedding base
Sorry to hear about the crashing. I too use the app version. I've only experienced that when trying to delete a lot of records. If it happens every time then I would recommend reaching out to Ninox…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Return to my Topic
Maybe I'm not following correctly, but it seems like for the %_Plan field in the Avances table should be your master number for your DB. This will force a big rethink of the design of your DB.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Return to my Topic
Got the DB. Now I'm not sure what you want '%-Plan' in Plan_Real to be equal to.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: All I want for Christmas!
Thanks Steven, Just needed to switch things around. I guess I should have asked that before posting in the wish list.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Conversion into Ninox of old relational data
Glad things worked out. John's suggestion is good for a repeating task. I figured once you imported everything, you only needed to link them once and any future records would be linked manually or…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: All I want for Christmas!
I think it would be great to be able to use if statements to create variables and then use them in formulas later. for example: let t := this; if field1 = null then let var1 :…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Return to my Topic
Can you send me an updated test DB? You are showing a new table that I don't have.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Conversion into Ninox of old relational data
You can follow @Alain Fontaine advice in this forum.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to query a table using a dynamic combo box value?
Reading it again there is no mention if the dynamic choice field is a choice or multi-choice field. This current solution only works if it is a single choice field.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to query a table using a dynamic combo box value?
oops, I again didn't read the subject line. I guess your solution will work if the record Id from Assigned To matches the one from Staff. We don't know which table Assigned To pulls from.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Return to my Topic
I like that you now track the weeks in a separate table. I think that is a good idea. I'm not sure what you are doing with the select statements. Why are you specifying a specific record?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to query a table using a dynamic combo box value?
Hi there: May I suggest you try: let i := 'Assigned To'; first((select Staff where 'Full Name' = i).email) In Ninox you put the field you want at the end of the select.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Help with wedding base
Still learning new things everyday. I didn't even know you could import a CSV as a table. Try opening a table, then select the gear icon and then select Import data and here is where you match…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Formula for combine two Alerts Date's
let curRec := this; let xDate := cnt(select FERIADOS where Fecha = curRec.FechaR5); if xDate > 0 then let result := dialog("", " Esta Fecha es un Dia FERIADO.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Help with wedding base
While your new plan for a new DB will work, John offered to show you how to script the transfer of data between your current tables and a new consolidated table.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Help with wedding base
to not import a column just don’t drag it to match a field. You don’t need a field to match each column.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: add onselect event for view field
That is what I've been wanting to do myself. Now with v1.02 I can do it in my dashboard with many views. Works great! Love how people work off other people's ideas.
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Set auto completion on Ninox editor
looks like the hiccup went away.
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Set auto completion on Ninox editor
Anyone else having trouble loading Jacques' tools? My DBs take forever to load and when they do the formula field is blank.
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: add onselect event for view field
As always, Jacques, you are the best! v1.02 works perfectly. Even if there is another view element in front of the one with the onselect it still works.
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Formula diferent result
if you click on the refresh button (above the Id number in Table view) does it change?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: List keeps growing - no scrollbars?
You are welcome. That is very nice of you to say, but I think I'm just quick to respond that is all. There are way smarter people on this forum than me.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Help with wedding base
That is quite a list of tasks you want to accomplish. It is all doable within Ninox. If you are planning on doing it yourself, be patient as there is a learning curve when transitioning from a flat…
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 124 125 126 127 128 154

Welcome to the Ninox community

Fred

Re: Filter on hidden columns

Re: Related table field reference

Re: Help with wedding base

Re: Return to my Topic

Re: Return to my Topic

Re: All I want for Christmas!

Re: Conversion into Ninox of old relational data

Re: All I want for Christmas!

Re: Return to my Topic

Re: Conversion into Ninox of old relational data

Re: How to query a table using a dynamic combo box value?

Re: How to query a table using a dynamic combo box value?

Re: Return to my Topic

Re: How to query a table using a dynamic combo box value?

Re: Help with wedding base

Re: Formula for combine two Alerts Date's

Re: Help with wedding base

Re: Help with wedding base

Re: add onselect event for view field

Re: Set auto completion on Ninox editor

Re: Set auto completion on Ninox editor

Re: add onselect event for view field

Re: Formula diferent result

Re: List keeps growing - no scrollbars?

Re: Help with wedding base

Overview