Apply one time mathematical operation to all values of a numeric field (all records)
I have a numeric field in a database that holds about one thousand records. I would like to multiply by 1.05 all the values linked to this field in all records. Is there a function that can help me achieved this without having to edit individually the 1000 records? Thanks for your help!
Can a new "customer" be added via a workflow?
I am setting up a database for our volunteers, and I'm wondering if it's possible to create new users in the customer portal via a workflow? What I'm hoping for is that once people submit a volunteer application by filling out an online (published) form on our site, our admin staff can simply click a button in the report to accept this volunteer and have a workflow create a new user profile based on the email they submitted (which would send the new volunteer an invitation email to set up their password).
the eu version of the customer portal is NOT working
Please help we are asking our customers to use the EU version of the customer portal this weekend but the portal seems completely unaccessible (while the app works fine).
Add Record Automatically in Child Form
I've searched everywhere for the answer to what seems like a simple problem but I haven't been able to find it, so please forgive me if it's already been covered. I'm looking for a way for a new record line to be opened upon entering the previous record. Is this possible? My setup is a parent form with information about the day's production and then I have a child form with barcodes/serial numbers of materials used for that day's production. I would like as I type them in for another row to appear
The add record on the new form is not working
Good day, I´m having some issues when applying the add record to a new form to add record from two different forms to create a table summarized. I have a form that has information that comes from the CRM. I have the client, the address and the project number. Let´s say that that client has two different project numbers but for sales management they only use 1. So in creator I made a form to let me enter manually as many projects as I want. Now Im trying to have a single report with the information
Hit the 5000 record update limit, need help restructuring code
I have a list of addresses that have been given an Area field (San Diego, DFW, Chicago, etc.). These areas include all the cities around the metro of those areas. We want to be able to update which cities belong in the areas, so I have a dynamic form that pulls the information and allows us to add or remove cities for the area. It works perfect for smaller areas, but I hit the 5000 record update limit on larger ones due to nested for loops. As much as I have tried, I cannot think of another way to
Script Builder not available when creating pages. Please help.
Hi, When creating new page Free Flow Script option opens and there is no option to switch to Script Builder. Please let me know how to get script builder option working? Thanks
Chained lookup in report
Hi, I have a chained lookups like this: FormA -> FormB -> FormC -> FormD I am wondering how can I built a report where I can show some fields from FormA and some fields from FormD. Thanks
Creator - custom number prefix for units
I was curious what the best way to show a units prefix at the end of a number/decimal field would be? I am looking to add fields for session durations, and right now it works okay with a number but a GREAT quality of life feature or hack would be to allow the field to show a unit similar to how the currency field shows a '$' (or your currency) at the end of it and in reports. Anyone know of a fix for this? Thanks!
Am I right that you cannot add parameters to a For Each Record formula that references a collection?
I have an HTML page that is using the For Each formula, using a collection as the variable. When I use a collection, it would appear that you cannot add the additional parameters, like sort by or range. I wanted to sort this data by date but am not able to and just want to confirm that this is correct. Thanks! Mike
Fetch Records Troubleshooting
I'm at a loss right now. I have Table 1 that lists fields ID, Length, Amount. I am trying to Fetch records into Table 2 when the ID entered into table to is equal to the ID in Table 1 and insert Length and Amount. Here is my code but it doesn't return anything x =Table1[ID == input.ID2]; input.Length2= x.Length; input.Amount2 = x.Amount;
New Page Created Just Hangs and no Deluge Tasks Available
When I create a new page, it hangs and I don't get any buttons on the left such as Insert HTML or any Deluge Tasks. It gives me this but the just shows the animated ellipsis forever. Tried it in Chrome and Safari and same result.
How to limit image size from image field in a record summary?
Hello, I am trying to build a Record Summary template to show a summary of a form which includes several types of fields, including a couple images taken from the mobile app. The size of the image in the summaty varies depending on the phone the picture is taken from. Is there a way to standardize or limit the size of the images in the record summary? Ideally, to have it limited by default in the summary, to be able to generate the report directly? Right now I get huge images in the record summary,
Creating a record and checking if one already exists
I have a referral form set up with a custom approval process (couldn't use the built in one because the referral form is published, and still needed the approval functionality). Once a referral is "approved" the deluge script creates a new record in our "main profile" records for the family being referred, and it populates the new record with information submitted in the referral form. My question is - is it possible to include some way to check first if there is already a record with the same
Upload field in stateless form
Hi -- From this thread, I understand it's not possible to add an upload field in a stateless form. Is that still true? I don't really understand why, but is there a workaround to this?
droplist field selects
Can the droplist field's choices be used as a list?
How to obtain data from USPTO APIs
Hi, I am planning to obtain data from the USPTO database using its API however, I can't seem to find an easier way on how to do it in ZOHO Creator. Note: I'm just a newbie in creator and with API, but I am more than willing to learn. I hope someone has their way on how to do it the newbie way. :) Thanks in advance!
select command to set a choice in drop down of a subform
Hi, I have a drop down list in subform which is dynamically populated when the record is added. However when the record is edited, only the selected option remains and other other options are removed from the drop down so the user is not able to select another option. I do not know why the drop down is not populated. As a I am re-populating the drop down, the original selection is lost. When I try to save the selection to a variable and then use select command to assign the same option, it gives
Integrating Zoho with e-commerce platform
Hi, I would like to integrate my e-shop with Zoho. For sure it's possible using APIs from Zoho and from my e-shop and then have some server that will wait for new orders to arrive. I am wondering if there is any possibility to use Zoho Creator for that. It will communicate with my e-shop's API to get new orders, clients, etc. Is it possible to create this kind of app or is it only possibly via CRM API? Thanks, regards
Creating report with data from two forms
Can we make reports with two forms. 1. I have student Form, 2. Attendance form in which we enter day-wise hours attended and payable hours and 3. Payment Collection form in which we enter course wise and month wise payment details. We want to see in one report Student wise, course wise total hrs attended in a month and collection from every student in that month to see who have not paid corresponding to hrs. attended. Pls advise how this can be acheived.
Introductions of functions
Are there the introductions of all those inner functions?
Read data from uploaded CSV into existing log or sheet
Hello, I am needing to allow employees to upload a CSV file into a form/app. Once the form is submitted, I need the uploaded CSV file to be read and written to an existing log or sheet. I figured out how to get the CSV to write to ZOHO Sheets/Docs while using forms, but it saves each of the CSV files to a separate sheet, while I need one to be appended with each new submission. I have also tried to figure this out with using deluge scripts in Creator, but have had no luck. I don't have a preference
Upload File to Zoho Docs via Zoho Creator
Hi Is it possible to upload File of Zoho Creator form upload field into the Zoho Docs.
Customer portal access problem error "400 Bad Request"
Hi, Customer portal access reply error "400 Bad Request" and Android customer portal app doesn't work. Regards,
Some basics questions about zoho Creators
Hello to all, I am new here and i have a lot of questions but first at all i will start with some. I need to create an app (website) call it in any ways but i need to do something in particular. The app need to record same entry like name, surname ect, but i need that particular app (website) be used but 100 user (moderators) at the same time. So maybe the 100 users at the same time will add information (new entry, registration), and only one Admin. Is that possible this zoho creators? Thanks a
Display multiple images and ask for feedback based on these
Hi all, I have a project where we collect photos of a particular property and these photos are saved in Zoho Creator. After photos are uploaded a user needs to give feedback on the property based on these photos. For instance, there might be a form asking; Does living room require refurbishment Yes/No Does bathroom room require refurbishment Yes/No Does bedroom room require refurbishment Yes/No The user who is going give the feedback should be able to see the photos
Grouping records of subform on Record Templates/Summaries
Is there a way tu group results from a subform on a record template/summary? Let's say subform has columns A, B, C, D. I want to group records of the subform on the record template/summary by column A and to show them just like when you group them on a report. Regards, Antonio Contreras
Incomplete translation of the mobile app (Zoho Creator Portal)
Hello Everyone, i have the following problem. I have set the language to German. Now everything is translated as it should besides the system aprroval pages in the Zoho Creator Portal mobile app. This only occurs in the mobile app (iOS and android). The Web-App is translated fine. Also i haven't found an option to manually translate these as i can for my created forms,reports and pages. Thanks in advance! Jan
Could not publish application to client
Hello Everyone We have some problem with publishing our app to another client. We want to create test app to communicate with out system and after that publish it in Zoho marketplace. But first of all we want just test it. When I click "Publish" in Publish to Client I get "Could not publish application to client". What does it mean? We will be very pleased to get some help. Thanks in advance
Make a field mandatory only if it is visible?
In some instances a field will only be shown if it is required. Is it possible to set it as mandatory only if it is made visible? Can the mandatory attribute be scripted?
How to create a machine usage report based on date interval records
We have records of usage of a tractor like: Tractor Initial Date Final Date Farm A jan-1 -2019 jan-15-2019 Sun Valley A jan-16-2019 jan-31-2019 Green Lake B jan -10-2019 Jan-20-2019 Green Lake B Jan-21-2019 Jan-31-2019 Sun Valley C Jan-30-2019 Feb-10-2019 Sun Valley And would like to create a report like: Date Tractor in Use Jan/1 1 Jan/2 1 Jan/3
How to disable some values of radiobutton ?
I have 2 radio buttons (RB). 1 contains : HN and SG. Other contains : 1, 2, 3, 4, 5. If RB1's value is SG. Then in RB2, u can choose only 3,4,5. U can't choose value 1,2 unless RB1's values is HN. Can anyone help me solve this problem ?
Customer Mobile Portal
Hi, I'm testing Zoho Creator to build apps for my business with a trial account. I'm trying to give access to a test customer to the mobile version of the app we are developing but I can't find how. Zoho Mobile Creator is for company users (and it works fine), not for customers, right? If I open from a mobile browser xxxxxxxx.zohocreatorportal.eu the pages are from the desktop version of the site, not the mobile one. Mobile version of the site xxxxxxxx.zohocreatorportal.eu has another url? Thanks
Customer portal, one user enters data for another user, possible?
Hello, I created a customer portal with 2 user permissions, player and host. The player has a username and plays a game. The host will enter the username of the player and add a score. The host should be able to see all records of all players. I would like the player to be able to see only the data that the host entered that matches this player's username. Is that possible? Thank you
Zoho Creator IOS 5.12 app broke our app
FYI. Any iPhone that we upgraded to Zoho Creator 5.12 over the last few days has stopped working with our app. We can see records in a report list as normal, but when we try to edit or create an new record - none of the fields are showing in the form. Is there a way to rollback to an earlier version? Googling that next.
Display Nested Subform values in Record Template
Hi, having a really hard time with this. In Parent form is a subform with most fields hidden, and a decision box. Clicking the decision box invokes OpenURL to display the full subform and allow the user to create/edit each row of the subform and interact with a nested subform within the subform. The issue I'm having, is displaying values from the nested subform in a record template. Any ideas for displaying subforms within subforms on a record template? Thanks! Levi
JSON from exported views starts with parenthesis but does not close
Hi all, I have a problem consuming my exported views because JSON data starts with a parenthesis but does not close and causes "SyntaxError: missing ) in parenthetical". My following URL: https://creatorexport.zoho.com/showJson.do?fileType=json&sharedBy=f1ps3online&appLinkName=campeonato&viewLinkName=ANUNCIOS_Json&privatelink=vfWCWZSbg48jYC4495dkZWjKqN2Pp3zyyuenyZ56KdFA6QPfExM5aJB9h1HF52vedz4ZmC70bxr1WRqGpwGG7WWNMW7m8nKCS7AD&callback=? Returns: ({ "ANUNCIOS": [{ "ANCHO": "", "SECCION":
Is it possible to search the custom filter list or use a dropdown box to select an item from the list?
We are going to add at least 30-40 items into our custom filter list and it would be really very helpful to the end user to be able to search inside the list and also be able to select an item based on the partially entered search string results. As a second solution the user could also select their list from a dropdown list of the filter items. Are these type of custom filter options possible to perform on Creator?
How to generate report per month with an start and end date only?
Hello, i have a problem on understanding the best way to achieve something that i think could be simple: My students have an enrollment start and end date that can span up to six years. I want to show one year the months and the number of students on each month. I can't use the start date only because it will show count the student only in one month, same with the end date. I want to generate a chart like the one that follows. Now, this chart is working but in a horrible way. Once a record is made
Zoho updates
One of our users in the field starting getting the following error this morning: XML document structures must start and end with the same entity. Screenshot of his error attached. Nothing has changed with our app. The users use the app to pull up existing records and update with inspection data. The fill in a few fields and upload pictures as needed. Other users are having no issues. I've had this user reinstall the app, etc. He's on a recent iPhone. I've submitted a request to support early
Next Page