About AACarde

AACarde · 02-19-2020

I’m new and not great at programming but I do have some experience in spreadsheets. I’m looking to create an ID from NOW() or similar. I was able to do it by CONCATENATE(“AS-”, NOW()) but I don’t like what it returns. IE… (( AS-02/19/2020 12:51:30 ))...

AACarde · 02-21-2020

Agreed. In this case there would be a limited amount of people adding to this table. 1 or 2 users. Breaking this down to the second makes me pretty confident that submits would not happen at the exact same time. In other tables I am using UniqueID(),...

AACarde · 02-20-2020

Hmmmm. I don’t want what a UniqueID returns in this table but it made me think that I might want time and date columns in this table. Not sure yet. Edits are made in these rows over time. I think I was looking for an ID that looked more like an ID I’...

AACarde · 02-20-2020

That is perfect Suvrutt. Very much appreciated and it showed me how I would be able to create future IDs this way. Thank you! Suvrutt_Gurjar: Yes, your expression could look something like below CONCATENATE(“AS”,"-",TEXT(NOW(),MMDDYYYY), “-”,TEXT(NOW...

AACarde · 02-19-2020

How do I do that? Do I wrap the brackets around Concatenate? Do I wrap it around NOW()?

My Stats

AACarde's Bio

Badges AACarde Earned

Recent Activity

Change Date and Time format

Re: Change Date and Time format

Re: Change Date and Time format

Re: Change Date and Time format

Re: Change Date and Time format