I'm trying to make a timesheet with a time in and a time out. I have 2 date/time fields, one that collects the time when a form is started, and the other collects the time when the form is submitted.
I want the minutes value for both fields to be limited to a multiple of 15. (EX. it will always be 8:00, 8:15, 8:30, 8:45, or 9:00)
I'm encountering a problem where the date/time that's collected isn't a multiple of 15, but it still increments by 15. (EX. It will start on 16 then it will increment up to 31)
I also have a text field to calculates the difference between those times using a method learned here which I'm trying not to break: include hours and minutes when calculating difference b... (teamforms.app)
Calculate the difference between two date/time fields | Team Forms Docs
I'm using this method with date input disabled but the value doesn't show the minutes, only the hours
I sent a message to support and got this response:
"To achieve this you will need to use JavaScript which can get a little complex. Unfortunately, we are unable to provide assistance with writing your JavaScript expressions in this chat, however we have recently launched our community forum where you may be able to post your question."
Unfortunately I don't know JavaScript, so I'm looking for either of two things. 1, a reliable source of JavaScript syntax or 2, help.
Hi, I would like to set a week range that includes the current actual date within that period in the date/time component for my staff to choose. How do I actually enable this function? With JavaScript or is there any other way?
In this use case, there is a start date, end date, and a goaled number value (must be greater than 0). if the goal value (quotaGoal) is left blank, no validation is needed. if the goal is >0, then the start date (startQuota) must be set to the 1st of the month selected by the user and the end date (endQuota) must be set to the last day of the month.
I have come up with the below validation statements to handle the 1st/last day of the month, but am stuck on how to connect them with value the goaled number field.
Start Date must be 1st of month
const date = moment(data.startQuota); const isFirstDayOfMonth = date.isSame(date.clone().startOf('month'), 'day'); valid = isFirstDayOfMonth
End Date must be last date of month
const date = moment(data.endQuota); const isLastDayOfMonth = date.isSame(date.clone().endOf('month'), 'day'); valid = isLastDayOfMonth
Thanks for any help!
Hi guys,
When I go to View Submissions, I only want to see certain columns. I've filtered out what I don't need in Choose Columns, however, when I exit this and then go back in, the default of all columns is showing again.
I've checked in Builder that Table View is turned off for certain components. Is this a bug? Or am I not doing something right?
I added a datasource to Team forms and used the SharePoint datasource as one of the fields. I am able to search the dropdown of an item. However a team member sometimes searches for an item and would not find it. I have to manually resyn the datasource in his settings to have the records update. What might be the issue that cause it? Because i always have an updated record in my setting without the need to manually resyn while he does not.
I can't modify the function or language of the bottom buttons in multi-page mode.
I wanted additional functionality for the submit button, so I created another button.
But I still can't affect the 'Submit Form' button, so the original button is still there.
This is confusing for users. It would be nice to have an option to hide it.
Having the ability to trigger a flow based on the categories of the Form would be a good feature, Would help with bulk organization of forms. See below as an example
I tried to modify the code listed as an example in the datasource settings to put a variable at d[0] to make it dynamic, but it didn't work.
When I checked, it returns up to index 49, but not from index 50 onwards.
The end goal is to get the lookup column id from sharepoint and dynamically reflect it in the child dropdown.
Is it possible to create a code that returns the index or a nearby range that I want?
What would the JavaScript code look like to prevent users from uploading an attachment that contains a special character like "'" or "&" or "%"? Where would it be added in the file object?
It would be great if Team Forms had a way to easily scan QR codes or barcodes using the devices built in camera. We user Team Forms for all our inspection forms and it would be great to easily identify the item being inspected by scanning a QR Code or barcode on the asset. This would help reduce errors in manual entry and save a lot of time!
Prerequisite:
Team Form with file upload component
Email template has been setup.
Idea:
When I submit a Team Form with a File Upload, I want those file uploads to be automatically attached to the email that is sent.
Currently:
In order to see the attachments, I need to:
Open the PDF attached to the email.
Scroll to the file upload section.
Click on the link to the attachment.
Manually download the attachment.
Then re-attach it if I need to forward those files to another email.
We created a form where the File Upload component was:
Nested in a data grid
Only displays if a certain radio button (unsatisfactory) is selected
It used to be that when uploading an image and submitting the form, the image would display in the PDF attached to submission.
Recently, it's stopped doing that now.
When a Workflow is added to a form it is next to impossible to find which workflow in Power Automate is associated with that form. If I Build the form, then select Workflow it takes me to a new Power Automate screen and in the 'My flows' menu I can see a list of flows but I have no idea which flow is associated with which Form.
In some cases a Flow may be associated with multiple forms. Can we get a view that links a flow with a Form(s) so that I can edit the correct one.
Can the Action Menu have another menu option called Show Linked Workflows (or similar).
I want to assign forms within the Team Forms to different sub-groups. I have restricted access to the forms via the config folder by assigning different SharePoint groups for each form. However, i am unable to see where to check the changes in the Team Forms app in Microsoft Teams.
Is there a way to see the users that have access to the different forms in the Team Forms app in Microsoft Teams?
My datasource has a complex set of permission levels.
So some people can see data that others cannot.
However, there may be cases where a regular user without many permissions updates the datasource.
This could result in data that should be there, but is not in the datasource.
To prevent this, I think only the team manager should update the datasource.
How does datasource sync work in practice?
I have 20 + years of experience in data collection projects. The most common activity in data collection, is to have a list of features located in a map. Where you get to the location, you click in the feature and a form gets displayed for you to collect the data. In most industries this is a key requirement. I think this functionality can move Team Forms to the next level. Being able to use a custom google map or even an ESRI data layer, will open a huge market for this product.
As a team member of multiple teams, I have too many forms with similar names. Especially when I'm using small screen (phone). I'd like to have a section where I can setup my favourite form or a filter in a team for quicker access.
how can i hide the component in pdf if the value/input is empty
We would love to get support for thai characters in the generate PDF document.
The User Component currently returns all users, even inactive users, in the "Entire Organisation" and "Team Members" Users Sources. We would like the ability to filter out inactive users based on the users AD status or the AD Group that they have been assigned. This may require enhancing the attributes that are returned via the component, and then being able to filter these attributes to remove the inactive users.
When we currently search for users in the User Component but only the first 10 values found in the list are displayed. For common names this creates some confusion to teh end user when the search doesn't return a particular persons name. We would like the ability to dynamically size how many items are displayed in the list by having a parameter on the User Component that we can set (i.e. like 100) that can be returned when a user search is performed. This functionality may also be worthwhile on other Sharepoint List components. Thanks.
Hello,
I am trying to find where i can make any user view any form submitted? At the moment users can only see forms submitted by themself