Is it possible to have a filter expression for character count?

Hi there, Is it possible to have a filter expression for character count? In my database I want to filter the view of a colum with "marketing manager" and limit the search to not include results with…

Formatting printing of forms

I am attempting to create a field on a printed form where the field shows up depending on another field, but I can't find an appropriate formula. Can anyone advise? IE: if field A is 1,…

Recors counting

Hi to all! is thare a method to automatically update a field of a record of TABLE A with the numbers of record (only te count) that are populating the TABLE B?

Mehere Datensätze aus eine Tabelle Kopieren

Hallo, ich habe eine Liste (Aktivierungsliste) aus dieser muss ich zum Abgleich einmal im Monat alles Daten letzten Monats in eine andere Tabelle kopieren.…

how do i achieve nested grouping?

my database is one of perfumes. there are 800+ and counting, made by 200+ brands. i have a calculated field that displays the first letter of each brand name.…

A partial search with the same word

Hi Is there a way to do a partial search in the filter box? I’d like to display only the word "jay" Ex in a base I have the birds : -Blue jay -Mocking jay -Steller jay -Oak jay… How to find only…

script that removes the letter "s" at the end of a list of words

Hi Is it possible to have a script that removes the letter "s" at the end of a list of words in a column or adds it ? Thank you

truncating a table

how does one delete all records from a table at once?

Numeric X axis

Hi I want to chart invoice amounts against time across the course of five years. I have a table with project | value | DecimalYear where DecimalYear is months converted to base 10 and expressed as a…

OpenRecord not popupRecord

Is there a scrip to open record instead of popupRecord, l replaced the popup with openRecocord and it didn't work popupRecord(record(CUSTOMER,CUSTOMER.Id)) any suggestions appreciated 'Michael

Creata a Button that move table and sub-tables

Hi everyone,I need HEPL to know how to create a button to move a customer from the "opportunità" table to the "prenotazioni" table (which is the exact copy as structure) In the "Opportunity" table I…

Problem with multi-line rich text fields

I'm experiencing a problem when importing data from a csv file into a rich field. The import process combines all lines in a field into one line. The same thing happens if using Update Multiple…

Best incremental Invoice formula

Looking for the best Invoice incremental script. I have been using the Trigger on Create let c:=cnt(select 'Invoices'); 'Invoice Number':= "INV-" + format (c,"0000"); New Script; New Script;…

I would like to use my Id number in the table can i?

automatic time/date triggers. how to change the value of a field automatically when it passes a certain date or time?

if Date > todat() then choice := 2; end

Selecting Multiple Records In A Reference Field

I'm willing to say...I need help. I am trying to create a database to track donations made for a post-graduation party we hold each year. The Microsoft Access file (created by someone else) no longer…

One Other Question....

Interested in getting feed back on this situation. I have Invoices that require lots of detailed information and I have invoives that require one line. The invoiced items are not linked back to a…

extracto bancario

Hola amigos No se como hacer en Ninox una tabla con los siguientes campos FECHA - CUENTA - CONCEPTO - DEBE - HABER - SALDO El saldo es mi problemas, imagino que será algo sencillo,…

Cant place image galery in right position

https://gyazo.com/1fbed0d569602ef1d9a621cb369cdfd1 I want it on the right side (and all switch boxes on left) how?

Problems with conditional style

Problems with conditional style I use the conditional style with a ruler in a column and I noticed that after a number of searches, apparently it doesn't work anymore.…

email send Button mit If Anweisungen in der email

Liebes Forum, ich möchte gerne mit einem Button automatisierte Emails versenden. Das Problem ist, dass ich bei der Anrede, if Anweisungen verwenden möchte.…

Search for a name in several fields

Hi Could someone tell me way to search for words in multiple fields (multiple columns) Example : in a database I have the same name "John Miles" which is in column 2, 4, 6, 8,…

Show records from a table for 1 week period?

I apologise if something like this has already been asked and answered. I have a table 'Appointments' in which i have a date/time field to create a new appointment.…

Help with syncing issue.

Hi, l have 3 team members with me being the owner making 4 in total. 3 out of the four are syncing to the cloud and are working correctly although one is formatting dates differently to the others at…