
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 24, 2021 07:27 AM
Hello. I have a table that it is filled using a forms. there are two fields coming from two other tables that are selected by the customer.
I need a formula column where it analyzes the two filled fields and returns the result (remuneration) based on a third table (remuneration_table).
below I am attaching a photo to illustrate.
basically I need the formula to return the candidate’s remuneration based on the sector and position he will be hired.
Could someone help me?
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 24, 2021 02:56 PM
Click the blue plus button next to {SALARIO 2} to pull in the {SECTOR + FUNCAO} field

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 24, 2021 09:17 AM
A formula alone can’t do this. Here’s what I would try:
- Set your formula to concatenate your {SECTOR} and {Attachments} fields together
{SETOR} & " " & {Attachments}
- Ensure the primary field of the RENUMERATION_TABLE concatenates the {SECTOR} and {OFFICE} fields in the same pattern
- Add a field that links the RECRUTAMENTO table to the RENUMERATION_TABLE
- Copy the {RENUMERATION} formula field value into the link field (either manually or use an Automation to do it for you)
- Return the {VALUE} field in the RECRUTAMENTO table using a Lookup field

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 24, 2021 11:10 AM
Hi Kamille, thanks in advance for your support.
I didn’t quite understand how step 3 " * Copy the {RENUMERATION} formula field value into the link field (either manually or use an Automation to do it for you)"
could be more detailed for me?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 24, 2021 11:20 AM
Either:
- Copy and paste the value from the formula field into the Link field
- Use an Automation that copies the formula field into the Link field
- Trigger: When RENUMERATION} field updates
- Update Record Action: same record ID as trigger, add the Link field, insert the {RENUMERATION} field’s value by clicking the blue plus symbol at the right of the input box

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 24, 2021 12:36 PM
I’m copying the result of the formula into the link column but it doesn’t return the data, a new row is generated in the REMUNERATION TABLE table. any tips ?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 24, 2021 12:44 PM
Did you do this^?
The purpose of copying the formula into the Link field is to connect to the appropriate record. IF its creating new records, that means the formula output a combination of {Sector} and {Office} that doesn’t exist in the RENUMERATION table yet.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 24, 2021 12:51 PM
I understood what happened, is that I wasn’t creating the formula in the primary field. I made the correction and now it worked. I will try to automate the process. I’ll talk to you already.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 24, 2021 01:20 PM
I’m lost in this second part of automation.
I’ve tried in several ways

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 24, 2021 02:56 PM
Click the blue plus button next to {SALARIO 2} to pull in the {SECTOR + FUNCAO} field

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 25, 2021 03:29 AM
It worked out! Thank you so much for your help and patience Kamille.
