Fred

San Francisco, USA

3421
539
4

Joined: Thu Feb 06 18:42:57 UTC 2020

My Posts

Latest Posts

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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 yrs ago
- Learn and share
- Reported - view
Re: Set auto completion on Ninox editor
looks like the hiccup went away.
- Fred
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 yrs ago
- Get help
- Reported - view
Re: List keeps growing - no scrollbars?
If this is a 1:N view created by Ninox then by default it will grow the list to 6 then start scrolling. If you only want to see, say, 3 then after you have 3 records you can modify the size to see 3…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: add onselect event for view field
Wow, you are correct. That is so weird. I wonder why?
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Accessing a single line item on an invoice
Can you post the code from the new table? Can you let us know the relationship between the new table and Payments?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: add onselect event for view field
Jacques, your DB worked fine. Just to verify that I'm using the MacOS app. I've attached my test DB. It is a mess so: 1) open the System table to load your modules 2) open Table1, select record 1,…
Attachment
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: add onselect event for view field
I can't seem to get it to work. I got the module loaded and I put this in the formula of my view: function onselect(selectedID : text) do Nr := first(select Table3 where Id = selectedID) end;…
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: add onselect event for view field
I hate to say this but you have to stop doing Ninox’s work for them. Unless they pay you.
- Fred
- 2 yrs ago
- 2
- Learn and share
- Reported - view
Re: How do i add up totals
@Edward at the top level click on import db and select the archive.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Dynamic Choice Field reference in a function
@Gianluca I think your reasoning for keyboard access to reference field is better.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: How do i add up totals
I've mocked up what it could look like. Take a look and let me know if you have any questions. The table monthYear is there so you can create the Month view.…
Attachment
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: It is posible on Ninox.
Most things are possible in Ninox. How is a record in Avances going to filter the Documentos table to get the correct data?
- Fred
- 2 yrs ago
- Get help
- Reported - view

1 108 109 110 111 112 137

Welcome to the Ninox community

Fred

My Posts

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

Re: List keeps growing - no scrollbars?

Re: add onselect event for view field

Re: Accessing a single line item on an invoice

Re: add onselect event for view field

Re: add onselect event for view field

Re: add onselect event for view field

Re: How do i add up totals

Re: Dynamic Choice Field reference in a function

Re: How do i add up totals

Re: It is posible on Ninox.

Overview