Fred

San Francisco, USA

3400
539
4

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

My Posts

Latest Posts

Re: 2 multiple choice creat records ?
It was quite an interesting task to figure out. You can put the following in a button to test it out: "takes the selections from the multiple choice fields and creates a string for each combination…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Variables
If Meetings is a reference field to the Meetings table and Quando is the name of the appointment field then you can try: let currentMeeting := last(Meetings order by Quando) if days('Data Ultima…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to write code to batch update data in two or more child tables?
@我是我的我 said: I saw the "loop1" command, Just to be clear it is a for loop command. "loop1" is just a variable name used in the for loop. "loop1" can be anything.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: How to write code to batch update data in two or more child tables?
Let us troubleshoot your original code as it can help in the future. You wrote in 程式 : let aa := table2; (select table3 where '数据表2' = aa).[number('选项')] This doesn't work since table3 is in a N:…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: How to write code to batch update data in two or more child tables?
Looking at your DB, first let us take a look at 程式. You can remove the select statement because you are only looking at related records. This makes the code much faster as your dataset grows up.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: double entries
If you are on public cloud or 3.10 of private cloud, you may want to consider creating Pages that users do all of their work in instead of letting them access to the raw data.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Split Function Help
@Rafael Text is just a simple text field that has the list of country names, for me. It will vary in your DB. Can you post a sample of your DB?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Split Function Help
@Rafael said: you can share this example. need to know what happend, everything's look fine This is what I have: let list := ( let x := split(Text, ","); for item in x do let i :…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Get the hours from an appointment as an Array
Interestingly, you can't get time data very easily in Ninox. You can get the start()/end()/duration() of an appointment field. Even with time fields, there is no command like month or day that will…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Split Function Help
@Rafael I don't think it is the code. I would check to make sure each data point has data and is in the correct format. What kind of field is Name? How does data get into the field?…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Control panel data check
For a dashboard/page to work as data entry you need to have a button. In the code for the button you will put in checks to see if records or other data already exist.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Split Function Help
@Rafael If you are talking about the one I post with two fields, then yes. it works for me. When I add <br> it works too.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Double action button
In Ninox you use the semi-colon to separate commands: 'Fin de contrat' := 'Date Renouvellement'; 'Statut Bouton' := null
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Open Record based on UserName
@John Wilmans if you have any questions please start a new post.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Open Record based on UserName
May I suggest that you use your dashboard (or new pages) to show the data that you want to show, instead of pulling up the record and exposing your raw data to your end users.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: About code Questions
The problem is you put the old for loop inside another for loop and now Ninox takes the record you create and in the field 物流码 it copies each instance in the array "s" until it reaches the end so you…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Two Serious Problems... Required Fields & Trigger on new record/update
@John Wilmans said: Do you know of anywhere that I can learn about how to do this better please? Do a search for Ninox Dashboards on the web and there are video links from Ninox and Nioxius.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Split Function Help
@Rafael <br> is fine.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Split Function Help
@Rafael said: Yes works, but how can I do for include more fields Going off of my example this is how my code changes: let list := ( let x := split(Text, ","); for item in x do let i :…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: About batch write Questions
@我是我的我 said: I just didn't know how to use the "item" function. Just to make things clear, what francesco wrote is a for loop command. for [loop variable] in [array] do end So what you referred to as…
- Fred
- 1 yr ago
- 2
- Get help
- Reported - view
Re: About batch write Questions
Is the data in 1 just text separated by a paragraph mark? Is the table in 1 related to the parent table or child table in 2? 1 中的数据只是由段落标记分隔的文本吗？ 1中的表与2中的父表或子表相关吗？ Hope the translation is ok. :)
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Single Dynamic field that populates other fields
@Mel Charles said: I just need to monitor the performance on this lookup tho... verses have a sub table to select the contact! You made a good start by using the reference field to create the dynamic…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Single Dynamic field that populates other fields
@Mel Charles said: The first one goes in and is accepted but it returns an email that is not associated with the customer contact Yes, well I was wrong about the root of EContact.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Single Dynamic field that populates other fields
Have you considered using the record() command? I don't know if EContact pulls from the Customer table (it looks like it does), but if it does you already have the appropriate recordId.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Need Script for calculating workdays between 1st record, 2nd record, so on.
@Dave Irving said: Here is the script for that "Days Since Last Contact" field. I replaced 0 with null, but that broke it. So if you want xCurIndex to be null then you have to think the opposite.…
- Fred
- 1 yr ago
- Get help
- Reported - view

1 51 52 53 54 55 136

Welcome to the Ninox community

Fred

My Posts

Re: 2 multiple choice creat records ?

Re: Variables

Re: How to write code to batch update data in two or more child tables?

Re: How to write code to batch update data in two or more child tables?

Re: How to write code to batch update data in two or more child tables?

Re: double entries

Re: Split Function Help

Re: Split Function Help

Re: Get the hours from an appointment as an Array

Re: Split Function Help

Re: Control panel data check

Re: Split Function Help

Re: Double action button

Re: Open Record based on UserName

Re: Open Record based on UserName

Re: About code Questions

Re: Two Serious Problems... Required Fields & Trigger on new record/update

Re: Split Function Help

Re: Split Function Help

Re: About batch write Questions

Re: About batch write Questions

Re: Single Dynamic field that populates other fields

Re: Single Dynamic field that populates other fields

Re: Single Dynamic field that populates other fields

Re: Need Script for calculating workdays between 1st record, 2nd record, so on.

Overview