Two Quick Questions: Dynamic Labels and Duplicate Prevention

[dyee4613]

Hi.  Here is what I'm trying to do.  

Dynamic Labels:

InputBox = 27

Label3 = COUNTA(Table1.Name)= 17

Label4 = "There are" Label3.value "Out of " Textinput3.text

I have the inputbox and label3 built.  How do I add their values to label 4?  

Duplicate Prevention

I'm making a signup sheet and I want to make sure the same user ID doesn't get entered multiple times by accident.  I was thinking using a lookup and if it finds anything then the submit button disables.  Is there a better way to do this?

[RandyHayes · Accepted solution]

Try this:

InputBox = 27   (Presumable that this is what the user types and that you named this Textinput3)

Label3.Text = COUNTA(Table1.Name)  (assuming you were stating the result from CountA was = 17)

Label4.Text = "There are " & Label3.Text & " Out of " & Textinput3.text

[PaulD1]

You can try preventing duplicated user IDs in the datasource - if you are using SharePoint, go into the settings for that Column and set 'Enforce unique values' to true.

If using SQL you can set a Unique Constraint on the column.

[dyee4613]

Oh duh, I forgot the &'s.  Thank you!

[dyee4613]

As of right now, it's just an excel sheet.

[RandyHayes]

Sorry I didn't even see the second part of your original post.

So, on your thinking, yes - that is pretty much a good way to do it.

I was thinking something like this on the DisplayMode property:

   If(Lookup(YourTable, YourUserIDColumn=WhatEverControlHasTheNewIDinIt.Text, true), DisplayMode.Edit, DisplayMode.Disabled)