Hi community,I have a formula to combine emails from multiple columns, that generally contain multiple linked records (but not always). This REGEX formula works really well for the first 3 columns, but is failing on the final. Any help on what I'm ...
We have a load of addresses in a database. They are individually pasted into a Long Text field.The issue:Some addresses are in this format - 51A Wigton RoadCarlisleCA2 7AYAnd some addresses are in this format- 51A Wigton RoadCARLISLECA2 7AY So the di...
Hi Everyone,I am trying to create a forecasting table that will tell me how many months of cover I have based on current stock on hand. In the image you can see the fields Sock Holdings and Outbounds Forecast. What I need is to create a field where I...
Hello!I'm using a prefilled form URL field. When a customer submits a button it opens the prefilled form in the corresponding URL field.The problem is that it works perfectly on desktop, but when using App, the prefilled form formula does not work.Is...
I am trying to calculate the number of months between today's date and the "Test Date" field. When I use the DATETIME_DIFF formula it does not calculate it correctly for all values. In the Test copy column I have this formula:DATETIME_DIFF({Test Dat...
Hi, I' trying to figure out something with the form.I need my salesteam to submit sales info in the form.Lets suppoer we have to submit 2 field:1) sale price2) costI would like that after the user typing the 2 infos above, a field called "profit" wil...
I need to get the month to date total number of appointments per client, I am still not getting the result that I need I kept getting the total number since they started. Help please
I am trying to fix a formula for hours, but I can't find the error. For some reason, the last argument in an OR Formula is ignored.The base has 2 tables (Table 1 and Table 2)Table 1 has one record with the following values:Field 1 (single line text) ...
I have a base with a large table, nearly 100k records, which contains a field that we'll call "Invoice #" which should ideally be unique. Over time records have been added which use the same invoice number, and this happens through form submissions a...
BonjourJe reçois un fichier importé automatiquement avec une colonne "Date début" au format "texte sur une seule ligne" de type01/10/2024, c'est à dire jour/mois/annéeJe voudrais dans la colonne suivante extraire le mois et le passer au format "octob...
| User | Count |
|---|---|
| 900 | |
| 834 | |
| 609 | |
| 546 | |
| 354 |
