Hi. Im bulding an app for signing in and sch...

(Jorge Santos) #1


Im bulding an app for signing in and schedule people at an event.

Everything is doing well but i known want people to pre-sign trough google forms and after,

when they arrive at the front-desk, my staff pick their data and save it to the definitive table.

So, how can i save data from one table to another(temporary table to a definitive table)?

Thanks a lot Jorge

(Stephen Mattison) #2

Why must you move that data to a different table? You could just add a column with a status identifier and just change that accordingly when they arrive and have the app sort your data that way. Seems like it could be more powerful to keep the data all together.

Your apps are more powerful than a mere spreadsheet.

(Aleksi Alkio) #3

I would design the app with one table as well. What I have created registration apps, they are working in a different order… attendees have filled all data when filling the registration form and when they arrive, front-desk just need to change the status. If lot of attendees are coming at the same time, it would be quicker way. But of course we don’t know your structure.

(Aleksi Alkio) #4

You’re welcome

(Jorge Santos) #5


That seems good, but it can goes really bad because the Google form can be filled by everyone with the link (so multiple fills with uselees data is more than possilbe). Worst than that, the schedule table is filed by a column in the registerd users, so those useless multiple fields whould apear… (Ref)

Take in consideration that the pre-register is open to the public and “smart-guy” could be adding registres just for fun.

A copy to the final table or pre-fill of the registration form is the more secure way to go… I think


(Jorge Santos) #6

Hi all

Im trying your approach to see if i could make it happen without security problems. But i stumble into a hurdle…

I have to assing a person to a time slot trough a fiscal number. But as you guys pointed out, a “person” only exists after i Confirmed its signing.

The problem is Everyone shows up in the filed i have REFed… (Confirmed and non confirmed)

I´ve tries several filters but it allways shows up!

How can i do this??

Once again… thanks a lot!!!

Cheers Jorge

(Aleksi Alkio) #7

You wan’t that your form would not show any of them?

(Jorge Santos) #8

Hi Aleksi

I only want the confirmed ones to appear (in the combo box of yhe ref field) when i schedule people to the time slots… (Schedule view).

I think its a matter of filtering what appers in the comboboc of the ref field… But tried lots of things and no luck

Thanks Jorge

(Aleksi Alkio) #9

You can use a formula like SELECT(TableName[KeyColumnName],[STATUS]=“Confirmed”)

(Jorge Santos) #10

Great aleksi! Thanks!!

But… where do i put it? Im confused about that…

Cheers jorge

(Aleksi Alkio) #11

Put it into the Ref column’s Valid_If

(Jorge Santos) #12

Thanks Aleksi!!!

Cheers Jorge