Join the Team Forms community

T
S
A
C
H
New

I'm trying to generate a numeric Risk Rating based on two text values that correspond with a numeric value. For example a Likelihood of Rare, Unlikely, Possible etc. Also, we have a Consequence of Critical, Major, Moderate etc. When the two are in a matrix the X and Y values give a Risk Rating. The higher the Likelihood and the higher the Consequence means it's a higher risk. How do I generate a matrix based on two values to produce a single result.

Example below.

The numeric value is probably not needed, even the rating alone will be OK.

Open to any suggestions.


Thanks.

5 comments
R
A

Hi There !

Is it possible to custom the submission Number ?

Here my need :

I would like to customize the submission number with elements that make it easier to find a form in SharePoint.

For example, in the form, I generate a reference; can I use it as the submission number?


1 comment
A

Monitor and Re-trigger Workflows with Ease

A
Anthony Phan
Sep 28, 2024

When creating an email template using data from the form, I use the / to get a list of my fields which shows me the correct field names as used in the Label setting (for the Select Box component.)

I have 5 fields that use a numeric value to populate the email with a qty requested for each option. When I type the / I get the correct field names, I select the one I want and then the email designer will show something totally different as a field name (in green). This has now given me three duplicate field names (out of 5), but when I submit the form the workflow runs, sends me an email and lo and behold the values are correct.

Example below:

The values for testing are the values 1 through 5 top to bottom. The fields are NOT supposed to be duplicated.

When the email arrives this is what I get:

Based on the design I should have got 1, 2, 2, 1, 1

Any idea why this is doing it?


Ray

12 comments
R
E
A

If a user saves a form, or doesn't submit it, when they next access the form the system indicates that the form is still "draft", or not submitted. We have a number of users that go back into a form thinking that it is new (i.e. just created) and update the previously saved form not realising it.

K
Katia
Under consideration

Add a datatable component

Hi everybody,

It would be nice to use a data table component with options like filterable, sortable, submit selected rows, actions buttons,...

And it would be nice to be able to connect it with a datasource.

An example:


Is it possible ?

Thank you.

There doesn't seem to be a way to undo accidental changes (like deleting a component) when building you form. This makes building very difficult. We really need the ability to easily undo changes on the fly.

1 comment
A

Introducing the undo button!

A
Anthony Phan
Sep 28, 2024

+1

This is Based on a Quoting System we would like to implement. Is it possible to enable Editing a content component during submission of a form similar to a text area? I would use a Text Area but I need it to remain as a certain Format.

I'm currently using Dynamic Fields to updated certain parts of the Content Component but sometimes we require Additional Information and changes to the Content Component per Quote

5 comments
E
T

Hey, Is it possible to Use content component Image to take up the entire PDF Page? I want to use it as a sort of Cover Page.


It is also possible to target only certain pages on the PDF template editor?


4 comments
E
T
J
J. Scott
Under consideration

Submission Deletion

It would be nice to be able to delete more than one submission at a time.


Thanks

1 comment
A

I am building a Data Grid that has multiple components on it and when the component labelled 'employees' is changed, I want the entire row to be updated to reflect different data that I have mapped from data sources.

Running the following line sets the entire Data Grid to the row that I wanted set,

Plain Text
      instance.root.getComponent('DataGrid').setValue(updatedRow) 

however I can't find a way to update just the row that the change is happening in.

3 comments
C
A
G
Glenn
Under consideration

Additional Filter Options

It would be great if responses could be filtered by some of the data entered by a user, for eg. a specific Text Box within the form. This would make searching for a specific completed form easier as you could essentially filter by a customer name or Site.

At the moment the limited filter options make it very difficult to find a p[previously completed form.


2 comments
G
E
T
Toni Koenen
A
Solved

Assign a form

Is there a way to assign a form to someone?

1 comment
A

Hi

I need to have submission edit mode enabled in my form. At a certain point I want to be able to lock the submission from further editing. How can I achieve this?

1 comment
A

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.

1 comment
A

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.

2 comments
A

Hi,

So, we have already double tripple checked the particular column in our SharePoint Data Source and there is no typo or anything. We even removed it, repasted it, completely certain. And Remove Duplicates is turned on, but in the drop down there is still one duplicate.


How to fix this problem?


Best, Damon

8 comments
D
E

Similar to how you can currently pin a form to a tab in MS Teams, there should be a way to pin the results of a certain form to a tab in Ms Teams

2 comments
E
M


I created the following dual actions on the button, with the 'show validations' option turned on.

However, if the validation fails, the other actions are still executed on click except for Submit.

I don't want to use the 'Disable on invalid forms' option because it doesn't show me the invalid components.

How do I make sure that all actions are only executed if the validation succeeds?

2 comments
M
E

Hi everybody,

I would like to limit the address component to 2 or 3 cities in Belgium.

Is it possible?

Thank you in advance.

Katia

1 comment
E

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)




1 comment
E

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.

1 comment
E
A
Arvind
E
Solved

Date Range

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?

1 comment
E