New result line in the console

How do I write a new result line in the console? This is the code I run let LastDate := last((select Notify) order by Data).Data; text(LastDate); while today() > LastDate do LastDate := LastDate +1;…

Normalising existing data

I've imported a spreadsheet to a table and now want to normalise it. In SQL I would have done a 'select distinct' on a given field to generate the list of values,…

Chang app logo

I am using the computer version of the program. But now there was a need to display the program logo on the desktop. How can I replace it and use my company logo? Regards

Formula to Include Multiple Filters from Choice Fields

Ok, I have been stumbling a few days over this trying to get the right formula. What I am doing is creating a sub table to give me the values I need, so then I can draw those into a chart correctly.…

• Answered

Script editor cannot validate script code

If I insert the script code to execute "a for loop" in my script, the script editor does not validate it and does not save it. if I remove that part everything works.…

erase, remove a date from a date field

Hi There In a date field, I put a future event date. In time, of course, it becomes a past event date... Using either a button (for a specific record) or a loop (for the entire table),…

Unlink Images from database to reduce the size

I have a database of my client session records which is now over 1 Gb in size mainly due to the images. Each session has multiple images of my handwritten notes.…

A link in a text message via button

Like all my posts, I know this is simple, but I can't make it work! Part one: I have a button I use to send a confirmation text to a client after contact.…

Linking to a record using the iCloud version

Hello! Is there a way to link to a record using the iCloud syncing? I tried to use the urlOf(this) function as described here: https://forum.ninox.com/t/m1hrtam .…