Hi,
I have a table for which I need to retrieve data in cells one at a time, I don’t need to find the index, just the data in this table.
I hope my question is clear.
I don’t need the table index, just the data in cells one at a time.
(the users of glide regular tables in a portal app)
Thanks for your help
I think it would make it easier to assist you if you explained the flow or user experience in the layout editor: what action does the user take and what do you expect to happen?
If for instance you had a button and every time the user tapped it some value in the next cell below needed to be shown:
(You don’t have to create a separate helper table, you could write to the same table.)
Thank you for your answer.
It’s a submit button rather than a regular button!
Ideally, upon loading a tab (screen) values are copied to the corresponding fields in the loaded form from the previous form!
(All that is extra information, now, how do I list a table’s single query element at a certain index . Or even a Lookup at a certain index?)
Are you trying to create a multi-step form? If so, in the Layout Editor, when you create a new tab, you have the option to create a multi-step form.
Do exactly what you said: create a query column and filter for an index, or create a relation based on a index column.
Keep it simple. You’re much better off create simple tables, simple columns, simple actions and workflows. If you’re having trouble visualizing what you are building and don’t really understand the logic of what you’re build, then you’re probably building over your head and need to simplify things. You’ll thank yourself for keeping things simple, because on the long term having to maintain a complex app you don’t understand is a headache.
It is simple.
I have some Query and some Lookup. Both are not empty. How do I get the sizes of both of those structures?
That’s the missing link
What do you mean with “sizes”? Have you experimented with the Rollup column?
no, only single value
Single value allows you to retrieve a single value of any table. Rollup allows you to determine averages, max, min, count of a set of values. For the “size” of set, you might want to experiment with the rollup column.
Too bad I can’t do SomeQuery[0..Rollup-1] or SomeFeedback[0..Rollup-1]
Do you mean “sum”? The rollup column allows you to sum sets as well. Use the query column to call a table and filter it, then you can use a rollup column to sum one of its columns.
How to calculate Rollup-2 and add it to a table cell?
What do you mean by “Rollup-2”?
value-another value
You’ll need to explain in a little bit more detail what you’re trying to achieve. The easiest for you might be to play around with the rollup and query columns to see what their outputs are.
table deduction: cell = value - value
I cannot explain it further!
The math column allows you to deduct.
Using the math column, how do I auto increment (++)?
What do you mean by auto increment?
auto increment, is common in coding and JS, adding +1 automatically to every new row
This was solved here.