Sean

1762
79
0

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

Coding Dart/Flutter in my spare time

My Posts

Latest Posts

Re: Separate multiline text field into individual rows?
You can use the split() function which will return an array. Something like this... newArr := split(MultilineField, " ") Use the count() function to get the total array items and use the item()…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Dialog with text input
You're welcome to wait for a response from Ninox support, however, while you're waiting you might want to check out this thread...…
- Sean
- 4 yrs ago
- Learn and Share
- Reported - view
Re: How can I copy from a text field to a date field?
You just need to change the order of the formula then. The date() function takes 3 arguments in this order... Year, Month, Day. You can use the following for the "Assign calculated value" formula of…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: How can I copy from a text field to a date field?
The Date field will be in the format that is set in your OS if you are using the Mac app or your browser settings if you are using the browser version. @Mconneen's formula in this thread https:…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Ninox Update
Nick, I'm not sure. I haven't signed up for the new "Live Stream Webinar". The email I got said the, "webinar will proceed at the usual time" so I guess it will be the one in English.
- Sean
- 4 yrs ago
- Learn and Share
- Reported - view
Re: Search Files by text in filename or for records that have files attached
Well, I forgot to tokenize the second example, but you get the idea ;)
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Search Files by text in filename or for records that have files attached
concat(files(this)) is the function combination you would use to get the attachment names for the current record. You can use this code in a Formula field to search for attachments that match a…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: create an array with a multiple values
if you use then select statement, you don't need to use the for-loop. Otherwise, the approach Robert posted would be the one I would use. One more point,…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Try to print a view using the code example from nioxus 600.08 with my own filter. Code shown here returns nothing. Any help is appreciated.
At a glance this is what I see... Date => xBeg and Date =< xEnd should be... Date >= xBeg and Date <= xEnd
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Find Function to search hidden columns
I don't think that is possible with the built-in Find function. I would add a Tab to the Form view and create a search page using a Text field and a View layout element.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: VLOOKUP formula between 2 tables
Hi David, The following should work and, according to your description, would go into the Formula field in SensoPro... (select Fournisseur where IDSAP = IDFOURN).IDGESTPRO if not, try this...…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: how to get a local database online
I think it would be easier to save the database locally using "Save archive as..." and then import it to the Ninox cloud.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: VLOOKUP formula between 2 tables
This works... (select Table1 where 'EAN Code' = 'EAN Code').'Product Name'
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Would like to link a record in my table to other records in the same table
I don't have a lot of time to work on this, but I did come up with something that works for a single table. You'll need to come up with something more unique than just a first name to filter the…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Would like to link a record in my table to other records in the same table
I am actually more comfortable and have more experience with coding. I haven't done much with many-to-many databases. I'll try to work something up when I can or someone else with more experience can…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Would like to link a record in my table to other records in the same table
It might be possible to do that with a single table, but would require some coding to do it. As long as the information you enter in Peter's record is unique enough to be able to filter out Paul's…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Would like to link a record in my table to other records in the same table
Usually, you link records from one table to record(s) in another table. Is that what you want to do?
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: must you buy a subscription
Even though the Ninox Apps, not including the browser version, are stand alone apps, there is a subscription fee if you use the Ninox Cloud service. Do you need the Ninox Cloud service?
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: How do I include a date field in a file name using "importFile" command?
Did your original date have slashes instead of dashes? That will definitely cause a problem
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: How do I include a date field in a file name using "importFile" command?
Hi Jeremy, There are only 2 possible solutions I can think of at the moment. One is to build the entire string and assign it to a variable and then use the variable in the importFile() function,…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Links allow multiple choices
I think you want a many to many relationship. Please search on "many to many" and use the quotes in the search box.
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Command for Read Only
I'm fairly confident that can only be done at design time or if you are using the browser version through the user functions like... userHasRole(string) userRole(user) https://ninox.…
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: How do I include a date field in a file name using "importFile" command?
Try text('Order Date')
- Sean
- 4 yrs ago
- Get help
- Reported - view
Re: Filter not working for Formula
Kevin, no problem. One option would be to create a Number field and use a Button or the Console to assign the values to the Number field. Here's the code I used... for i in select YourTable doi.…
- Sean
- 4 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?
@Ben, I didn't have a problem creating a Reference from the "child" or "many" table. I did find that if I created the Reference from the "parent" or "one" table it would reverse the (1 :…
- Sean
- 4 yrs ago
- Get help
- Reported - view

1 33 34 35 36 37 71

Welcome to the Ninox community

Sean

My Posts

Re: Separate multiline text field into individual rows?

Re: Dialog with text input

Re: How can I copy from a text field to a date field?

Re: How can I copy from a text field to a date field?

Re: Ninox Update

Re: Search Files by text in filename or for records that have files attached

Re: Search Files by text in filename or for records that have files attached

Re: create an array with a multiple values

Re: Try to print a view using the code example from nioxus 600.08 with my own filter. Code shown here returns nothing. Any help is appreciated.

Re: Find Function to search hidden columns

Re: VLOOKUP formula between 2 tables

Re: how to get a local database online

Re: VLOOKUP formula between 2 tables

Re: Would like to link a record in my table to other records in the same table

Re: Would like to link a record in my table to other records in the same table

Re: Would like to link a record in my table to other records in the same table

Re: Would like to link a record in my table to other records in the same table

Re: must you buy a subscription

Re: How do I include a date field in a file name using "importFile" command?

Re: How do I include a date field in a file name using "importFile" command?

Re: Links allow multiple choices

Re: Command for Read Only

Re: How do I include a date field in a file name using "importFile" command?

Re: Filter not working for Formula

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

Overview