Virtual fields suddenly not displaying parent record data with Deref or Lookup

[Daisy_Ramirez]

Hi everyone, I’ve been troubleshooting an issue where multiple virtual fields are not displaying their deref information. I changed the expression from a deref to a Lookup expression and still no data appearing. Its as if the child record (Collection) doesn’t recognize the parent (Route) REF field anymore.

Here’s what I’ve tried.

• Tried LOOKUP expression vs. deref
• Tried ANY() expression
• Saved and verified the table
• Regenerated the Table
• Deselected/Reselected the Routes table from the child table REF field (caused a giant mess had to revert to a backup)

Note: Collection table route_id has no validations etc. - just the REF connection to its parent table Routes

[Daisy_Ramirez]

At this point, I could really use a workaround until we figure out the problem.

Thanks so much

[Steve (Steve Coile)]

First and foremost: engage support@appsheet.com.

[Steve (Steve Coile)]

Please provide screenshots of the column configuration and the App formula expression for one of the affected columns.

[Daisy_Ramirez]

[Steve (Steve Coile)]

Are you sure [route_id] has a value?

[Daisy_Ramirez]

Yes, there’s definitely a relationship in place as we can see the Routes associated Collection records. I double checked to see if there’s anything weird in the table and it looks pretty solid - data as expected.

[Steve (Steve Coile)]

I’m at a loss. Please engage support@appsheet.com.

[Daisy_Ramirez]

Thanks Steve, sent the info over to support a bit earlier as well.

[Daisy_Ramirez]

Any ideas for a workaround - a way to get at the data without the expressions above?

[Steve (Steve Coile)]

None at all. If a) [route_id] is not blank and b) contains a value that matches the key column value in the Routes table and c) the referenced column itself has a value, I can think of no reason anything you’ve tried wouldn’t work. I have no idea what’s wrong or how to work around it.

[Ogle (Michael Smith)]

Make it simple to display all field to work.