This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
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) ...
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...
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....
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...
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!!
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/...
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?
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...