Fred's Profile | Ninox community

Badges

Latest Posts

Re: Can I control the order in which Ninox displays my tables?
@Dave Airel Seems like you have to do it the way you described if you don't want to script the csv import. Have you asked your provider if you can connect through API and get the data that way?
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: New Ninox 3.17
exciting! one more step towards modularity for public cloud.
- Fred
- 9 mths ago
- 1
- Learn and share
- Reported - view
Re: Excel scripting with carbone
Thanks for the DB. It helps to see the field names. Here is what works for me. Since we can't have accented characters I created a simple JSON formula: { nav: Navire, Options:…
Attachment
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: But now need not place weekends
Try something like: if 'Plan Start' != null and 'Date Rev 0' != null then let dates := 'Date Rev 0' - 'Plan Start'; let 'step' := dates / 4; 'Date Rev Int' :…
- Fred
- 9 mths ago
- 1
- Get help
- Reported - view
Re: Excel scripting with carbone
@frsalabert The DB is empty of data. Can you provide some test data?
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: New Ninox 3.17
i really like the improved communication
- Fred
- 9 mths ago
- Learn and share
- Reported - view
Re: Excel scripting with carbone
@frsalabert I just noticed that the names in your Carbone code does not match the tables names in your picture. Unless you renamed the reference fields from upper case to lower case.…
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Excel scripting with carbone
So I created your basic structure: Is Options supposed to be a M:M (many to many) connection between OFFRES and NAVIRES? If so then you don't need the direct connection between OFFRES and NAVIRES,…
Attachments
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Fields for Form use, not needed in "record"
@Graham Brown Why not use a Page so you don’t have to worry about that? Or create the form view then delete the table view so users only see the form view.
- Fred
- 9 mths ago
- 1
- Get help
- Reported - view
Re: Can I control the order in which Ninox displays my tables?
Question: What is the purpose of these lines? allContacts := array(allContacts, [newContact.Id]); or allEvents := array(allEvents, [newEvent.Id]); You don't use them anywhere else?…
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Can I control the order in which Ninox displays my tables?
@Dave Airel said: It does process the Attendance_Staging table, but only the last record is saved. I tested it out with just the contacts part and it created the two records (Lynn and Jeff) that are…
- Fred
- 9 mths ago
- 1
- Get help
- Reported - view
Re: Can I control the order in which Ninox displays my tables?
Have you tried @Jacques TUR ChatGPT? It is better than the general version, but still not perfect.
- Fred
- 9 mths ago
- 1
- Get help
- Reported - view
Re: Need a formula between week to place on (%Semana Plan)
maybe something like: let t := this; let prevRec := (select TalbeName where Week = (t.Week-1)); 'Progress Plan' - prevRec.'Progress Plan'
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Excel scripting with carbone
In Carbone you place the repetition code at the level where you need to repeat. So the first column code would look like: {d.Offres.Options[i].Quantité} {d.Offres.Options[i+1].…
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Excel scripting with carbone
@frsalabert said: I would like to collect in an excel file the complet list of my different Navire.Options Just to clarify that Ninox can only output into PDF through dynamic printing.…
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Can I control the order in which Ninox displays my tables?
@Dave Airel Can you copy your DB and remove all personal data and put in fake data?
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Fields for Form use, not needed in "record"
@Graham Brown said: So my question is, how do I reduce record size when creating non-essential fields on the one and only form per table? A couple of extra fields are not really going to "explode"…
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Can I control the order in which Ninox displays my tables?
@Dave Airel That looks great! You are on your way. I know it seems like too much extra work, but you will soon find that going into the tables directly to be too much trouble and wished you had…
- Fred
- 9 mths ago
- 1
- Get help
- Reported - view
Re: Problem in my DB WorkOrder
@Rafael Also start your scripts just doing the basics, make a new record and then link to proper records. Once all that works then you can add in the field updates.
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Can I control the order in which Ninox displays my tables?
@Dave Airel You probably have all the knowledge already to setup your dashboards. If you uses Pages then all you need is to create the fields that make up the UI. No special training needed.
- Fred
- 9 mths ago
- 1
- Get help
- Reported - view
Re: Can I control the order in which Ninox displays my tables?
@Dave Airel it took me awhile to understand the advantages of dashboards. I’m the only user but even for me I’m finding them helpful. Plus I don’t trust myself. 🤣
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Can I control the order in which Ninox displays my tables?
@Dave Airel off the top of my head, dashboards/pages can: 1) data validation before you write the data to a record 2) you make an easy UI for your users 3) simpler data access protection,…
- Fred
- 9 mths ago
- 1
- Get help
- Reported - view
Re: [Bug] Formula "image" field not showing content in Cards view
I'm on public cloud so I don't have modularity, yet. Maybe by fall, public cloud will have modularity.
- Fred
- 9 mths ago
- 1
- Get help
- Reported - view
Re: Problem in my DB WorkOrder
Have you considered making Progress Reports a child of Cutoff Days? Since you want to make a report for each record in Cutoff days. So you only need to link the progress report record to a Cutoff…
- Fred
- 9 mths ago
- Get help
- Reported - view
Re: Problem in my DB WorkOrder
@Rafael Always try to minimize your use of selects. So your for loop on line 6 can use the reference field 'CutOff days' instead of the select. I'm not sure why you use the select on line 5 as well.…
- Fred
- 9 mths ago
- Get help
- Reported - view

1 9 10 11 12 13 156

Welcome to the Ninox community

Fred

Re: Can I control the order in which Ninox displays my tables?

Re: New Ninox 3.17

Re: Excel scripting with carbone

Re: But now need not place weekends

Re: Excel scripting with carbone

Re: New Ninox 3.17

Re: Excel scripting with carbone

Re: Excel scripting with carbone

Re: Fields for Form use, not needed in "record"

Re: Can I control the order in which Ninox displays my tables?

Re: Can I control the order in which Ninox displays my tables?

Re: Can I control the order in which Ninox displays my tables?

Re: Need a formula between week to place on (%Semana Plan)

Re: Excel scripting with carbone

Re: Excel scripting with carbone

Re: Can I control the order in which Ninox displays my tables?

Re: Fields for Form use, not needed in "record"

Re: Can I control the order in which Ninox displays my tables?

Re: Problem in my DB WorkOrder

Re: Can I control the order in which Ninox displays my tables?

Re: Can I control the order in which Ninox displays my tables?

Re: Can I control the order in which Ninox displays my tables?

Re: [Bug] Formula "image" field not showing content in Cards view

Re: Problem in my DB WorkOrder

Re: Problem in my DB WorkOrder

Overview