Fred

San Francisco, USA

3683
590
5

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

My Posts

Latest Posts

Re: Different views on on page
Are you talking about a form view of a table? Like (all), Another, and Form? Or a tab of a view form? Like Dashboard, Field Check, XLSX?
- Fred
- 3 wk ago
- Get help
- Reported - view
Re: Excel scripting with carbone
I also realized that you can skip the for loop if you are using an array of record IDs. You can rewrite the code to: { nav: Navire, Options: Offres.Options.{ name: Options.…
- Fred
- 3 wk ago
- Get help
- Reported - view
Re: Who can help me with this or a partner?
Is this a dynamic print question?
- Fred
- 4 wk ago
- Get help
- Reported - view
Re: custom .csv export
In Ninox if you want to insert a carriage return then you can easily just put a carriage return inside " ". "// Export contacts where 'Receives Emails?' = Yes;"; let contacts :…
- Fred
- 4 wk ago
- Get help
- Reported - view
Re: Sort selection of related records
oops, assuming that you don't have a date field in invoiceitems, you want to sort by Invoice.Date: let xSelRgPo := (InvoiceItems order by Invoice.Date) Since Invoice is the 1 side,…
- Fred
- 4 wk ago
- Learn and share
- Reported - view
Re: Clear relationship field on click
Looks like: signature := null works to clear out a signature field. To clear a reference field try: referencefield := 0
- Fred
- 4 wk ago
- Get help
- Reported - view
Re: Sort selection of related records
try: let xSelRgPo := (this.InvoiceItems order by Date) If Date is the name of the fieldname. Otherwise change it match.
- Fred
- 4 wk ago
- Learn and share
- Reported - view
Re: New Ninox 3.17
I really like Modularity 2.0. Good changes. I see in the future that we will be creating an interface/UI DB for your end users and DBs strictly for data then creating the interface module for each…
- Fred
- 1 mth ago
- Learn and share
- Reported - view
Re: Excel scripting with carbone
@frsalabert said: Options Famille, but it just show me the ID of the selection Since Famille is a simple choice field, you can wrap it with text() and it will show the text of the choice.…
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: New Ninox 3.17
@Sotirios Zormpas I did not know there was one today. It should be up in a couple of days.
- Fred
- 1 mth ago
- 1
- Learn and share
- Reported - view
Re: New Ninox 3.17
@Sotirios Zormpas They don't usually do video updates for 0.0x updates.
- Fred
- 1 mth ago
- Learn and share
- Reported - view
Re: Excel scripting with carbone
You can try: { nav: Navire, Options: for i in Offres.Options do { name: i.Options.Designation, qnty: i.Quantite } } Offres is single reference field, but Options is multireference field.…
- Fred
- 1 mth ago
- Get help
- Reported - view
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
- 1 mth ago
- Get help
- Reported - view
Re: New Ninox 3.17
exciting! one more step towards modularity for public cloud.
- Fred
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth ago
- Get help
- Reported - view
Re: New Ninox 3.17
i really like the improved communication
- Fred
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth 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
- 1 mth ago
- Get help
- Reported - view

1 2 3 4 5 148

Welcome to the Ninox community

Fred

My Posts

Re: Different views on on page

Re: Excel scripting with carbone

Re: Who can help me with this or a partner?

Re: custom .csv export

Re: Sort selection of related records

Re: Clear relationship field on click

Re: Sort selection of related records

Re: New Ninox 3.17

Re: Excel scripting with carbone

Re: New Ninox 3.17

Re: New Ninox 3.17

Re: Excel scripting with carbone

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)

Overview