User Profile
chudson002
Brass Contributor
Joined 6 years ago
User Widgets
Recent Discussions
SUCCESSOR TO INFOPATH
I am looking for an alternative to InfoPath. Microsoft Forms seems to be a misleading name as it is more a "Microsoft Survey". By the name, I thought this was an application where I would be able to auto-populate, attach docs, connect to SharePoint lists, etc...not the case. Again, new to the community. Any assistance would be greatly appreciated. Thanks!7.6KViews1like6CommentsBUTTON LOADING EMPTY RECORDS INTO COLLECTION - ONLY ONE RECORD IN LIST
Good morning, Have an app where a collection is loaded on the click of a button. There is only one record in the SharePoint list. When button is clicked, it loads not only the one record, but it also loads empty records. What could be causing the empty records to load? Thanks, V/R chudson002MAKE A FIELD VISIBLE WITH ONE BUTTON AND NOT VISIBLE WITH ANOTHER
Good Day Community, Have an app where fields are made visible on Page 2 by clicking an icon on Page 1 using UpdateContext. Works great. On Page 2 is another button (Submit). Need that button to hide the same fields when the submit button is selected. The fields already have "varNextvalue" in Visible from the first icon. Can't seem to get 2 variables to work for same field for visible. Recommendations...Suggestions? V/R chudson002SolvedDATEDIFF DILEMMA
Happy New Year Community, Need to calculate the number of days between Closed Out and Due AND calculate the number of days between Today and Due when Closed Out is Blank. If(ThisItem.Timely = 0, (DateDiff(Today(), ThisItem.Due, DateDiff(Today(), ThisItem.Due)))) The code does not error out, but it does not return the number of days for each formula. If(ThisItem.Timely = 0, (DateDiff(Today(), ThisItem.Due) Or DateDiff(Today(), ThisItem.Due))) Thanks in advance for assistance. V/R chudson002FILTER GALLERY NOT BY LIST
Happy Holidays Community, Two requirements needed: (1) Need gallery dropdown to display distinct names from the Gallery NOT the SharePoint list: dd = Distinct(Timeoff, Employee.Displayname). List = Timeoff Gallery = TimeoffFY22 The above works great, but pulls in names that do not need to display based on User. (2) Need names to reflect only individuals for which User() is the Supervisor of the Team... (5 Teams). The app has multiple galleries incorporating data from various lists. The common column in each list is Team. The number of employees are 62. For example, the list has 62 records and the User only needs to see the records where the Team name is the same for the User. FYI. Have an app utilizing Lookup... when the Team is selected the Supervisor name appears. Seen a lot of examples IRT filtering, etc., but, doesn't get the result needed. Any recommendations on logic? V/R CarlaCALCULATION ROUNDING UP
Good Day Community, Calculation needs to round up to the next whole number. Tried many variations, but keep getting 84 (rounding down). Text(Round(Sum(Options_1.AllItems, Value(PALT, "1") && Code.Value = "E") / CountRows(Options_1.AllItems)* 100, "[$-en-US]#")) Calculating, it is 84.61, need formula to round up to 85. Recommendations? V/R chudson002SolvedICON VISIBILITY
Good Day Community, Have an icon that needs to be visible if two conditions are met in the gallery. The below code does "not" show any errors in the formula bar, only on the gallery item. If(ThisItem.Division = "Sales" && ThisItem.Days > 145, true, false) Recommendations? V/R chudson002SolvedRe: SUBMITTING MULTIPLE FORMS
BrendanE1535, Thanks for the assistance. It put me further than I was. The above submitted every form "except" the one that was filled out. Did the above and added (!) .... and it all works perfectly!! If(!IsBlank(QtrSel1.Selected.Value), SubmitForm(Form1)); If(!IsBlank(QtrSel2.Selected.Value), SubmitForm(Form2)); If(!IsBlank(QtrSel3.Selected.Value), SubmitForm(Form3)); If(!IsBlank(QtrSel4.Selected.Value), SubmitForm(Form4)); If(!IsBlank(QtrSel5.Selected.Value), SubmitForm(Form5)); Thanks again for your assistance. This app is now fully functional and can move on to the next one. Appreciate your guidance. V/R chudson002SUBMITTING MULTIPLE FORMS
Hello Community. Current issue...Complete Form 1, submits - Forms 1 & 2 submits - Form 2 was not completed Complete Forms 1 & 2, submits - Forms 1, 2 & 3 submits - Form 3 was not completed... and so forth Need to submit only the forms that are completed. If(IsBlank(QtrSel1.Selected.Value), SubmitForm(Form1), !SubmitForm(Form1); If(IsBlank(QtrSel2.Selected.Value), SubmitForm(Form2), !SubmitForm(Form2); If(IsBlank(QtrSel3.Selected.Value), SubmitForm(Form3), !SubmitForm(Form3); If(IsBlank(QtrSel4.Selected.Value), SubmitForm(Form4), !SubmitForm(Form4); If(IsBlank(QtrSel5.Selected.Value), SubmitForm(Form5), !SubmitForm(Form5); Any recommendations? Thanks, chudson002SolvedRe: GALLERY COUNT
CountRows(Filter(TrainingTravel_1, Status = ThisItem.Filter Or ThisItem.IsSelected && 'Created By'.Email = varUser.Email)) Got the aggregated number to appear, but......... when each button is clicked, the total will appear in current, when the next is clicked, the previous returns to correct number and the next displays total.
Recent Blog Articles
No content to show