Jump to content
  • 0

2 data sources



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 ? 

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0
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.


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

Link to comment
Share on other sites

  • 0

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

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...