Sorry guys I have a serious problem that I can’t solve. I have a “Day Number” column that I use as a reference for a series of calculations, I need it to be populated, for each different “RowID” with a sequential number of days, where the first is always 1 and the others are added in sequence, 2, 3, 4… until the total “Trip Length” is reached. I can’t create this function. Can someone help me?
1 Like
Can you show a screen shot of the table please?
1 Like
Where are you getting “Lookup Number” from?
1 Like
from the “related days” row
1 Like
If one row is always representing one day, you can:
- Use a relation that matches all related days for a trip.
- Create a lookup on top of that relation to return all rowIDs (add a rowID column if you haven’t added it).
- Add a Find Element Index column, find the current row’s rowID in the lookup of IDs above.
- It will give you a 0-based (0, 1, 2, 3) list. Add a math column with the formula being Index + 1 to get you to a 1-based list of numbers.
1 Like
Dear Thinh, thank you, your formula seems to be perfect, but I’m in a loop of wrong rows and I sincerely feels stucked. May I share the csv file with someone who can help me to overcome this?
1 Like
I’ve created your rows and formulas, but it seems not working, I made some mistake for sure, and it seems I’m so confused that I not able to see the problem who’s probably right in front of me. Please help me.
1 Like
It’s hard for us to point out where you went wrong if you don’t show us what you did.
Please share a screenshot of the configuration each column.
2 Likes
I know, but I don’t want to spam you with several screenshots. Maybe I can share the csv file? If not, I will share the screenshots
1 Like
Nothing wrong with screenshots. It’s hard to help without fully understanding what you are seeing. Screenshots tell us things that you may not think to ask or notice.
3 Likes
Of course. Well, let’s go with screenshots. First screenshot will be all the rows of the data/days, then the settigns of the last three, that in my mind, based on the suggestions of ThinhDhin, could work.
1 Like
If you think it’s something due to the Glide free version limits (I mean, apart from my errors), and you think the Explorer subscription can give me more instruments to simplify all the process, please let me know. Eternally grateful.
1 Like
The first thing that jumps out at me is that your Find Element Index column is misconfigured.
You should be finding the RowID, not the TripID.
That column should have an incrementing number in each row, starting from zero.
Fix that first, and let us know if it’s still not working.
It’s not. The technique that @ThinhDinh described can be applied on any plan.
2 Likes
Understood. You mean I’ve to put RowID in the highlighted field? Because I’m not able to find it in the available fields selection in the row configuration. Maybe I’ve to create another column that get the RowID and be visible?
1 Like
You have to add a rowID column to that table first.
Then reference it in the lookup. You’re still using the tripID here.
Finally, as Darren said, reference the rowID to find it in Find Element Index.
1 Like
Great. Thank you so much. Everything works and now the column has the number in sequence, but…
But they are not separated for trip. I mean, any different trip has a number of days, 1, 2, 3, 4
for the first trip, from 1 to 8 for the second, and so on, but as you can see in screenshot the result is a global count of the days. How can I keep them separate? (maybe a problem with the RowID in data/days who has a diffrent ID for each days, instead a different ID for any trip?)
1 Like
Did you do this as “Related Days > RowID” or just point it straight to the RowID column? It should go through the relation.
1 Like
Yes, it should be Related Days > RowID.
2 Likes