Hi there,
I'm creating a form that can have multiple entries, but each entry goes in a different row. I created the Host Application form with the following:
- Facility Name
- Assessor Name
- Candidate Name
On the settings, I chose 'Send user to the link' > Then, I created the 'Candidates' List form', where only the Candidate Name appears. This creates an eternal loop where one facility can enter multiple candidates without needing to re-enter the Facility Name and Assessor Name again, ensuring each candidate comes in a different row in the sheet, exactly what I need for future purposes within Smartsheet:
- After someone submits a Host Application with the candidates' list, each candidate will need to submit a Candidate Application (another form in another sheet same workplace)
- In a third sheet, I will have an automation to Complete the application process when the AEF# matches in both applications.
The problem I'm having is that when the new form is entered, the Facility Name and Assessor Name are NOT filled out in the row. When I created the 'Candidates' List', I duplicated it from the 'Host Application' one, then I hid the two first fields, I tried to write a formula on the 'Default Value' to copy the value on the cell above but:
- It doesn't work because the Default Value adds a ' at the beginning making it impossible for the formula to kick in
- Even if the formula works, if person B starts filling out a Host Application while person A is filling out the Candidates' List one:
- A Candidate entered by person A will copy information from person B, not A
See the test below for understanding the explanation above:
Can you please help me with these problems? Smartsheet would work amazingly for what I need if I can figure this part out, but I have been trying to resolve this for days now and I just can't...
Thank you in advance for your support.