Scripting and Functions

Click to url on emailed image within sendEmail

I am send out an email to all my customers on job completion via sendEmail. The button has the following script the in the email body a Google review image is displayed. from (xGoogle) field.…

Sort and display all times in order.

Hello everyone! In my table, I’ve set up two time fields (as shown in the image). I’m wondering if I can create a code snippet in the ‘View’ table to display all the entries of time1 and time2 in…

• Answered

How to configure a time API?

How can I set up the following time API so that clicking a button updates the “Date” field? https://f.m.suning.com/api/ct.do

userFirstName() possible bug?

I get nothing with a formula using this: On Can anyone confirm?

Dialog not working.

In the 'Trigger on new record' I have the following let title := "Serial and/or Bundle Required"; let message := "Does this new record need it's Serial Number logged? If so is it part of a Kit/Bundle?…

Passing Dropdown Value to Another Page

Hi everyone, I'm trying to pass the value selected in a dropdown on my Dashboard page to a dropdown on my Job Setup page. Here's the setup: Dashboard Page:…

• Answered

Update a field and jump in a record.

I have a JavaScript function used to do a update of a field and jump in a record. --- function myClickTitleIntervention(id, url, valeurClick) { "{" } console.log("Start"); var myElement = database.…

Calculate Cumulative Time with Code

Hello everyone, I need a piece of code to calculate the continuous days of placing orders for sales (using weeks as the time interval). For example, today is Friday,…

• Answered

Formula returning a record causes type mismatch

I have a formula that returns a record. This formula works fine. But whenever I try to use the returned record in a then or else branch, I get a type mismatch. The formula field is OrderItems.…

calculate stock

Hi all I have a table "Fakturalinier Materialer" (Invoice lines articles) from which I want to control my stock. Therefore I made this calculation for a start, for later to set the stock value,…

• Answered

Regarding issues with editing the chart code

Hello everyone! Through studying the dashboard template Dashboard Template shared by Sotirios Zormpas, I have learned chart code. The following code already implements the display of accumulated data…

goto another record from calendar

Hi there, have anybody ever tried to jump to a record from calendar where the record I not the one which created the calendar event. I have this situation that I am in a table where I create a…

How to write code for data filtering?

How can we filter out the top three salespeople with code? Xiao Ru $382.00 Jiang Ningwei $648.00 Xiao Ru $1,704.00 Jiang Ningwei $2,883.00 Xiao Li $11,760.00 Yang Daibing $4,640.00 Li Yanping $980.…

• Answered

JSON and for loops

Hi all - I was reviewing the set() command and noticed this: for i in response do let new := (create Contacts); for key, value in i.fields do set(new, key, value) end end Look at line 3,…

Copy record Id failing

I have the following script on a button. Everything copies over except the record Id. Any ideas on why? The target newInventory.(PurchaseItem := me.Id);, is a number. No errors are apparent.…

• Answered

Connect 2 entries

Hello. I have this code in the table Solicituds in a button: let dniActual := DNI; let personaEncontrada := (select Personas where DNI = dniActual); if count(personaEncontrada) > 0 then alert("El DNI…

• Answered

Trigger after update not triggered when updating by copy&paste

I have a table with code for trigger after update (for the table, not a field). When I edit an existing record by typing in a field, the trigger gets called as expected.…