Sean

1763
79
0

Joined: Tue Jul 31 23:45:13 UTC 2018

Coding Dart/Flutter in my spare time

My Posts

Latest Posts

Re: Formula
No worries, I don't know how much time you get to try things out, but it's pretty satisfying when you figure something out. I'm at Scott's in Marysville, OH waiting to be loaded .…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Formula
Another question... Is there a common field that connects the Pick Up and Delivery information? Load # or Driver?
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Formula
I can't play with it and I don't have anything similar, but it looks like you will need to test for the number of records returned by the Pick Up Info table and the Delivery Info table.…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?
let myTable1 := Id;let myText := Text;for i in (select Table2)[Text = myText] doi.(Table1 := myTable1)end
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Formula
Is the first image a mockup? It would be helpful if you explained what your formula is. You can find some text manipulating functions here - https://ninoxdb.…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How can return a value with a own function?ä
You're welcome. I haven't considered assigning a group of values using the select statement to a variable like you tried with... let myAllApointment:= select('My Table of…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How to get the last two digits of the current year？
Change the quotes for YY. See how they are different than the quotes in Fabio’s example.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Find and replace
When you select the field you want to change in Update Multiple Records, select Assign calculated value and use this as the formula... replace(YourField, "Õ", "'")
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How can return a value with a own function?ä
https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language I’m not sure what you want to do, but here’s an example For r in select('My Table of apointements')['date'=today()] order…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How can return a value with a own function?ä
Like this... select('My Table of apointements')['date'=today()] order by time
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How can return a value with a own function?ä
As far as I know, Ninox does not support multidimensional arrays. There isn't any documentation that shows it does and all of my attempts to define one have been unsucessful.…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How can return a value with a own function?ä
Hi Robert, Yes, I would like to see it. I don’t have any experience with the new views at this point. Are you creating your own version? I’m not sure what you mean by sorting an array by a specific…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How can return a value with a own function?ä
I apologize! I just now took another look at your function, but this time it is on my computer and not my phone. I didn't realize those were comments until just now. I have a question.…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How can return a value with a own function?ä
May I ask how you know it works fine? It looks like you are building an HTML string by concatenation, but you aren’t concatenating everything. let myHeure := ""; if i % 2 = 0 thenmyHeure :…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How do you delete a database in the Android app?
Did you try swiping left or right? On the iPhone you swipe right to get a menu that has a delete option.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Scanner (barcode), compare between two Table(fields)
LOL. Mass, you’re welcome and I’m glad it’s working for you.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Scanner (barcode), compare between two Table(fields)
This should work... let serialchk := (select Serialnumbers)['Serial number' = code];if serialchk != "" then copytohere := codeend
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Scanner (barcode), compare between two Table(fields)
I see what you're saying. Does concat(Product.Serialnumbers.'Serial number') create a string with all of the Serial Numbers? Maybe another possibility would be...…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Scanner (barcode), compare between two Table(fields)
Instead of assigning the comparison to a variable and instead of using contains(), let the conditional statement handle the comparison... if code = serialnb then copytohere :…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Formula to view display an unlinked piece of information
@Mconneen.. I wasn't trying to disparage and it looks like you accomplished what S Moore wanted. There's usually more than one way to accomplish a computing task.…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Constrain to 'any' of a multi choice
This example is still using the View layout element... It uses a Multiple Choice field in Table1, selects the matching records in Table2 and displays the results in a View layout element.…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Constrain to 'any' of a multi choice
Are you using a View layout element to display the records or using the built-in filter on the column header? I can get this to work in a View layout element...…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: How to add View with other layout elements ?
It is a Table View that you can add to your form. If you put the View element on the Form View of Table1, for example, and entered... select Table2 in the formula it would display the records from…
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Formula to view display an unlinked piece of information
Beat me to it . I wish the Ninox Team would add upvoting.
- Sean
- 6 yrs ago
- Get help
- Reported - view
Re: Is there a way to create static / multi-dimensional arrays?
Or you could use parallel arrays.
- Sean
- 6 yrs ago
- Get help
- Reported - view

1 59 60 61 62 63 71

Welcome to the Ninox community

Sean

My Posts

Re: Formula

Re: Formula

Re: Formula

Re: Is it possible to link automatically (via a function) fields in two tables that contain the same text?

Re: Formula

Re: How can return a value with a own function?ä

Re: How to get the last two digits of the current year？

Re: Find and replace

Re: How can return a value with a own function?ä

Re: How can return a value with a own function?ä

Re: How can return a value with a own function?ä

Re: How can return a value with a own function?ä

Re: How can return a value with a own function?ä

Re: How can return a value with a own function?ä

Re: How do you delete a database in the Android app?

Re: Scanner (barcode), compare between two Table(fields)

Re: Scanner (barcode), compare between two Table(fields)

Re: Scanner (barcode), compare between two Table(fields)

Re: Scanner (barcode), compare between two Table(fields)

Re: Formula to view display an unlinked piece of information

Re: Constrain to 'any' of a multi choice

Re: Constrain to 'any' of a multi choice

Re: How to add View with other layout elements ?

Re: Formula to view display an unlinked piece of information

Re: Is there a way to create static / multi-dimensional arrays?

Overview