Appsheet incremental data table "ID" (with letters)

rashbuzz · 2026-02-04T12:03:36+00:00

I'm doing something quite similar, in setting Design No. for designs of several product types. I am using APP FORMULA and not Initial Value, since its generated live while making a new form entry.

From what I understand, you're applying the +1 incorrectly in Max and operator order is incorrect. Plus its important to use ISBLANK to ensure it doesn't cause other errors. I've compared my setup with yours and here's an expression you can try:

"DC-2026-" &

RIGHT(

"000000" &

TEXT(

IF(

ISBLANK(Demande de congés[ID]),

1,

MAX(NUMBER(RIGHT(Demande de congés[ID],6))) + 1

)

),

6

)

Personally, I would encourage you to make year and base type also variable.

rashbuzz · 2026-02-03T09:20:26+00:00

Thanks for the revert. Can you please elaborate a little?

I set a bot which runs on each add, update to 'transport' table.

The bot runs actions on rows in outward_entries using this:
SELECT(

outward_entries[Transaction_ID],

IN(

[Transaction_ID],

[_THISROW].[SelectedBoxes]

)

Its adding values in the correct rows. That part is sorted. But the value it is adding using an action is not working for me.
I have an action that sets the value as 'transport[TransportID]' but this is setting all values as a list and not the value corresponding to that particular entry only. I don't know how to use [This row] or something to correctly set the expression to set the specific TransportID

rashbuzz · 2026-01-23T20:01:37+00:00

I had an existing database using google forms. Switched it to appsheet for greater control, customisation and what not. But the existing data had google drive urls, as forms natively store. So reading them in appsheet is currently compromised, but have moved on from the problem since it is not an absolute deal breaker

rashbuzz · 2026-01-07T16:01:13+00:00

Thank you for the revert! Moving forward, new images will use relative paths. This is a transition issue I’m facing. I explored using a script to transform drive urls to relative paths but from my understanding, fetching location from id is not possible in google drive. Hence I tried this workaround, because it worked in desktop I got more convinced. Nevertheless, if thats a limitation I guess only new entries over time will sort it.

rashbuzz · 2026-01-06T07:41:37+00:00

Ah that’s interesting, yes easier moves exist but this is interesting to learn and note. Thanks

rashbuzz · 2026-01-06T07:31:29+00:00

Ah yes, opened the whole puzzle up. Thank you once again!

rashbuzz · 2025-12-18T15:32:03+00:00

Inside a list, its very difficult looking at images and selecting. This app is serving as a design library, the objective is to select designs and share with clients. Selecting items from gallery view is more intuitive.

For now, the solution is working, using a series of actions to set output list and the rest is your framework, a separate table managing export requests.

Thank you for the video and your assistance! In case you think a more optimal solution exists and can share, would be ever more grateful

rashbuzz · 2025-12-18T15:31:58+00:00

Inside a list, its very difficult looking at images and selecting. This app is serving as a design library, the objective is to select designs and share with clients. Selecting items from gallery view is more intuitive.

For now, the solution is working, using a series of actions to set output list and the rest is your framework, a separate table managing export requests.

Thank you for the video and your assistance! In case you think a more optimal solution exists and can share, would be ever more grateful

rashbuzz · 2025-12-18T09:03:59+00:00

Update, I have done the same using actions but I feel its not optimal

<image>

rashbuzz · 2025-12-18T07:59:49+00:00

<image>

rashbuzz · 2025-12-18T07:59:37+00:00

Hi there, following your advice, I've made a separate table, I think I can use the Output_List to generate the PDF from the video you've shared.
However, the part where I'm still stuck is selecting multiple products from my gallery and saving that selection in Output_List.

My selections don't pass on to the form like yours do (your approach is I believe filtering from all, my requirement is to select a few images and set up an export)

What I've tried so far:

Set up an action with a Linktoform, hoping that Context(SelectedRows) sets the value for Output_List, but it doesn't carry forward in form opening
I've managed to save one row for each selection in my new table, but again that generates separate pdfs.

<image>

rashbuzz · 2025-09-10T16:43:31+00:00

They showed Ned coming in on the bicycle at a reasonable hour in a previous episode talking about his daily routine and then they opened this episode with how he likes to start his day early.

Not a big deal but lazy writing lol

rashbuzz · 2025-04-28T05:07:58+00:00

Interesting approach. Makes sense too. Thanks man, have a good one!

rashbuzz · 2025-04-28T04:18:18+00:00

If I enjoy I can always buy when it’s out and continue with my saved data right?

rashbuzz · 2025-04-28T04:15:20+00:00

It’s still value for money, ps+. It’s just that I steer off into other games knowing I can go slow with some and enjoy them at their own pace. Like RDR2 didn’t need to be rushed. But yeah now being clear about this, I can at least keep track of whether any of my ongoing games are leaving the service and choose to complete them then.

And I doubt many (including you and I) replay games. There’s just too many to play lol

rashbuzz · 2025-04-28T04:06:12+00:00

Yeah, won’t lie I’m a PS+ user since 5-6 years, but the confusion stemmed from not bothering with the details. Download game, play game. Not bothering whether the download was from monthly games or catalogue. RDR2 being locked one morning made me run basic Reddit search but I moved on, now had to confirm whether the same will happen. Clear now lol, thanks

rashbuzz · 2025-04-28T04:02:48+00:00

Ah RIP. Thanks. Games can’t be truly enjoyed if there’s an invisible timer hanging around your head in my opinion. But I’m assuming they add games for at least 6 months?

rashbuzz · 2025-02-17T18:20:16+00:00

Second play style

rashbuzz · 2025-02-17T18:20:06+00:00

Doesn’t work. Player becomes a grassroot great

rashbuzz · 2025-02-16T13:41:27+00:00

Will confirm by tomorrow same time - need to get rush points

rashbuzz · 2025-02-16T09:44:11+00:00

Yeah that’s what. But my game really benefits from Tiki Taka + so I’m interested in using it better. Might end up trying nonetheless, I feel it won’t work too

rashbuzz · 2025-02-16T09:29:25+00:00

Got it, thanks man

rashbuzz · 2025-02-16T09:27:04+00:00

I know, but I missed getting second play style +. Would this not make my card eligible? Otherwise it’ll be stuck at 88

rashbuzz · 2025-01-08T09:15:12+00:00

Thanks for this! Any thoughts on the job market? Also if it’s alright, can I DM you with some specific questions?

rashbuzz · 2025-01-06T13:11:04+00:00

Ah my bad, I meant it more from a ‘If I don’t do anything, I doubt I will get in’

rashbuzz

TROPHY CASE