Lookup in a table as a formula

[Hiperf]

I am attempting to write a formula to LookUp a value in another table. This is what I have but it did not work.

LookUp(tblUnit, UnitRent, UnitID=[@field:XBSUnitID])

tblUnit: The name of the table to query.
UnitRent: The field containing the rent value to retrieve.
UnitID=[@field:XBSUnitID]: The condition for the lookup, where UnitID in tblUnit must match the value in the field named XBSUnitID.writing

[Tubby]

Unfortunately, formula fields in tables does not allow you to select values from another table. You can check the note that I highlighted in Caspio's article: https://howto.caspio.com/function-reference/#:~:text=Vary-,Select,-Returns a results

This can only be done by using their advanced features called triggered action or you can do this on a DataPage using Calculated Values/Calculated Fields using the SELECT statement in the article above.

[Tubby]

Btw, here are articles about triggered actions and calculated values/fields in case you are interested in those:
Triggered action: https://howto.caspio.com/triggered-actions/triggered-actions-2/
Calculated Value: https://howto.caspio.com/datapages/datapage-components/calculated-values/
Calculated Field: https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/

[Queso]

Hello @Hiperf,

Just to add, this is also possible with Caspio's Application Tasks: https://howto.caspio.com/tasks/