Search found 67 matches
- Thu Feb 08, 2024 10:54 am
- Forum: Scripts
- Topic: add days to date
- Replies: 0
- Views: 10112
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...
- Thu Feb 08, 2024 10:41 am
- Forum: Scripts
- Topic: Date Today
- Replies: 0
- Views: 7043
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()...
- Wed Feb 07, 2024 12:48 pm
- Forum: Scripts
- Topic: Set Up Vcard in QR
- Replies: 0
- Views: 6910
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.
Make sure the correct fields are set for the VCARD.
- Tue Jan 30, 2024 12:03 pm
- Forum: Scripts
- Topic: Handle Image from JSON
- Replies: 0
- Views: 6814
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' ...
- Tue Jan 30, 2024 12:00 pm
- Forum: Scripts
- Topic: Normalize (Dutch) Postalcode
- Replies: 0
- Views: 6954
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....
- Tue Jan 30, 2024 11:02 am
- Forum: Scripts
- Topic: Format Date
- Replies: 0
- Views: 6931
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...
- Tue Jan 30, 2024 9:47 am
- Forum: Power Apps
- Topic: Show Button if value is blank
- Replies: 0
- Views: 9818
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...
- Tue Nov 21, 2023 4:50 pm
- Forum: Windows
- Topic: RemoteApplication
- Replies: 0
- Views: 9947
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...
- Wed Aug 23, 2023 3:13 pm
- Forum: Power Apps
- Topic: Delete record from Sharepoint List
- Replies: 0
- Views: 7007
Delete record from Sharepoint List
Create a button.
OnSelect:
Also add: after that to force your gallery to update if it doesnt automatically.
OnSelect:
Code: Select all
RemoveIf(datasource, Id = gallery.selected.Id)
Also add:
Code: Select all
Refresh(datasource)
- Wed Aug 23, 2023 3:11 pm
- Forum: Power Apps
- Topic: View form does not show selected record
- Replies: 0
- Views: 6899
View form does not show selected record
Please try with this alternative workaround.
Set OnSelect of your Gallery:
Set Form1.Item property:
The lookup function is to retrieve the record from data source, I believe this will resolve the error.
Set OnSelect of your Gallery:
Code: Select all
Set(SelectedItemID, ThisItem.ID)
Code: Select all
LookUp('Opportunities and Risk',ID=SelectedItemID)