Search found 67 matches

by administrator
Thu Feb 08, 2024 10:54 am
Forum: Scripts
Topic: add days to date
Replies: 0
Views: 127

add days to date

To set a date from today like: Today = 08-02-2024 but you need 14 days from now, you can use this OL-Script: // Get current date var date = new Date(); // Add 14 days to current date, change to number of days needed. date.setDate(date.getDate() + 14); // Function to format the date as "dd month...
by administrator
Thu Feb 08, 2024 10:41 am
Forum: Scripts
Topic: Date Today
Replies: 0
Views: 83

Date Today

To get the date of today, you can create a standard script in Ol-Connect Designer. Copy and paste the script below: var date = new Date(); // Get the day, month, and year var day = ("0" + date.getDate()).slice(-2); // Add leading zero if needed var month = ("0" + (date.getMonth()...
by administrator
Wed Feb 07, 2024 12:48 pm
Forum: Scripts
Topic: Set Up Vcard in QR
Replies: 0
Views: 86

Set Up Vcard in QR

Please find below the download link for a OL-Script that can be used in the QR.
Make sure the correct fields are set for the VCARD.
by administrator
Tue Jan 30, 2024 12:03 pm
Forum: Scripts
Topic: Handle Image from JSON
Replies: 0
Views: 29

Handle Image from JSON

var Products = record.fields.Foto; // Check if the 'Products' field contains PNG base64 data if (Products.indexOf("data:image/png;base64,") !== -1) { // Remove the PNG base64 prefix Products = Products.replace("data:image/png;base64,", ""); } // Check if the 'Products' ...
by administrator
Tue Jan 30, 2024 12:00 pm
Forum: Scripts
Topic: Normalize (Dutch) Postalcode
Replies: 0
Views: 30

Normalize (Dutch) Postalcode

var field, result = ""; field = record.fields.StreetAddress; if (field !== "") result += field + " <br>"; field = record.fields.ZipCode; if (field !== "") { // Assuming 'field' is a string of 6 characters (4 numbers and 2 letters) var formattedZipCode = field....
by administrator
Tue Jan 30, 2024 11:02 am
Forum: Scripts
Topic: Format Date
Replies: 0
Views: 30

Format Date

To format a date from "1/17/2024" to "17-01-2024" in JavaScript, you can use the following script: // Assuming your data field is named 'Datum' var datum = Field("Datum"); // Check if the 'Datum' field is not empty if (datum) { // Split the date into parts var dateParts...
by administrator
Tue Jan 30, 2024 9:47 am
Forum: Power Apps
Topic: Show Button if value is blank
Replies: 0
Views: 53

Show Button if value is blank

Example: I want to use a collection called MySuppliers and based on the record a button must be visible. First, make sure you have a collection in your app that contains the "supplier" field. If you don't have one yet, you can create it by using the ClearCollect function or any other appro...
by administrator
Tue Nov 21, 2023 4:50 pm
Forum: Windows
Topic: RemoteApplication
Replies: 0
Views: 72

RemoteApplication

It is possible to have a remote connection to just an application on a remote server. So a user does not need to have a remote desktop session to a server. To make this possible take these steps: We need to allow any unlisted programs to start from RDP. Save the script below on your desktop, the ext...
by administrator
Wed Aug 23, 2023 3:13 pm
Forum: Power Apps
Topic: Delete record from Sharepoint List
Replies: 0
Views: 69

Delete record from Sharepoint List

Create a button.
OnSelect:

Code: Select all

RemoveIf(datasource, Id = gallery.selected.Id)

Also add:

Code: Select all

Refresh(datasource)
after that to force your gallery to update if it doesnt automatically.
by administrator
Wed Aug 23, 2023 3:11 pm
Forum: Power Apps
Topic: View form does not show selected record
Replies: 0
Views: 64

View form does not show selected record

Please try with this alternative workaround.

Set OnSelect of your Gallery:

Code: Select all

Set(SelectedItemID, ThisItem.ID)
Set Form1.Item property:

Code: Select all

LookUp('Opportunities and Risk',ID=SelectedItemID)
The lookup function is to retrieve the record from data source, I believe this will resolve the error.