How-to questions

Hi! Don’t forget to take a look in the Knowledge Base for answers to common questions :)

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Previous value of a checkbox with app script?

    Is this possible? I've tried testing for null and empty string both with and without [ ] like you need around ['Yes'] when testing current value.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. keep

    I have a (parent) table ID that was setup using a calculated field that may change value. I'd like to create an autocounter field that would have unique values and wouldn't change and then re-map the relationships. Is there a way to set a field in the child table to a calculated result, before I change the field ID for the parent table? Are parent child relationships stored else-where or am I seeing all of the available fields in the table?

    Thanks.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  table relationships  ·  Flag idea as inappropriate…  ·  Admin →
  3. do I use an existing field as the link to child table?

    for example I have a list of patients with their bed number. I have a table of bed #'s with with details about the bed (Room #, Floor #, Dept etc). When I create the relationship it adds another "link to ..." field. I just want to use the existing (unique) bed number as my link.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  app building  ·  Flag idea as inappropriate…  ·  Admin →
  4. Max Function and Dates

    I have a max function that returns the "highest", or most recent, date. However, what gets returned is the max date minus 1 day.

    For example, the highest date is 4/20/2014. But 4/19/2014 is returned.

    Is this a bug? Or how can I fix it?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  formulas  ·  Flag idea as inappropriate…  ·  Admin →
  5. How do I get the lines to show in my chart table?

    How do I get the lines to show in my chart table?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  6. create a template for exporting a record as a PDF / word document?

    I'd like to create quote / order documents for a CRM application

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  views & charts  ·  Flag idea as inappropriate…  ·  Admin →
  7. Is there a way to add a new dashboard to all roles?

    When I create a new dashboard I often want to assign it to all roles. It's a bit tedious to assign it to each role individually. Is there a way to just assign to all roles?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  user management  ·  Flag idea as inappropriate…  ·  Admin →
  8. calculate the total amount from a column, not a count of what is showing information?

    I would like to be able to calculate a total in a column, i.e. column shows amount of Disposition, would like a sum at the bottom showing the total of all those claims.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  formulas  ·  Flag idea as inappropriate…  ·  Admin →
  9. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  app building  ·  Flag idea as inappropriate…  ·  Admin →
  10. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  formulas  ·  Flag idea as inappropriate…  ·  Admin →
  11. Calculate Remaining Balance

    I have a view where I can see a client's Total Cost, Deposit they paid and their Remaining Balance (I have Balance set with the formula Total Cost - Deposit.) When a client wants to make a partial payment, how can I do that and have the Remaining Balance calculate that?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  formulas  ·  Flag idea as inappropriate…  ·  Admin →
  12. Signature

    Can you add a signature field?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  forms  ·  Flag idea as inappropriate…  ·  Admin →
  13. manage users

    I do not have the option to manage users (only : My Profile - Sign out). How can I add a new user? Thank you

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  user management  ·  Flag idea as inappropriate…  ·  Admin →
  14. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  user management  ·  Flag idea as inappropriate…  ·  Admin →
  15. Avoid time while Concatenate multiple fields with Date field in it

    I'm trying to concatenate three fields, where one is Date field. but when I concatenate the date field,it is adding time with it.why is it happening?I just want to add date only. the Field is also Date not Date and Time.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. Show all tabs at the top of the App?

    When I am in an App, I can only see four (4) tabs that each show me a view. But we have nine (9) views and I have to click the "More" tab to select the others. Is there a way to show all tabs?

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  17. Copy/share a list of dropdowns in a table?

    In my database application, one table, I have 3 columns which are calling for states, because there is a project state, there is an address of the engineer and there is an address for the owner. Currently, I have to go in and manually enter the dropdown for each columns as 50 states in US plus all Canadian province. If there was a feature to copy or share the list choices in the table, or among different tables, it would be greatly useful. Also for standard fields like US states, if it was a pre created dropdown, I could use,…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  app building  ·  Flag idea as inappropriate…  ·  Admin →
  18. Set calendar to week or day

    The calendars are all set for Month. If I change it to Week and then go into view an event, when I come back to the calendar it's set back at Month again. Would like to set my calendar for Week, and it stay on my preferred view.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  views & charts  ·  Flag idea as inappropriate…  ·  Admin →
  19. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  app building  ·  Flag idea as inappropriate…  ·  Admin →
  20. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  formulas  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base