About NotMat

NotMat · 10-30-2023

Hi all,In my app, I have the following expression:IFS(AND(ISNOTBLANK([Procedure Code 01].[Modifiers]),ISNOTBLANK([Procedure Code 01]),CONTAINS([Procedure Code 01].[Suggested Modifier], "0067"),[Add Microsurgery (of Larynx) modifier? (0067)] = TRUE),C...

NotMat · 05-18-2023

I'm looking for a workaround to this issue as per subject.I've found a formula online for my [Duration] column, see below:[End Time] - [Start Time] + IF([End Time] < [Start Time], 24, 0)This produces the correct numerical value, but shows as a negati...

NotMat · 03-28-2023

I've been battling with functionality of certain apps that make use of the search bar very frequently. A particular user has to be so selective with their search term (singular) order so as to basically perfectly match the values in the ref list shee...

NotMat · 02-21-2023

Hi allI have an image column in 'Sheet B' that needs to be mirrored in a column in 'Sheet A', based on the key column.I have a column in Sheet B that is a Key in for each row where it obviously links info into Sheet A. I used REF type columns in Shee...

NotMat · 12-09-2022

Hi allAs title reads, is it possible to save uploaded files (uploads to the app) with a specific name based on [Column] data? For example: If the form being entered has a column with a Date in it, then there's another column allowing file uploads fro...

NotMat · 11-07-2023

Thanks so much, I'll give this a try when I'm home. Does it account for the difference in the amount of days per month etc?

NotMat · 05-18-2023

Amazing, thanks so much!

NotMat · 03-28-2023

Yeah this actually seems pretty basic to be honest. It's a feature we genuinely should of had since the start.Lets say we have a ref list that has a value of "John likes apples on a thursday", and we search for "John Thursday", it doesn't bring up th...

NotMat · 02-27-2023

That did not "work just fine" unfortunately, hence my post explaining what the error was when trying to do exactly that.I ended up creating another column which concatenated the file path (on the sheet) of the image (that's produced after it's upload...

NotMat · 02-22-2023

Figured it out. Quite a tough workaround.

My Stats

gimmyliu's Bio

Badges NotMat Earned

Recent Activity

Circular Dependency issue

Calculation of duration from two Time columns, if [End Time] after midnight produces negative result

Multiple word search

Reference Image Column from another sheet

How to save an uploaded file (in storage path for that column) with a name based on [Columns]?

Re: Calculate Days between 2 columns

Re: Calculation of duration from two Time columns, if [End Time] after midnight produces negative re

Re: Multicriteria search bar

Re: Reference Image Column from another sheet

Re: Reference Image Column from another sheet

NotMat's Ideas (1)