E.T.
-
If a text field has > 30 '#' then show alert
Wondering if there's a formula that will check a text field for the number of hashtags (#) and if there's more than 30, allow to pop up an alert or have field become visible alerting to the fact?
-
Logged into same account from multiple locations
Just wondering if its possible to have the same cloud account logged in on multiple devices? Not necessarily cloud/ipad etc, but more along the lines of multiple computers logged into the cloud…
-
Show date when # turns < than #
I have a formula that turns yellow when stock is low, and red when we need to re-order. I'd like to show the date that happens as we don't always see it as soon as it happens.…
-
show last where choice =
This is so obvious, I know it, but I cannot for the life of me get it to work. I have a column in a view that has this formula: last(BLA.'BLA Form'.BLA.…
-
Print to PDF not working correctly for 1 person
We have a manufacturing system in place, where a staff member in China has to accept or reject orders. When she accepts an order, its meant to create a signed copy of the form thats initially sent to…
-
How much do formulas slow the database?
Just wondering how much of an impact formulas have on the speed of the DB (we use cloud based), and is its bad practice re speed to use formula fields with html/css styling to create buttons and…
-
Re: Is there a way to enforce the required fields so a record row will not be added unless all required fields are completed?
Could the formula solution provided by Antonello be used globally? And used to style the entire database? Wondering if that would cause issues with the speed of the database? -
Linked table view/custom view not showing columns
Have this weird thing where the view for a linked table, or even a custom view, isn't showing specific columns I've selected. They're jsut based formula fields,…
-
Formula - move record to another table
Hi all I have a Quotes table and an Orderstable. I'd like to add a "Convert To Order" button to quotes. I've gotten part of the formula working, but my issue is with the line items.…
-
Best Practice - Forcing search results - formula vs update text field on trigger
Hi all At the moment, to make results appear how I want in search/lookup functions, I have 7 formula fields at the top of the form that contain info I want to appear in the search.…
-
System for multiple "guest" users?
Just wondering if anyone has any recommendations for a "guest" user system? I want to create a way for distributors/wholesalers place orders with us. One option is a form connected to our DB via…
-
Increase number by decimal
I thought I posted this but, can't find it so here we go again... I have a version number field, which when I create a new record I need to automatically increase by 0.1.…