2 data sources

[DRAhmed]

i made a data page for my company employees in which they enter doctors cv 

now i want to make a data page which according to a specific criterias pulls job offers from another data source 

 

for example a doctor who acquired his masters degree in 2015 in pediatrics 

 

and there is a job offer that wants doctor who have a masters degree in 2017 or earlier 

 

how can i do that ? 

[GoodBoy]

Hello! You may try joining those 2 tables/data sources using a view and use it as the data source for your DataPage.

- https://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-join-tables/

[DRAhmed]

1 hour ago, GoodBoy said:

Hello! You may try joining those 2 tables/data sources using a view and use it as the data source for your DataPage.

- https://howto.caspio.com/tables-and-views/what-are-views/creating-a-view-to-join-tables/

the main idea if i make a view, i want to write a number in a field and the adjacent data from another table to be pulled automatically

[GoodBoy]

You can use cascading elements to achieve that.

- https://howto.caspio.com/datapages/datapage-components/cascading-elements/

[Wikiwi]

If you are just pulling specific records from another table that are related on your actual Data source, I can also suggest using a SELECT sql script. You would just need to add a calculated field in your DataPage and put the Select statement there.

[GoodBoy]

I agree with @Wikiwi! Basically, the SELECT statement format you may use is:

SELECT ColumnName FROM TableName WHERE ColumnName = target.[@field:ColumnName]

Here is a helpful article for more details about this topic.

- https://howto.caspio.com/datapages/reports/advanced-reporting/calculations-in-forms-and-reports/#:~:text=Subqueries in Calculated Fields