Hi everybody,
Iโm realy new to this, but I looked everywhere for an answer to my question and could not find any.
So Iโll try to explain my problem.
I have a base form with 40 questions and I created slices of that form, those slices are unique, corresponding to a certain type of โjobโ. What I need done is that when the type of the โjobโ is selected the correct form will continue from that choice.
Example:
โPlannerโ was selected
the next page have to be the form of the slice โPlannerโ and thatโs it, then the new input will ask again about the job, and if I select another like โEngeneerโ the next page wil be the form of the slice โEngineerโ and so onโฆ
Hope someone faced the problem before and is willing to share the solution
Best regards
Julio
Welcome to AppSheet!!!
First, just need to understand what you have implemented to accomplish the statement above. When โPlannerโ is selected, what kind of view are you on and how does it go to โthe next pageโ?
Regardless, what I think you will want to do is create a FORM view for each of the Slices. Then somewhere youโll want to use the LINKTOFORM() function to navigate to the proper โjobโ FORM. Where this happens will depend on your implementation. So post back with what you have implemented so far. Including an image would be very helpful to clarify.
For more info on the LINKTOโฆ() set of functions click the link below:
https://www.appsheet.com/Support?q=LINKTO&hPP=10&idx=help&p=0&is_v=1
First of all, thank you for your concern, that being said.:
So far I created a table with the questions for my form and another table (read only) where I have names, emails and so on, from that list appointed in DATA, COLUNMS, in a specific field to be used to select a name and trought that selection a field โJOBโ will be automatically completed. That field would be the trigger to a specific form created for a specific slice.
I think you got it in your assumption, Iโll look more closely to the link that you shared to see how it goes.
The view in your image seems to be a form. Unfortunately, you wouldnโt be able to โtriggerโ navigation to another form based on the selection in that dropdown.
However, hereโs what you can do. (Jut one idea)
Now, based on your description, I am understanding in the table you will have a row for each Job selected and some portion of the 40 columns filled-in to answer questions associated to that job.
Soโฆwhat I would do is have a Form with ONLY the job selection field. The user selects the job and saves. The user is them taken to another FORM specific for the chosen job to answer the related questions.
To do this, you would need to create an Action that navigates to a FORM but selects the FORM based on the job selected in the row (the row just saved with only the job selection on it). This Action is then attached to the Job Selection FORM in the โForm Savedโ Behavior.
(NOTE: Using this method, the Action should use the LINKTOROW() function when navigating to the form view so the new row can be passed to it)
So, user selects a Job and saves. The action is fired, reads the job selected and choses the related Job FORM and then navigates to that FORM view using a LINKTOROW() function passing the new row. A new FORM view opens with the associated questions. User fills out and Saves to complete the row.
I hope this all makes sense.
It does make sense, Iโll try out your idea, thank you and soon iโll give feedback if it worked.
Best regards
User | Count |
---|---|
36 | |
33 | |
28 | |
23 | |
18 |