Hi everybody,
I am new to AppSheet and I am still learning. I am moving forward with my App but I am sometimes stuck for hours on the same issue. Even by looking for solutions around the web โฆ
Here is an issue Iโve been dealing with:
I need 1 cell (from a reference table) to get the row number of the form the user is filling.
To do that, I created an action โWhen user complete this cell in the form, then send the row number to the cell in the reference tableโ.
But everything I tried didnโt work. Both on the action trigger side (when user complete this cell in the form) and the action itself (send the row number to the cell in the reference table).
It would be awesome to have some help from you, dear community.
Best regards,
Arnaud
Solved! Go to Solution.
Can you perhaps explain why you want to capture the row number of the form just submitted?
I want to capture it, because I need to display results of formula (in this same form), based on a reference table that needs the row number of the selected form.
Example: I am completing the form, I am at question 3 and I am asked to select the apartment in a dropdown list (from another table with more info in there). I select the โApartment Bโ (row nยฐ4), the next question depends on the result from the reference table. The reference table will change completely depending on the row number of the apartment selected.
Sounds like you would find references and dereferences useful:
Hi Steve,
Thank you very much for your answer. Iโve dived in many of the Help available but am still stuck. I lack technical knowledge, but I am sure, it will come by spending more and more hours reading and checking articles on Appsheet.
Everything seems easy in my head, but as soon as I want to implement something, I donโt know how to make it happen.
Example in the screenshot. I want that after a question,
1.Users fill the info if it doesnโt exist yet. To do that, I guess that if the user answers โNo I donโt have the dataโ, he should be redirect to a view that will help him filling this missing data into the right table. However, even after implementing this action, I am not redirected to the view Iโve created.
The long form will need this info to display formula to the user along the form. Thatโs why I need this info to be sync as soon as possible. (And not at the end of the survey).
I would be grateful if could give me some insights, how would you implement this scenario ?
Arnaud
Iโm afraid your needs are beyond what I myself am prepared to provide at this time.
Oh I didnโt expect it was that hard. How would you process this issue Steve, if you were in my situation ?
Is there another way than asking here ?
Best regards,
Arnaud
My specific concerns stem from a) your intention to uses slices, b) the need for multiple saves, and c) the need for navigation actions. None of this is wrong, mind you, but I would consider it advancedโmuch more than a typical first-app solution. Given that, Iโm concerned that you would need a lot of guidance, more than I myself am willing to commit to. Iโm happy to help piecemeal, but Iโm just not prepared to commit what I fear would be a significant amount of time.
I would suggest considering simplifying your design to something that doesnโt require as many advanced methods. Once youโve proven a basic app, upgrade it with new, more-advanced features.
Iโve changed the way to operate. I donโt need to reference a specific cell anymore.
How ever I think I am facing a technical issue. I will open a new thread because it is not related to this thread.
User | Count |
---|---|
42 | |
29 | |
25 | |
23 | |
13 |