"Hidden" columns in SharePoint list aren't being hidden from the form?
I have a list in SharePoint Online where users can create new list items by filling in various details within a form (using the modern experience). The list uses some workflows which required me to create some hidden columns. When the user creates a new list item, I want these columns to not be visible on the form. I'd previously configured the columns to be set as "hidden" which worked fine up until recently. Now, these columns are displaying in my form despite being set to hidden. In terms of solutions I can see that the columns are successfully hidden in the classic experience. However, when showing this site to staff I've always used the modern experience, using classic would only confuse people and also looks very dated. It was also working fine in the modern experience before. The other option is to use a PowerApp. However, the form has some append-only comments, something PowerApps does not display correctly or support currently. Any help would be great!How do I create a custom form for uploading file in a Document Library?
Hi, I noticed, with much disappointment, that when I set a column to "Require that this column contains information" in a document library, and then when uploading a file, I am not forced to enter metadata but the file simply shows "Required info" in the column. Maybe using a custom form for uploading file I can in some way drive the upload to force the valorization of the required metadata (e.g. disabling "Save" or "OK" button in the form until the required column does not contain a value). Do you think I can succeed to create such a form? Is there somewhere an easy tutorial (suitable for a non-developer person) for creating new form for built-in actions such as "upload file"? Thank you.Public form for Microsoft Lists
Hi there, we use Monday for now, but I have a look on Lists. With Monday, we can have a public form (URL, accessible for everyone. So once someone fills out the form, the data appears as a new item in the list. How do I do that for MS Lists? I figured out, how to customize the form for a new item, when you got access to the list (open the list and hit +New Item). But how can people enter data, without access to the list (not even having a company account) THANKS!
Labels automatically resizing in form design - Access 2019
Hi, Not sure if it is just me not seeing a setting somewhere. In previous versions I cannot remember this happening but it is rather annoying. When in design mode of a form, if I change the text in a label, the label automatically resizes. Is there a global setting to turn this off? This is only relevant AFAIK to Access 2019, I use 2016 on desktop when in the office or using company laptop and do not have this issue. Basically my use is within a suite of database front ends I have developed, they all have the same type of form design so I can copy a form which does a similar function from one of the databases when building a new one to add into the suite. All my labels are nicely sized so everything is uniform, but when I type a different text into the label (e.g. change from Order Number to Employee Name) the label resizes itself and I have to then resize the label again so that it fulfils the requirement of my OCD. Added a couple of example images. In image 1 I have taken a form which is used to add employee skills, made a copy and now changing this to add in an absence. Changing the label text automatically resized the label meaning I have to then go manually resize it to what it was previously. Hope that is enough info. Sensible answers only please. I could write VBA or use Access 2016. I only require a response if there is a way to do this or not, and if possible how to prevent it from happening. Thanks in advance.
Outlook template with date
Hi everyone, I'm trying to set up an Outlook template that includes an automatic date (prior date from today) within the text. For example instead of saying ''Please find attached the report from last Saturday'' It would calculate automatically what was the last saturday from today's date ''Please find attached the report from Saturday [x]'' I found that in your template you can 1. Insert/ Date and time/ Update automatically 2. Right click on your date/ Toggle Field Codes That way it displays the {DATE} field. It gives you the option to change the formatting beyond the limited choices in the dialog box. But I can't figure the formula from there... Any Idea how ? and what would be the formula ? Any Alternative ?
ACCESS Form does not show all records when Subform is present
Hi All! I'm suffering a strange quirk with my Access forms/subforms. Whenever I set up a form / subform combo the form does not show all the records it should be showing. I have 3 tables. Table_1 holds the company data. When I select one ORGANIZATION (I have 7 right now) from the yellow dropdown ACCESS should populate the CONTACTS I have in said ORG and show them as a continuous subform (CONTACTOS). I get the list should nor be longer than whatever fits above the next subform (maybe 20+ at the moment?). But it's only showing 2 (out of a possible 33). The lower subform shows all Interactions (call, visit, email, etc.) I had with that person (presently 1) that I selected in the CONTACTOS subform.. Notice there are 33 records in CONCTACTOS, but ACCESS is only showing 2. If I scroll down I can see all 33 just not at the same time. If I remove the last subform or push the window up or down or pull the first form's background up or down the number of records shown grows or shrinks. Any ideas as to why it happens and how I can fix it? I'm sure I'm missing some parameter somewhere in properties but I haven't found it yet. Can I force ACCESS to show a certain number of records? Please help! Miguel
New Item Form View
While I was trying to edit the columns and information on a list, I must have clicked on something, but now I am not getting the same format whenever I try to "add a new item" on the list. It opens on sharepoint vice a pop-up window. Does anybody know how to revert back to the original form format? Below are screenshots of how it used to look (top) and how it is now (bottom). I tried advanced settings and switching from new and classic view already and it stills look like the bottom picture. Thank you!!
SharePoint - Event Registration
Good morning everyone. I'm just starting with SharePoint at work. I was excited first Disappointed then realized that I was just ignorant 🙂 Now, I'm trying to use the Event Webpart and allow participant to register. I found a similar question answered by RobElliott here but I think it's already too advanced for me right now. I understand that the event links to a form, that this form once submitted will interact with a list and from the result of this interaction, will send a positive/negative message to the participant. Could someone guide me on how exactly to do that ?
