Lookup Question
I am creating a very basic set of forms and reports to track a pet food pantry program. Our animal rescue supplies free dog and cat food to those in our community who are unable to afford. I have a form that tracks their information and then a form that we enter when they pickup which has a lookup so we can tie it to the person (customer). Two seperate questions: 1) Is there a way on the pickup form that we can have it automatically indicate in a field the last time they picked up food? 2) On
Records per page report property does not work
All list reports in my application always show all records even when a 'Records per page' display limit is set in the Summary section of the Report Settings. This is a major problem because it causes reports to load slowly and greatly impacts the usability of the application. I have verified that the the report definition includes the option to limit the display rows and have tried various values, non of which work: options ( display rows = 20 ... This error also occurs when the report
Customize Layout Fails After Restore
I created an app in another account, exported to the DS file, and imported into a new file. That worked ok. However the restored app cannot the Layout or Theme. After the import it defaulted to one layout and it seems it is stuck. Any ideas?
If statement Function
I am trying to use a function to contain a large if/elseif statement and then simply call the function in the on user input of multiple fields in my form which would allow me to simply edit the function instead of editing every field when I need to make a change. My assumption is that this is possible but I'm quite stuck. I've written a simple test function using a form object and it seems like it should work but I haven't been able to figure out how to call it. Here's the function as I've written
How to programatically add one-to-many relationship??
I have a one to many relationship between Student and Course forms. Each student can have multiple Course. The intention of the following code is to test how to add multiple courses to one student. But unfortunately did not work. Can anybody tell me how to do it properly? Student.On Add.On Success: c1 = Course [Name == "Course 1"]; c2 = Course [Name == "Course 2"]; input.Course.add(c1.ID); input.Course.add(c2.ID);
Maximum number of fields in a form
What is the Maximum number of fields in a form? Thanks.
iPad: embedded report not scrolling
NOTE: This is not a Creator problem. It is a problem of rendering on the iPad and the scrolling works fine on a laptop, however I am hoping that someone can help me. Here is the problem: An embed script can be generated from a Zoho Creator report and used to embed the report into a page in a Google site. The embed snippet looks like this: <iframe height='500px' width='100%' name='reportEmbed-CLIENTRR1' frameborder='0' scrolling='auto' allowTransparency ='true' src='https://creator.zoho.com( actual
How to change display type for a relation?
Is it possible to change the display type of a bi-directional relation after it's created? How? I have a one to many relation, but i want to change it to one to many. Clicking on the display type won't do anything. See screenshot.
Importing data from excel to mandatory fields
Hi If I have a field set to mandatory, once I marry up the corresponding field in Excel to the field in Zoho creator, it fails. Is there a way around this aside from the obvious? Thanks
Form picks wrong email address
Good day, I have created a form where external parties can enter data and in the bottom fill below two fields: Send by: Pick email from drop-down Cc Receipients: Pick email from multiple select Then when submitting the form, same will be sent to predefined receipients, the sender (send by) in Cc, and then the defined Cc receipients. The first, Send by works fine and when replying to the emails, the email will reply to the actual email address stated. Howver, the Cc fields work in a strange way, as
Zoho Creator postUrl "Content Type (415)" Error
I have a simple postUrl script in a Zoho Creator App to receive an authentication key from an internal application. See below: myHeader=map(); myMap=map(); myHeader.put("Content_Type","application/json"); myHeader.put("Accept", "application/json"); myMap.put("userName","xxxxx@xxxxxx.com"); myMap.put("apiKey","xxxxxxxxxxxxxxxxxxxxxxxxxxx"); resp = postUrl("http://test.myeddy.info/habi-ws-ergon/api/v1/token", myMap, myHeader,false); info resp; However, It gives back a 415 HTTP error which I believe
Error Reference field not having the value when adding a record
Adding records fails when it involves a lookup field. Here's an example: I have two forms: Participants and Surveys. Participants has an autonumber field called Participant ID with a Deluge field name of participantId. Surveys includes Participant ID as a lookup field with a Deluge field name of surParticipantId. When the user updates a Participant record and submits the Participants form, the following is executed to add a survey with the Survey's Participant ID populated with the submitted Participant
Having trouble on edit.
Hello, I am working in a purchase order form with the following structure. Purchase order: date - date company - text provider - text email - email subform total order cost - currency Subform (in purchase order): reference - lookup to product catalog description - text cost - currency IVA - number cost plus IVA - currency quantity - number final cost - currency The form works perfect, but on edit mode I am having some trouble. The problem is that when I want to edit the Cost field or the quantity
Is it possible to Bulk Update Records so that Formula Values based on time Update?
In my app, as each month turns over, fees accrue. A formula field shows this accrual less payments already made. The value of this formula is the account balance until a new month begins. How can I bulk update records so that the balance reflects the beginning of a new month? Can such a bulk update be automatically scheduled to happen on the 1st of each month? I've been studying Functions here at Zoho Creator, but don't have a solid understanding yet. I am hoping there is a basic function code
Problem with formula
Hi, i'm having trouble using Formula for my business as investment mangager. I already created a module for "Investments" in wich i can establish the value of my clients portfolio. I just want a formula with some kind of button in wich i can add new money or interest payment to the field Cash inside my investment module. I would apreciate andy kind of help. Thank you Samuel
Record Summary Public
Is there anyway to make a record summary viewable to the public. I have a report on my website showing available inventory with a custom action to show more info by opening the record summary in a pop up. However, it just redirects my visitors to login to zoho and says they do not have permission to view it.
showing the rent amount as weekly or monthly option
I am trying to create a tenant reference form and in the form i need user to enter the rent amount as a weekly or monthly option. After user input the amount in rent amount field, i would like to achieve that user can specify the rent amount as weekly or monthly How do i achieve thanks in advance
Lookup
Can a Look Up field view more than one field? For example, if a Look Up field is to select a Device Code field from the Devices table . But the Code field is meaningless. I would like to view multiple fields from the Device list, say a friendly "Name" field and perhaps a "Room" field when we select a device, we want to store only the Code field in the Look Up field. Hopefully that makes sense?
Functions does not work at Linked View from another Application PLEASE HELP!
Dear All Please help me About this issue. This is first view from Orginal APP lets say App name APP A Here all Functions work as you see "Sevkiyat Planla" "Boyahane Planla" ------------------------------------------------------------------------- This is lets Say APP B and here you can see Talepleri is Linked to APP A (lookup). After Click This as expected view from APP A opens. ----------------------------------------------------------------------- We are still in APP B here and we have view from
Rich text editor for mobile phones
Hi Zoho, Just wondering whether rich text data input/editing capability for mobile phones is on the road map any time soon? Thanks,
Show user filter criteria of pivot chart on pdf export
How can the 'User filter criteria' of a pivot chart be shown on a pdf export? Ideally, I'd like the criteria to be the subtitle of the report. I have many assessments that users can create themselves. They see a chart of the results by choosing the assessment name from the User filter criteria on a pivot chart. Thanks!
How do I save column order and visible columns for the drill down of a pivot chart?
After clicking on a data point in a pivot chart, I can see the underlying data. By clicking on a button on the upper right of the grid, I can hide a reorder columns. How do I save this layout so users don't get confused with extra columns? When designing the pivot chart, if I click on a data point, the x and y access labels are helpfully summarized at top. How do I get the same thing in live mode? This way, those columns don't need to be shown since the values are the same for every record related
API HELP
I am trying to intragrate a creator form with Hello Sign so i can capture the signature. I have a sample POST request that they proviuded. I just dont know how to apply it to zoho... Can someone help me out please this is kiling me Example request / response POST https://[username]:[password]@api.hellosign.com/v3/signature_request/send_with_reusable_form reusable_form_id=c26b8a16784a872da37ea946b9ddec7c1e11dff6 subject=Purchase Order message=Glad we could come to an agreement. signers[Client][name]=George
Auto populate field from other form
How do I populate mileage_log_mileage in mileage_log using a value from sites_distance_from_office from sites table IF value off mileage_log_purpose_of_journey (drop down box) in mileage_log table equals "Office <> Site"
Time Zones
Is there a way of adding a Summer Time option to the Timezone settings?
Zoho Creator view: define security around view
I'd like to restrict edit-rights for a certain view. A view/report could have 20 fields, but I want the user to edit only 5 fields. I know this can be configured at the Form level, but I need to control each report/view individually. Can you guys add this feature? Thanks!
Data Entry from Different Sources. Conceptual Layout.
Hi, I've been playing with Zoho Creator for several days now, trying to figure out if its the right tool to help me set up an online database. I can't seem to get a handle on how I should lay the data out in the application, so I was hoping someone might help me with the correct data structure concept. The problem is that the data was previously stored in three or four separate spreadsheets, which need to be linked together. If this was a traditional database, we'd add foreign keys to the subsidiary
Set a rule
If I have two date-time fields in a table say mileage_log_start and mileage_log_finish. How do I ensure the entry in the finish is greater than the start field?
Image issues
New to Zoho , but I am having difficulty using the Image fields. I can not get a report to show images at any other size than small, I have applied different sizes to the form, different sizes to the report, made sure they were the same. What I really want to do is use the record summary option to customize the layout and size of my images on the report but they don't even render when I go this route. Am I missing something simple somewhere in my configuration
Video From Cellphone
The functionality to add a photo from a cellphone is really great, but can this be tweaked to include a video too? Thanks
BIG PROBLEM: Can't access my own Zoho Creator projects
Hi Zoho Support/Community, I'm testing out the free version of Creator which should allow up to 3 users. I've been working a lot in the last few days to finish a new application, and finally yesterday night I've done the first usable version. So, I was began to test the access the users access possibilities (3 at maximum at free version), and I've introduced a gmail address from a personal account. But I've found that gmail address is linked with my main zoho email (as secondary email), and now I
Subform images in report only showing first two images
I have a main form with a sub form which is used to attach images to the main form. I am try to create a report showing the details of the main form and then display all the images from the sub form. I can get everything to work as it should for the first two images but after those the third is displayed as an image icon and not the image itself. AM I missing something that is limiting the number of images displayed?
is the parameter of pageSize available in rest api view record ？
hi zoho ： is the parameter of pageSize available in rest api view record ？
Best approach to convert numbers to text in a pivot chart; if(minimum(field) == 0, 'No', 'Yes')?
I would like to show what a number means instead of the number itself. I have a survey with groups of questions. If all questions are answered 'Yes', then the answer for that group is 'Yes', otherwise the answer for that group is 'No'. Right now, each item has a score (No == 0, Yes == 1). I am taking the minimum of the score and placing that in the Color field in the pivot chart. The data is properly plotted on the chart, but the legend on the chart shows '0 and below' and 'above 0'. I would like
is there .notContains function?
hi try to check for variable - is it contain value when save script - system write that there is no such function why?
Deleting subform data with "Delete Record" task...
Hi All! I have used the "delete record" task many times by now and everything seems to be working fine. But I have encountered a problem on this spot: When this form is successfully submitted with an ID, I need to delete the record with that ID from a specific form. So far so good. But this form has subforms, so I need to manually delete their records too. I have tried the following: if (input.Form_Name == "Insurance01") { delete from Insurance_Sub[ ID == input.Rec_ID ]; Project_Name_Here
OpenURL during OnDelete -> OnSuccess being ignored
I have the following code in the On Success section of the On Delete action in a form: openUrl("#View:AQ_Report?ParentID=3007035000000362036", "same window"); It doesn't work there but the same code in the On Success section of On Add does work. Is there some way I can open a report after a record is deleted? My use case is that when the last record that matches a particular filter is deleted, I'd like to take users to the same report with a different filter. Thanks!
Pivot Chart
Hello all, I am trying to create a pivot chart to display predicted versus actual savings based on a month or a timeframe. This chart would also be able to display based on one initiative, multiple or all. It seems that you have to have your data sorted in a particular fashion in order for pivot charts to work. I have placed screen shots below of the form that I am using. The Predicted and Actual savings fields are currency fields. The "Entry Date" field only shows the date the info was placed, it
Convert Excel formulas to zoho creator automatically
Hi Is there a way to import formulas from Excel to Creator? I am trying to create an application based on an Excel sheet. The calcs are using basic addition, multiplication fields.
Filter not working on updating record
I have a field called devices_room which filters the look up based on input.devices_site. This works fine on a new entry but not when editing a record. Any ideas?
Next Page