label switch depending on new form or edit form

[Gazbeer]

Hi all, hope someone has a quick fix for me please

I have a gallery where it is required for the staff to enter 6 checks per day and i want it to auto increase the check number they are on, i have that working ok, I have the check number data card to auto increase by 1 on each new form, but when i go into the edit form i need to to show the actual check number saved not a +1, so could do with a formula that will switch depending if it is a new form or or edit form?

any ideas 

Cheers

Gaz

[rohentz · Accepted solution]

Hi @Gazbeer how are you? Thanks for using our community.

@Gazbeer I would like more details about what you want to achieve, but if I understood, maybe you can show the number of records on your gallery in create or edit mode. Also just do the + 1 when save the form.

But, if you need to show different values, maybe the text property can be changed . At the sample below I have just one record on my table.

Formula on Text property : Concatenate("Total - "; Text(CountRows(BrowseGallery1.AllItems) + If(EditForm1.Mode = FormMode.New;1;0)))

Sample, on new record show Total - 2

On editing record shows Total - 1

Please let me know if this information helped on your question.

Regards.

Rodrigo Hentz

Microsoft Support Engineer