About bradlegassick

bradlegassick

I am trying to create Child records, EstimateDetails, when an Estimate is created. Each Estimate is for a Structure that consists of multiple stages. I can do this with looping but it takes a long time. I am trying to do it on the server using the AP...

bradlegassick · 10-18-2023

Hi Community, I have retro fitted 2 columns to an app that I need to be populated. The records are invoice details, the invoice details are already reference connected to products. I have added the product category field to the invoice details table....

bradlegassick · 07-21-2023

Hi CommunityI am retrieving records via Apps Script using the AppSheet API. I am having relative success with the API. However I have encountered strange behaviour when using the Selector property & the record ID is all integers. The record ID was cr...

bradlegassick · 03-17-2023

I have to compare a list of invoice dates, from the "Related Invoices". The single "Start" date is entered in the dashboard filter controls. I have tried the following expression & a bazillion variations & I have only succeeded in getting random data...

bradlegassick · 03-13-2023

I have noticed that sending emails via automations is delayed by up to 2 hours tonight. Is there any outage we should be aware of? I have customers placing orders & it looks like the logs are showing a "Success" message. However I am not receiving an...

bradlegassick

Hi @AleksiAlkio thank you for the tip, I have used this expression now to create the correct records:{"Action": "Add","Properties": {"Locale": "en-US"},"Rows": [<>{"EstDet_EstimateLink": "<<[_thisrow-1].[Estimate_ID]>>","EstDet_Stage": "<>"}<>]}Succe...

bradlegassick

I am using this to generate the Start expression: SORT(SELECT(Looping[Looping_Index], ([Looping_Index] <= COUNT([Estimate_Blueprints]))))>>However it is generating a list of my indices & I should be starting with a list of records IDs to loop through...

bradlegassick

Thanks Aleksi, I will give this a try.

bradlegassick · 02-07-2024

Desktop 'Preview' form is slow to open the form again after clicking a button that has a Linktoform expression linking to the same form. The idea is to enable adding records quickly without manually saving & reopening the form (not using the native. ...

bradlegassick · 10-21-2023

virtual columns, I have 2 - so for now this approach is chinking away & getting it done. I will definitely remember your tip here. Thanks Aleksi.

My Stats

bradlegassick's Bio

Badges bradlegassick Earned

Recent Activity

Create Records with API & Webhook

Updating a large number of related records - approximately 50 000

AppSheet API Find Call Issue

Comparing a single date to a list of dates

AppSheet emails seem to be extremely delayed 21:34 AEST

Re: Create Records with API & Webhook

Re: Create Records with API & Webhook

Re: Create Records with API & Webhook

Re: In Preview: New UI design for desktop users

Re: Updating a large number of related records - approximately 50 000