Join the Team Forms community

New

How do i make the label of a table display on form. Like a Survey does

J
Jade
A
Solved

View Submissions Filter

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?

2 comments
A
A

Hi there,

I have one form where the user selects the purchase number from a drop down list using the sharepoint data component in team forms and i want to remove this add another button and once the user selects the purchase number it should automatically displays all the multiple items ordered without having to click on the add another button.
Any suggestions !?

I have created three forms which are linked to one another, in which first form takes the input of supplier name and based on selected supplier, the user can select the items sold by that particular supplier For eg, Dell (supplier) sells Mouse, keyboard, Monitor, Laptop (Items sold by dell supplier which will be shown in items list) and when the user submits it'll add entry to excel as:

OrderID | Supplier | Items ordered | Quantity
01 | Dell | ["Mouse","Keyboard","Monitor","Laptop"] | [2,3,1,5]

Now in second form there is orderID drop down list and when the user selects the ID - 1, he can input the purchase order number, which will shown in same excel sheet and adds the purchase number as:

OrderID | Supplier | Items ordered | Quantity | Purchase Number
01 | Dell | ["Mouse","Keyboard","Monitor","Laptop"] | [2,3,1,5] | PN-0001

My query is that====>Now, In my last form i want to show these items in separate rows for eg, the user ordered 2-mouse, 3-keyboard, 1-monitor, 5-laptop SO, i want to display these as:

OrderID | Supplier | Items ordered | Quantity | Purchase Number
01 | Dell | "Mouse" | 2 | PN-0001
01 | Dell | "Keyboard" | 3 | PN-0001
01 | Dell | "Monitor" | 1 | PN-0001
01 | Dell | "Laptop" | 5 | PN-0001

Because, based on the above table in excel in third form i have third input field where i have to write the received quantity like how much quantity of items the user received and corresponding to the items it should display the input field.

2 comments
E
A

how can i hide the component in pdf if the value/input is empty

2 comments
A

When using a Number element, I can't seem to type any number after entering a '0'. If I type 1 or any other number, it seems to work fine.

1 comment
A

A valuable feature would be the option to manually type the barcode, as it can sometimes be challenging to scan accurately.

1 comment
A
S
Steve
E
Solved

score survey

Hello everybody,

I'm trying to build a quality control form. So far so good with the form but I can't figure out how to add scoring to my form.



The build looks like this :



Each value is unique and I'd like to say :

if value options1 == Yes 1 point

Ifnot == 0 point


I tried to follow the following help https://help.teamforms.app/en/articles/9127420-calculating-a-score-based-on-users-response

But I don't understand under which tab I should put the formula and what to do in the API tab ?



So far my code looks like this :


Java
value = 
  (data.changersacpoubellesfixesmobiles === 'oui' ? 1 : 0 )
+ (data.ramasserdechetsvoiescirculation === 'oui' ? 1 : 0 )

and I have the following errors :

  • Property 'ramasserdechetsvoiescirculation' does not exist on type 'Data'

Java
This comparison appears to be unintentional because the types 'Record<"changersacpoubellesfixesmobiles" | "ramasserdechetsvoiescirculation" | "controlerEtNettoyerLesTachesDeLiquide" | "nettoyerLesTracesDhuileAuSol" | "nettoyerLesPlaquesDeSignalisation" | "nettoyerLesVoiesDeCirculationEtLesPlacesDeParking" | "nettoyerLesCirculationsPietonnesEnDallesEntreePersonnelEtVisiteurs" | ...' and 'string' have no overlap.(2367)



Thanks in advance !

2 comments
E
S

Is it possible to show the form Submission number in a Power BI report. Neither the Forms nor Submissions tables have it as an option.

2 comments
R
T
K
Katia

Hi,

How can I display the name of the location chosen in the Address component? Only the address is displayed.

In this example : I would like to display "Cimetières d'Ixelles" + address


Thank you in advance.



When we submit multi photo uploads within a data grid it doesn't seem to create a new page per photo, it just cuts them off. can this be fixed?

1 comment
E

Introducing the Barcode Scanner Component!

A
Anthony Phan
Aug 29, 2024

1 comment
J

Hi,

Our SharePoint data source list uses people picker columns. When trying to access the data in those fields it just returns the "LookupId" of those fields instead of the name.

Is there a way to access other information than just the LookupId saved in those fields?

10 comments
D
E
A

I'm trying to hide the Border around the input on the PDF. Is there a way to achieve this with Custom CSS?

3 comments
E
T



When submitting, most people see this big green circle and close the window.

But underneath that, the submission is still uploading for three or four more seconds.

Even if the submission doesn't complete properly, the workflow starts and messes everything up.

Until the submission is completely finished uploading, make sure the submission animation doesn't mislead people.

1 comment
A

Could someone give me the path on how to make a simple protocol query form by querying a table in Excel? The table would only have Protocol and Response. Enter the protocol and I will show the corresponding response.

1 comment
E

It would be useful to be able to define default settings for certain components within our own tenant.

Currently I need to manually adjust certain types of components every time they are added to a form. For example, every time I add a File Component to a form, I perform the following tasks:

  • uncheck "Show Image Editor"

  • input details to "File Pattern"

  • input details to "File Maximum Size"

  • check "Required"


It would be convenient to be able to adjust the default settings once, and have those default settings applied to each new instance of the component.

When using the Email option while building a new form I want to use the /Title in the Subject line of the email, but when the email arrives the /Title field includes the Submission number for that for as part of the Title.


How do I just get the Title, no submission number?


Ray

4 comments
A
R

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?


2 comments
A
H

I know that we have the ability to capture GPS in the longitude and latitude format BUT I need to transform this to a regular street address. Any plans for this? Or low code options?


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

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.