Display field

[Kuroshi]

Is it possible to display a field or fields from a different table? 

[Barbie]

Hi @Batchini,

Yes, you can achieve by using an SQL expression in Calculated Value or Calculated Fields.  You can refer to this article and scroll through the Subqueries in Calculated fields:  https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/ there is a sample SELECT statement that will help you achieve your workflow. 

Hope this helps.

-Barbie

[SunakoChan]

Hi - If you wanted to display the record from the other table you can use a view to join the table(here is a reference link: https://howto.caspio.com/tables-and-views/) or if you want to pull and use that records you can use a lookup table(here is a reference link: https://howto.caspio.com/tables-and-views/lookup-tables/).

-Sunako

[JolliBeng]

Hi,

Just to add on @Barbie's comment, here's a useful guideline on SQL functions that are accepted in Caspio:

~JolliBeng

[AtayBalunbalunan]

For future reference, SQL statements can be used in:

1. Calculated Field

2. Calculated Value

3. Aggregation

[SunakoChan]

Hi @Batchini, Just to add you can visits these links to know what can you use, base on the workflow that you have:
https://howto.caspio.com/function-reference/
https://docs.microsoft.com/en-us/sql/t-sql/queries/select-transact-sql?view=sql-server-2017

I hope this helps.

[ParkLoey]

Hi! For reference, here's a guide on the actual calculation that can be used for this scenario:

SELECT NameOfFieldInTable FROM NameOfTable WHERE NameOfFieldUsedForCondition='VALUE OF FIELD FOR CONDITION'

I hope this helps!