Jump to content
  • 0

2 data sources


DRAhmed
 Share

Question

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.

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

Link to comment
Share on other sites

  • 0

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.

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.

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

Loading...
 Share

×
×
  • Create New...