About Dialect_Junk

Dialect_Junk · 06-12-2023

How do I create a dependent dropdown that’s based on a column's auto-populated App Formula?My app has a “Tasks” table that auto-populates a [Project Number] column via app formula, like so.Tasks TableREF column to Work Order TableThe Project Number i...

Dialect_Junk · 05-30-2023

How can I have only specific values from an enum dropdown list be available based on an app formula?I have a project management app. Each project contains Pay Item Numbers related to that specific project, like so: Each project has a “Tasks” (child) ...

Dialect_Junk · 03-14-2023

Hello. I have a parent table called "Work Orders." I have a child table called "Work Order Comments."I want to view only the most recent entry in the work order comments related to a work order.I created a virtual column in the parent table with a de...

Dialect_Junk · 04-26-2022

Hello. I have a timecard app that captures hours worked via date/timestamp columns - "Clock In" & "Clock Out."We recently implemented "night shift" pay where if an employee works any hours between 8pm and 4am they receive upgrade pay for those hours....

Dialect_Junk · 04-15-2022

Hello, all. I have an action called "Close Work Order" that sets the [Work Order Status] column to "Closed." I don't want the action to be available if the value of the [Task Code] column is either "MILLING" or "TRAINING." I tried this expression but...

Dialect_Junk · 06-13-2023

Thank you! Worked perfectly.

Dialect_Junk · 03-23-2023

That worked. Looks like I renamed the original [Related Comments...] to something different while also creating another VC named "Comments." Not sure what the heck I was thinking 樂. Thanks, Marc!!

Dialect_Junk · 03-17-2023

The expression worked but it was only pulling the very last comment from the entire table and "duplicating" that across all the work orders (hard to explain).I tried several variations and this one seemed to work:ANY(TOP(ORDERBY(SELECT(Comments[Date/...

Dialect_Junk · 03-15-2023

Ok, I gave that a try and got this error message:"The expression is valid but its result type 'Ref' is not one of the expected types: List"Both of the VC's are List type columns. Do these need to be changed to Ref types?

Dialect_Junk · 03-14-2023

Hi Marc. Thanks for the reply. Tried the suggested changes but received this error message. "Column ORDERBY COMMENTS in expression '[ORDERBY COMMENTS].[Comments]' does not contain a reference"For that 1st column, I created a VC called "ORDERBY COMMEN...

My Stats

Dialect_Junk's Bio

Badges Dialect_Junk Earned

Recent Activity

Dependent Dropdown off App Formula?

Display specific values from ENUM list based on column's app formula

View most recent entry from deref

Calculate "night shift" hours

SHOW IF on an Action

Re: Dependent Dropdown off App Formula?

Re: View most recent entry from deref

Re: View most recent entry from deref

Re: View most recent entry from deref

Re: View most recent entry from deref