Unanswered

Unique Student ID Numbers

(0) Share

Report

Posted on by OpaqueSmoke

I have built a flow, that when a student signs into a class using a form that data is sent to Google Sheets and then my flow creates a document in word using a template that creates a certificate of attendance for that student. However, I need each certificate numbered uniquely and individually and sequentially. The spreadsheet logs each entry numerically and sequentially with an "ID" number, and I could easily use this ID number for the certificate number. However, because I just started using this system, the entry numbers are too low. I need to add 12950 to each entry number. I have tried using the add function without success. Any advice would be much appreciated.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

@OpaqueSmoke
Hi there. When you say you've tried using add without success, are you getting an error or unexpected results? It may not be interpreting the ID field as a number, so an expression that converts that field to an integer (number) before doing the math might work. Something like this:

add(12950, int(<Dynamic field for ID>))

Give that a go and let us know how that works.
-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Was this reply helpful? Yes No
OpaqueSmoke 2 on at

Like (0)

Report

I apologize I am fairly new at this. When I try that I get "the expression is invalid"
When I try expression>add>then click over to dynamic, all the dynamic entries are gone and all I can see is "records" and "records value"

Was this reply helpful? Yes No
Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

Double check that you are adding that step from within the "apply to each" loop.

Was this reply helpful? Yes No