Date suddenly wrong

Dear all, One of our users is suddenly seeing all the dates logged in the database backdated of one day. For example we have a date of 31/12/2021, he sees 30/12/2021.…

New record code needing a tweak

closeRecord(); let thisRecord := this; let myProject := 'SELECT PROJECT'; let myLoc := 'SELECT BUILDING, ROOM & DESCRIPTION'; let newRec := (create 'Project Equipment'); newRec.…

Dimensione del modulo

Ciao a tutti, ho bisogno di un aiuto per aprire un modulo con le dimensioni da me scelte. Vorrei aprire il modulo al centro della pagina. Grazie per un eventuale aiuto

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),…