About Shaun_Stringer

Shaun_Stringer · 06-07-2023

Hi,I am having trouble with a Start Expression in a report template.<=[_THISROW].[Date From], [Date]<=[_THISROW].[Date To],IN([Watershed],[_THISROW].[Watershed]), IN([Site Name],[_THISROW].[Site Name]), IN([Purpose of Visit],[_THISROW].[Purpose of Vi...

Shaun_Stringer · 12-05-2022

I am having trouble with the filter part of my start expression.Here is a table with example data. The table is called Training.EmployeeTrainingExpiration DateA11/1/2021B12/1/2021A22/1/2021<>I am trying to add to this filter expression so that if an ...

Shaun_Stringer · 07-14-2022

Hi,I have a Task that creates a PDF Attachment and stores it in a specified sub-folder. I would like to include the date/time column in the name of the attachment, but when I add the date/time column to the attachment name, it automatically creates s...

Shaun_Stringer · 07-07-2022

Hi,So I am using an ENUM base Ref and Valid_If expression rather than a REF type column to provide the specific list of items I want people to choose from, but I would also like to use the Valid_If expression to make the selection invalid if it does ...

Shaun_Stringer · 04-06-2022

Is there a way to make this happen in a form?IF(Condition 1, then Result 1, otherwise Column is Editable)?

Shaun_Stringer · 06-08-2023

Unfortunately, that did not work either. If I change either of the IN() expressions, the error still noted a bad parameter 2 of the IN function. Once everything is changed to INTERSECT, I get the following...Error encountered in step with name [Field...

Shaun_Stringer · 06-07-2023

That did not work though there is more to the error message. Error MessageError encountered in step with name [Field Log Report PDF]: Error: Task 'Field Log Report PDF' Attachment template. Expression 'SELECT(Field Data[Key],AND([Date]>=[_THISROW].[D...

Shaun_Stringer · 06-07-2023

Yes. The Field Data table is where all the filtered rows should be coming from. The Reports table is the interface where Users will query the data they want from Field Data. The Site Name column in the Field Data table is a Ref to a parent table (Sit...

Shaun_Stringer · 12-06-2022

I got it. It is this.<><>Training: <>Expiration Date: <<[Expiration Date]>> <>Thank you for all of your help!

Shaun_Stringer · 12-06-2022

EmployeeTrainingExpiration DateA11/1/2021B12/1/2021A22/1/2021A13/1/2021B34/1/2021A45/1/2021B26/1/2021With this extra row, my desired result would now be..ATraining: 1Expiration Date: 3/1/2021BTraining: 2Expiration Date: 6/1/2021

My Stats

Devashree's Bio

Badges Shaun_Stringer Earned

Recent Activity

Start Expression Error

Start Expression issue

Archive Attachment Name - want to add Date without creating sub folders

Valid If expression for SELECT Ref list AND column comparison

Formula and Editable at the same time

Re: Start Expression Error

Re: Start Expression Error

Re: Start Expression Error

Re: Start Expression issue

Re: Start Expression issue