Hello everybody,
I have two table,
First table have Fixed information
Second table it is form for user he just add some information from the first table and i have another column name [Number of room] at form for user
I want from this column when user add some number the information would repeated so how can i do this!?
I’m not sure of understanding your question, but from my understanding, you can use the Initial value field of the column.
Let’s say ou have a column named “number of room” and another column named “confirmation of number of room”, then you could use the Initial value expression:
[number of room]
You can also get it from there:
For reference: Define app formulas and initial values - AppSheet Help
If that doesn’t answer your question, can you rephrase and add more context such as table structure?
Screenshots are best.
Also, if English is not your first language, I suggest to use deepl.com as a translator.
I hope this helps!
Hello
I have two tables, the first table contains static information
The second table is a set of options for the user to answer from within the questions I want, when he chooses it, he enters any number he wants in order to be able to repeat the answers
Example:
[Name of Project]
[Type of project]
[Name of building]
[Number of floor]
[Department]
[Room Name]
[Number of room]
[Item Name]
When the user accesses this question
[Number of room]
and enters any number they want, it will repeat all the answers to this question according to the number I entered
What is the most correct way to do this?
Thank you for your help
I’m getting somewhere, but I don’t know what’s wrong.
1- Now i need repeat this room 5 times with its information at items name.
2- The issue is that when I try to repeat, it only repeats the first row and then stops.
3- These are the expressions I came up with and created a bot.
I hope that’s clear to your Honor by now. @Aurelien
Can i see your first table?
From my understanding, you want a repeater?
It creates a row based on the quantity? Am i right?
OK, so if you need to be able to repeat X times your row, you may want to get inspiration from this post:
Looping with Actions (Sample App BUILD Video) - Google Cloud Community
