How to link tables

Hey All,

Can you please guide me on how to insert data from one table into another please?

I am building a website like upwork.com where :

• Clients post jobs (done)
• Freelancers see a list of all jobs from all clients(done)

• When freelancer applies for a job, their profile details should come up in the repeating group for the client. This will show the client which freelancers applied for their job.

How can I do this please?

I have a table with all the client jobs and another table with all the freelancers’ details.

In the client jobs table, I have a field which is of type freelancers’ details.

How can I specifically link the two together via the workflow please when the freelancer clicks the apply button?

Thank you

Hi!

To resolve the issue just create a field on JOB datatype i.e Applicants with type Freelancers as a list. When a freelancer applies for a JOB add them to the field Applicants. On the Clients side you can then display freelancers interested in each JOB by referencing JOBS’ Applicants

Thank you for your reply.

If I understood you correctly, I have two tables:

  • Client jobs
  • Freelancer information

In the client jobs table, I already have a field called ‘who applied for this job’ of type ‘Freelancer information’.

I’ve got this already.

When the freelancer clicks on the apply button, what exactly do I need to add in the workflow so that in the client jobs table, the field called ‘who applied for this job’ of type ‘Freelancer information’ is populated?

Thank you

Add the freelancer to who applied for this job

Thanks for your reply.

How do I do that? What do I write in the work flow when the button is pressed?

Use “Make Changes to Client jobs” and while at it Modify “who applied for this job” by using add current user Freelancer information. {If freelancer information is link to user}

Thank you.

Use “Make Changes to Client jobs” and while at it Modify “who applied for this job” by using add current user Freelancer information. {If freelancer information is link to user}

This part (in bold) is in a different table called Freelancer information. This has fields such as name, why me, previous work etc.

So how can I link the two together please?

This topic was automatically closed after 70 days. New replies are no longer allowed.