Jump to content
  • 0

Lookup in a table as a formula



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

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

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.

Link to comment
Share on other sites

  • 0

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/

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...