Sean

1760
79
0

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

Coding Dart/Flutter in my spare time

My Posts

Latest Posts

Re: Styled formula background
https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/styled-5d4d2eb4f766c72ea3c980b3 There are many other examples on the forum as well.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Formulation Issue
Are you sure that there is only one record being returned by 'Apps Project'.'Project Variables'? You could put that in a formula field by itself to see what it is returning.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to use rpad() and lpad()
Also, note the difference in quotation marks. You must use "" instead of ""
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: How to use rpad() and lpad()
lpad() and rpad() are not trimming functions, they are padding functions. I tried rpad() like you show in your example with "Yu" and it worked fine. I did use 4 instead of 3 though.…
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: automatic order
What you want to do is similar to this thread... https://ninoxdb.de/en/forum/technical-help-5ab8fe445fe2b42b7dd39ee7/renumbering-subtable-records-5d52bce44e061c58ea3a25c5 There currently isn't a…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How do I show information from another table, based on user input?
You can use... record(YourTable, YourId).(YourField := YourValue) ...to assign a value to a field in another table.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Renumbering Subtable Records
William, Sorry about the scare and I'm glad you got it working. :)
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Renumbering Subtable Records
I realized it wouldn't make sense to order by 'T#' because T1, T10, etc would come before T2. So you could use something like this... let tNum := 1;for r in (select 'Trial Summary') order by…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Renumbering Subtable Records
I don't think you need to use an array. Is 'Trial Summary' orderd by the 'T#' or some other field?
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Something strange with U.S. Locations
@Mconneen, Looks like you found a twofer. If you are concerned about the extra space being inconsistent, you can test for it with substr(), but I'll bet it's consistent.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Linking Tables/Records
@Westy, You’re welcome
- Sean
- 5 yrs ago
- Learn and Share
- Reported - view
Re: How to update a view automaticcaly ?
@BugTrapper, I guess I must be special because it works for me. FYI, I rarely post a comment without testing first.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to update a view automaticcaly ?
If, you are using a formula in the View layout element similar to this... select YourTable where YourDateField = today() the View should automatically update. How are you manually updating the View?
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to update a view automaticcaly ?
Are you referring to the main Table view or the View layout element?
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: left pad How to use
What are you using for the padding character? If you are trying to use <Space>, you have to use <option+Space>.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Error when use a declaired variable.
I would declare TempDate before the first if-statement and set it's value to a default date value.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to accumulate percentages for multiple choices
Something like this? count(chosen(YourMCField)) / 6 * 100
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Summing record
You can use something like this in a Trigger or a Button... let tId := number(this.Id);let tA := this.A;B := last((select YourTableName where number(Id) < tId).…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Value of choice field
text('Choice Field Name')
- Sean
- 5 yrs ago
- 1
- Get help
- Reported - view
Re: Reading JSON list
@Mconneen, It’s been a while, but yes, I believe that’s what I was referring to.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: multiple choice equal to twice the same value!
@Mconneen, are you being facetious about missing a function that isn't there? ;). That one is missing as well as %.
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: multiple choice equal to twice the same value!
@Mconneen, chosen(MC) returns the values of the chosen items. numbers(MC) returns the numbers of the chosen items. Note, the function is plural and the index starts at 1 not 0.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: can I set and use global variables ?
I haven't tried this, but if you add a User field to the GV table and you gave each user their own record in the GV table you could use the select statement to get the value you want.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: Formula not working - number doesn't increase?
Per the documentation... https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language substring(string, start, end) – Extracts a part of the string. Start and end are zero-based.…
- Sean
- 5 yrs ago
- Get help
- Reported - view
Re: How to pass field name to a function that returns field value?
@Westy, I got really frustrated with some of the language limitations of Ninox a while back and did some research on designing a programming language. That tamped down my frustration a bit.…
- Sean
- 5 yrs ago
- Get help
- Reported - view

1 47 48 49 50 51 71

Welcome to the Ninox community

Sean

My Posts

Re: Styled formula background

Re: Formulation Issue

Re: How to use rpad() and lpad()

Re: How to use rpad() and lpad()

Re: automatic order

Re: How do I show information from another table, based on user input?

Re: Renumbering Subtable Records

Re: Renumbering Subtable Records

Re: Renumbering Subtable Records

Re: Something strange with U.S. Locations

Re: Linking Tables/Records

Re: How to update a view automaticcaly ?

Re: How to update a view automaticcaly ?

Re: How to update a view automaticcaly ?

Re: left pad How to use

Re: Error when use a declaired variable.

Re: How to accumulate percentages for multiple choices

Re: Summing record

Re: Value of choice field

Re: Reading JSON list

Re: multiple choice equal to twice the same value!

Re: multiple choice equal to twice the same value!

Re: can I set and use global variables ?

Re: Formula not working - number doesn't increase?

Re: How to pass field name to a function that returns field value?

Overview