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?
Solved! Go to 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
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
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.
Oh duh, I forgot the &'s. Thank you!
As of right now, it's just an excel sheet.
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)
User | Count |
---|---|
206 | |
99 | |
91 | |
46 | |
43 |
User | Count |
---|---|
251 | |
105 | |
104 | |
65 | |
56 |