This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello communityi am using a regex extract formulato fill formula fields from a lookup field. the formula works well. But I have 5 formula fields and when the character string separated by commas only has 3 elements, the other two fields refer to the ...
hello community What would be the formula for to extract from the rollup field "participant name (from imported table)" the names entered in this field and to report them individually in the formula fields, do you have an idea of the formula to use t...
Hello, I want to extract from the rollup field "noms des participants" only one of these data for which appear in the fields "Nom Prenon 1" "....2" "....3" "....4" ..... VUE https://airtable.com/shroD4pRoA52pXcg6Thank you for your helpFranck from FRA...
Hello, I want to use the view timeline with the utilization bar. My timeline view allows me to assign tasks to employees. Employees have unavailable days. So I can't assign them spots during this time. The Unavailable Days Utilization Bar only appear...
Hello, In the timeline view is it possible to display
in the summary bar in use mode utilization a color when an employee is unavailable
Merci beaucoup for your help
Franck
HelloBut here is the problem I encounter on fields that do not contain dataExLookup containsALLIE Pierre, BELUFFI Maeva, MUD AdrienFormula 1 field 1 =ALLIE PierreFormula field 2 = BELUFFI MaevaFormula field 3 = MUD AdrianFormula field 4 = nFormula fi...
HelloBut here is the problem I encounter on fields that do not contain dataExLookup containsALLIE Pierre, BELUFFI Maeva, MUD AdrienFormula 1 field 1 =ALLIE PierreFormula field 2 = BELUFFI MaevaFormula field 3 = MUD AdrianFormula field 4 = nFormula f...
I found the solution by adding "ARRAYJOIN" in the formula.Modify location 1 ([^,]+,?){1}") to extract the rest of the string in the following fields. The formulaREGEX_EXTRACT(ARRAYJOIN({Participant nom (from Imported table)}),"([^,]+,?){1}")best rega...
I found the solution by adding "ARRAYJOIN" in the formula.Modify location 1 ([^,]+,?){1}") to extract the rest of the string in the following fields. The formulaREGEX_EXTRACT(ARRAYJOIN({Participant nom (from Imported table)}),"([^,]+,?){1}")best rega...
I found the solution by adding "ARRAYJOIN" in the formula.Modify location 1 ([^,]+,?){1}") to extract the rest of the string in the following fields. The formulaREGEX_EXTRACT(ARRAYJOIN({Participant nom (from Imported table)}),"([^,]+,?){1}")best rega...
